OraFAQ Forum: Server Administration » How to create tnsnames.ora

Home » RDBMS Server » Server Administration » How to create tnsnames.ora

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

How to create tnsnames.ora [message #207890]

Thu, 07 December 2006 04:33

oracledba_raja
Messages: 23
Registered: July 2006

Junior Member

Hi All,
Good Evening.

I installed the Oracle 9i client s/w in my PC.

During the installation process, when it asked for Host name and IP address for net configuraion, I just exit from it.
Because I don't the IP address and SID of the Server.

Now, I know abt it.

But, I am quite confused, when going thru net configuration.

To have tnsnames.ora, which is the right way to go?

Please guide me.

Thanks a lot.

Thanks and Regards,
Raja.

Report message to a moderator

Re: How to create tnsnames.ora [message #207893 is a reply to message #207890]

Thu, 07 December 2006 04:40

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Using the GUI tool is simple method.
But it is not that difficult to it manually Smile

Just edit the tnsnames.ora in $ORACLE_HOME/network/admin

Report message to a moderator

Re: How to create tnsnames.ora [message #208000 is a reply to message #207890]

Thu, 07 December 2006 14:29

Admin@Lightsql.Com
Messages: 36
Registered: November 2006

Member

Using the net configuration, you can try this way.

1. Machine name : You local machine name
You go to control panel -> system -> computer name
You will see full computer name, i.e. your machine name

2. Ip Address: you can give the LOCALHOST ip address (127.0.0.1).

You can setup the tnsnames with localhost address also. There by oracle local client talks to your local server.

Good Luck,

Jay
Fun Programming with Oracle & Visual C++, Author of http://www.lightsql.com.

Report message to a moderator

Re: How to create tnsnames.ora [message #208266 is a reply to message #208000]

Fri, 08 December 2006 23:13

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

as mention others.

Because I don't the IP address and SID of the Server.

for IP ADDRESS
start----> run ----> cmd <hit enter>

C:\>ipconfig

Windows IP Configuration


Ethernet adapter Local Area Connection:

        Connection-specific DNS Suffix  . : fakhruddin.local
        [B]IP Address. . . . . . . . . . . . : 192.168.100.64[/B]        Subnet Mask . . . . . . . . . . . : 255.255.255.0
        Default Gateway . . . . . . . . . : 192.168.100.1

For SID of Oracle Server.
you can check on services.msc

start ----> run -----> services.msc <hit enter>
in services windows

"OracleService<sid>".

hope this helps
Taj.

Report message to a moderator

Re: How to create tnsnames.ora [message #208362 is a reply to message #208266]

Sat, 09 December 2006 19:27

Admin@Lightsql.Com
Messages: 36
Registered: November 2006

Member

If you give the ip 192.168.100.64 and set up tnsnames, there is a minor issue. When you disconnect the computer from network, or if your ip is changed by dynamic DNS (I am seeing you are connected to a local router), you client & server connection will be broken and you will get tns error!.

If the database server is in your local machine(laptop or PC), it is better to use localhost (127.0.0.1) ip.

If you are confident that your ip will not be changed, yes, you can use that.

Cheers,

Jay
Fun Programming with Oracle & Visual C++, Author of http://www.lightsql.com.

[Updated on: Sat, 09 December 2006 19:28]

Report message to a moderator

Previous Topic:	tablespace
Next Topic:	Error 367 Crystl32.ocx problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:44:26 CDT 2024