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: 21806
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: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://lmgtfy.com/?q=connect+to+oracle+10+xe
Previous Topic: ORA - 01017 invalid username/password while creating a shared public database link
Next Topic: Listner Service gone missing
Goto Forum:
  


Current Time: Thu Mar 28 16:57:58 CDT 2024