Setting up Oracle Client

[bells]

I just installed oracle Clint for window in my laptop.
I will be connecting this laptop to a network when i go to work
is there any additional thing i need to do if i want to connect to an existing database server on the network??
thank u

 

[nikhilwani]

Go to Sql Net Easy config menu
1)give the Database Alieses which is also called as services (give any name)
2)Entter the IP address of server
3) Select Protocol as TCP/IP.
Hope so this will work
Nikhil Wani
Vadodara

 

[bells]

well thank u i tried what u said
i still can not connect to the database
i have a message which says TNS problem
What is this TNS and how can i configure that?
thank u again

 

[THoey]

The SQL*Net Easy Config edits a file called TNSNAMES.ORA. The TNSNAMES file is located in your %ORACLE_HOME%\Network\Admin directory on your computer. This file has a listing of the different database instances that your machine is configured to attach to. An example of an entry in this file follows:

MYDB.MYCOMPANY.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.45.678.90)(PORT = 1521))
)
(CONNECT_DATA =
(SID = MYDB)
)
)

This specifies that on the machine located at the listed IP Address, there is a database instance called MYDB.SBC.COM with an Oracle SID of MYDB. BTW, I manually edit this file using notepad, but that is because I am experienced with it. Until you are that way, I recommend using the SQL*Net Easy Config, but you can open it with Notepad and look at it.

There is also a file called SQLNET.ORA in that same directory that could contain the following line:

names.default_domain=mycompany.com

If this line is there, you can reference the database as MYDB instead of MYDB.MYCOMPANY.COM.

If all of this information is correct for your case, and if the listener on that database is on, you should be able to connect. Check with your DBA and Network Admin to verify these values.

Hope that helps... Terry M. Hoey