SQL & PL/SQL

please check whether the listener service is up and running or else try lsnrctl and start the listener

Hi,

Thanks for the reply.

I have started the listener but now while connecting getting an error
ORA-12154 TNS:could not resolve the service name.

Can you please help with some next steps

Thanks a lot

Do u have any domain name set....
like .us.oracle.com

Or else please check the sqlnet.ora and tnsnames.ora file

Hi,

check the user name and password.

if u r connecting like
SQL> sqlplus scott/tiger@oracle9i

then check whether the service oracle9i is present in tnsnames.ora
if not edit it and shutdown and restart the databse.


Trinath Somanchi,

Hi Sashi/Trinath

I am getting a bit confused.....so let me start again

While installing the oracle server, the insatalltaion asks you for
1) SID
2) Global Database Name

so i provided the following values

SID=practice
Global Database Name=axxx.byyy

The tnsoranames conatins the follwing enrty

axxx.byyy.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.18.39)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = practice)
)
)


AND listener.ore contains the following enrty

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.18.39)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\OraHome1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = UKOBA)
(ORACLE_HOME = D:\OraHome1)
(SID_NAME = UKOBA)
)
(SID_DESC =
(GLOBAL_DBNAME = nhsdw1)
(ORACLE_HOME = D:\OraHome1)
(SID_NAME = nhsdw)
)
(SID_DESC =
(GLOBAL_DBNAME = axxx.byyy)
(ORACLE_HOME = D:\OraHome1)
(SID_NAME = practice)
)
)

and entry in the sql.net

NAMES.DEFAULT_DOMAIN = byyy.com

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

I am not able to figure out what is the reason for the error as there are enteries in all the three files.

It would be great help if you could throw some light on this topic

Thanks

hi,
u have to connect like this

sqlplus scott/tiger@practice

it surely works as it worked for me


Trinath Somanchi,
Hyderabad.

Hi

Do you have more than 1 oracle home in your server?
Allways the tnsnames.ora of the default oracle home is used for lookup the tns name.
Try to configure and test the tns name in the net configuration assistant.

Ott Karesz
http://www.trendo-kft.hu

Hi Trinath/Ott,

Sorry again i'm not able to connect through scott/tiger@practice and still giving me an error could not resolve the service name.

Also i have two Oracle Home on my machine.

Thanks

Please include the domain name also in your host string as like your tnsnames.ora file..

If it does give the same problem,

Please edit below setting in the sqlnet.ora file

SQLNET.AUTHENTICATION_SERVICES=

(ie) remove the (NTS) in the right side

Hi Sashi,

After removing the NTS enrty on right hand side becomes
SQLNET.AUTHENTICATION_SERVICES=
but the error is still the same.

Can you sugget something else....:)


Thanks a lot for your replies

Hi

Copy your tnsnames.ora and sqlnet.ora files whoch contains the right tns name to the other oracle_home/network/admin, and try to connect again.
Test your tns name in the net configuration assistant.
Try to connect as scott/tiger@axxx.byyy.com and scott/tiger@axxx

Ott Karesz
http://www.trendo-kft.hu