Unable to create connection string????

[ShrutiM]

Hi!!

I've installed Oracle 8.1.5 on Linux. Now my client application also running on the same m/c requires connection string to make a connection to the database. I tried using the "netec" and "netasst" to make the tnsnames.ora but both of these applications stops abruptly. How should I proceed. Also I want to install Intelligent Agents on this machine.

What should be done, as I need to start a project soon and the work is getting affected....Pls Help!!

[darshil_db]

Hi shruti,

See did u change tnsnames.ora manually? Don't use any gui (i think u're not using gui, since u're in linux). U have to manually change it. Sending you my Unix server's tnsnames.ora which connects to Sun Solaris.

extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(CONNECT_DATA = (SID = extproc))
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= gayatri)(Port= 1521))
(CONNECT_DATA = (SID = ORCL))
)
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = td))
(CONNECT_DATA = (SID = td))

tdnew =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 10.31.8.121)(Port = 1521))
(CONNECT_DATA = (SID = td))
)

I hope u can u it fast if not then mail me on darshil_dba@rediffmail.com

Best wishes
Darshil

[ShrutiM]

Thanks for your support.

Since I'm using Linux I can use GUI tools. I was preferring these tools so as not to make any error while creating the tnsnames.ora manually. I was able to create the listener.ora through the "netasst" gui tool.

Anyway I installed oracle 8.1.5 on Win 2000 and when I generated the files throught these tools they used "service" keyword instead of "sid" (mind it its 8i).
So what you've sent is it surely gonna run or not. Please let me know.

My listener.ora is as follows

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = eye)(PORT = 1521))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)


Thanks again for your support.

Shruti

[shonaryar]

If you look into $oracle_home/net8/admin you will see the example of tnsname.ora for that operating system all you should do is to cut and past one section which is using tcp/ip assuming your network is using tcp/ip and change the sid and all other info accordingly