Oracle 10g Client Connection Issue
 

Hi there!

Well, I managed a successful installation of Oracle 10g on White Box EL 3 using Werner Puschitz tutorial few days back. The next step is to connect clients running Windows 2K/XP with my database server. However, when I try to log in with username scott, password tiger and Host String=test (the Oracle SID), I get the error

TNS: no listener

I have searched for this error on google and noticed that there are 3 files that are important in context of Oracle Client connectivity -

Listener.ora, sqlnet.ora and tnsnames.ora

Now, I also noticed that my client has sqlnet.ora and tnsnames.ora only. Can the absence of Listener.ora on my client machine be the reason for the above error ?

As far as Oracle Installation and client connectivity goes, I am a beginner, so thats why I dont have much idea about the above 3 files.

I have used the following commands on the oracle server when logging in as oracle

lsnrctl start
emctl start dbconsole
isqlplusctl start
dbstart

However, till now, I havent come across any document that could guide me at connecting a Windows client to linux database server.....So I'd needing some help here...can anyone tell me where am I going wrong ?

Regards,

--amit

No replies even after 38! views ?...I hope the mods/gurus/LQ addicts have also read my problem :)

Hey friends!

Well, I expected someone to help me out here as I know that there are lot of people Installing and using Oracle 10g all around the world.....Even after 48 views, no one suggested anything.....

Anyways, I have found out the solution...Hope you friends will benefit from this information....

As I wrote in my first post, there are 3 files that are important with respect to Oracle

1. Listener.ora
2. tnsnames.ora
3. sqlnet.ora

So, I will start from the beginning...

(I'd like to inform u that I am just a beginner as far as Oracle goes...)...I chose the 'CUSTOM' method of Oracle 10g client installation and selected Oracle SQL*Plus, Oracle Network tools, Oracle 10g Client and few others that looked relevant to me

After Installating the Client, I copied Listener.ora from the server to my client. The files tnsnames.ora and sqlnet.ora were auto-generated by Oracle Configuration tools...

( After Creating this file 'listener.ora' on the client machine, restart the listener on Oracle Server using the command 'lsnrctl stop' and then 'lsnrctl start')

----------------------------
Listener.ora
-----------------------------


(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle)
(PROGRAM = extproc)
)
)

TRACE_LEVEL_LISTENER0 = OFF

LISTENER =
(DESCRIPTION_LIST =
( DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.20) (PORT = 1521))
)
)
)

**************************************************************************

---------------------------------
SQLNET.ORA
---------------------------------

# sqlnet.ora Network Configuration File:
C:\Oracle\product\10.1.0\Client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES. HOSTNAME)
***********************************************************************

----------------------------------
TNSNAMES.ORA
-----------------------------------
# tnsnames.ora Network Configuration File:
C:\Oracle\product\10.1.0\Client_1\network\admin\tnsnames.ora
# Generated by Oracle Configuration tools.

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.20) (PORT = 1521))
)

(CONNECT_DATA =
(SID = test)
)
)
=======================================================

Now run SQL*Plus and connect as user scott/tiger and use host string as your SID ('test' in my case)

I used the user 'system' to connect to SQL*Plus and I had set the password for users 'system', 'sys' , 'dba' ..etc at the time of oracle server installation on WBEL 3.0, so u should keep that in mind when using any of these users to connect to the database....

Thats it, the windows client should now be able to connect to your linux server........I would like to hear if this information helped you guys.....

Please feel free to correct me if I have been wrong anywhere....

Regards,

--amit