OraFAQ Forum: Networking and Gateways » setting of environment variables

Home » RDBMS Server » Networking and Gateways » setting of environment variables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

setting of environment variables [message #665253]

Mon, 28 August 2017 02:12

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

Littlefoot
Messages: 21782
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I usually do it like this.

Report message to a moderator

setting of environment variables [message #665266 is a reply to message #665253]

Mon, 28 August 2017 07:14

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.

Report message to a moderator

Re: setting of environment variables [message #665267 is a reply to message #665266]

Mon, 28 August 2017 07:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://lmgtfy.com/?q=connect+to+oracle+10+xe

Report message to a moderator

Previous Topic:	ORA - 01017 invalid username/password while creating a shared public database link
Next Topic:	Listner Service gone missing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 28 13:20:40 CDT 2023