In your OrCAD schematic the voltage-controlled voltage source E1 is wired incorrectly; you've swapped the inputs and outputs. On part E1, the terminals with the circle are the part's voltage outputs.
In your OrCAD schematic the negative input terminal of the voltage-controlled voltage source E1 should not be connected to ground; it should be connected to the right hand side of resistor R2—i.e., to the circuit node that connects components C2, R2, R3, and C4. (Note that in the original figure, voltage v is the voltage drop across resistor R2; it is not the voltage from R2's left side to ground, which is how you've wired E1's inputs.)
I'm not sure why you've added capacitor C4; that part isn't shown in your original figure, and its presence alters the behavior of the original circuit—i.e., the original circuit and your OrCAD circuit are not equivalent due to the presence of capacitor C4.
If you want to run an AC analysis of the circuit (e.g., an "AC Sweep/Noise" frequency analysis), your voltage source Vin should be an AC voltage source that's compatible with AC Sweep simulations, and not a DC voltage source (VDC) which is what you are currently using. In older versions of PSpice the AC voltage source parts that should be used with AC Sweep analysis are called VAC or VSRC; in present-day versions of OrCAD PSpice you can also use a part called VSIN. For what it's worth, when performing an AC Sweep analysis, I usually set the AC voltage source's amplitude to 1 Volt for mathematical convenience (e.g., voltage gain = 20 log (Vout/Vin), and with Vin=1V this simplifies to voltage gain = 20 log (Vout)).
Also I changed the GAIN of E to 100000, does that work?
Yes. You could also specify the gain value as 100k or 100K with no spaces between the '100' and the 'k'.
One side comment. The SPICE language is case insensitive, so the units prefixes 'm' and 'M' are equivalent and both mean 'milli'—e.g., 0.001 = 1m = 1M = 1E-3. If you need to specify 'mega' (e.g., megaohm), type 'meg' or 'MEG'—e.g., 1000000 = 1meg = 1MEG = 1E6.