Home » RDBMS Server » Server Administration » How to create tnsnames.ora
How to create tnsnames.ora [message #207890] Thu, 07 December 2006 04:33 Go to next message
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.
Re: How to create tnsnames.ora [message #207893 is a reply to message #207890] Thu, 07 December 2006 04:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: How to create tnsnames.ora [message #208000 is a reply to message #207890] Thu, 07 December 2006 14:29 Go to previous messageGo to next message
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.
Re: How to create tnsnames.ora [message #208266 is a reply to message #208000] Fri, 08 December 2006 23:13 Go to previous messageGo to next message
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.

Re: How to create tnsnames.ora [message #208362 is a reply to message #208266] Sat, 09 December 2006 19:27 Go to previous message
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:
  


Current Time: Sat Dec 10 18:34:47 CST 2016

Total time taken to generate the page: 0.08676 seconds