Re: problem with Oracle database on SunSolaris

Hi,

1]- This is a classical name resolution problem which mostly has to do with you "tnsnames.ora" in the machine you are trying to connect from. Please make sure that "tnsnames.ora" on the machine you are trying to connect from includes an entry of the database service you are trying to connect to.

2]- Also make sure that your connection string matches the entry in your
"tnsnames.ora"

so if your connection string will be "sqlplus system/manager_at_test.world" then your "tnsnames.ora" under $TNS_ADMIN which must point to $ORACLE_HOME/network/admin should have an entry for "test.world" which should look like this :

TEST.world=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )

3]- Check that your Database Service is registered with the listener :

% lsnrctl status
 Issuing this command should confirm if your instance is registerd with the listener or not.

"The Views expressed here are my own and not necessarily those of Oracle
Corporation"

"Parvinder Singh" <parora_at_questone.com> wrote in message
news:3874933B.3247069F_at_questone.com...
dear All

        I have got a problem with Oracle Installation on Sun Server. After i have installed ORACLE on my Sun machine. It doesnt starts the service which i have created with the help of ne8asst it doesnt connects to the database. It gives the error
TNS:listener cannot resolve the SID given in the connect descriptor. Is there any relation to be established between the SID and listener after the installation ??
After installation i did execute the root.sh script with the user as root and then added the ORACLE_HOME directory in the .profile of the user:ORACLE .the directory has also been exported with the command export ORACLE_HOME in the .profile ....Thats all i did after the installation. and after that went for creating a service with the help of net8asst.sh Regards & Thanks in advance
~Parvinder
P.S : Also reply to parora_at_questone.com Received on Fri Jan 07 2000 - 23:52:43 CST