Home » RDBMS Server » Networking and Gateways » setting of environment variables
setting of environment variables [message #665253] Mon, 28 August 2017 02:12 Go to next message
adil shakeel
Messages: 47
Registered: August 2017
Member
hi all

Please guide me how to set the environment variables for connection of client pc forms with oracle database onto the server.

where i have to write the following command?

set TNS_ADMIN=%ORACLE HOME%\network\admin


[MERGED by LF]

[Updated on: Mon, 28 August 2017 09:39] by Moderator

Report message to a moderator

Re: where to write set TNS_ADMIN=%ORACLE HOME%\network\admin [message #665258 is a reply to message #665253] Mon, 28 August 2017 05:43 Go to previous messageGo to next message
Littlefoot
Messages: 21246
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I usually do it like this.
setting of environment variables [message #665266 is a reply to message #665253] Mon, 28 August 2017 07:14 Go to previous messageGo to next message
adil shakeel
Messages: 47
Registered: August 2017
Member
I am using oracle 10g express edition.

I have one server and one client machine with wired network.

The software is running ok onto the server.

But i am unable to connect the client machine's forms with the oracle database installed onto the server pc.

I picked the transnames.ora file from the server pc from the following location:

C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN

AND THEN I PASTED THIS FILE AS IT IS INTO THE FOLLOWING LOCATION IN THE CLIENT PC.

C:\orant\NET80\ADMIN

but the forms onto the client machine are not connected to the oracle database of server.

Plus if there is another way rather than replacing transnames.ora file then just guide me about that method.

As you were talking about setting the environment variables.
Re: setting of environment variables [message #665267 is a reply to message #665266] Mon, 28 August 2017 07:21 Go to previous message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
http://lmgtfy.com/?q=connect+to+oracle+10+xe
Previous Topic: Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"
Goto Forum:
  


Current Time: Fri Nov 24 17:54:11 CST 2017

Total time taken to generate the page: 0.01863 seconds