SQLNET.LOG shows error message

[samirshah]

Hi all,

Our SID,instance name is TEST but I see foll. error msg in sqlnet.log.

Fatal OSN Connect Error 12154, Connecting to : PROD

Because of this, I am unable to sign on in my Oracle Application.

I checked TNSNAMES.ora file. There is no reference of PROD.

Can someone tell me from where it tries to look for PROD instance instead of TEST?

Thanks in advance

Sam

[jlakhani]

hmm search for a tnsnames.ora in ur machine..maybe its using a differnt home

[Shestakov]

One of your application use connect string like this:

connect user/pwd@prod

and in your tnsnames.ora doesn't exists entry named PROD

[samirshah]

Originally posted by Shestakov
One of your application use connect string like this:

connect user/pwd@prod

and in your tnsnames.ora doesn't exists entry named PROD

Hi,

I checked all the files but it can not find any file with @prod. Can you suggest me some files?

Thanks,

Sam

[samirshah]

Originally posted by jlakhani
hmm search for a tnsnames.ora in ur machine..maybe its using a differnt home

Hi,

I have only one Oracle Home and only one tnsnames.ora file.

Thanks,

Sam

[Shestakov]

oracle doc:

ORA-12154 TNS:Could not resolve service name

Cause: The service name specified is not defined in the TNSNAMES.ORA file.
Action: Make the following checks and correct the error:
Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.
----------------------------------------------------------
Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.
----------------------------------------------------------

I hope, that your tnsnames.ora place in $ORACLE_HOME/network/admin or $ORACLE_HOME/net8/admin

[samirshah]

Originally posted by Shestakov
oracle doc:

ORA-12154 TNS:Could not resolve service name

Cause: The service name specified is not defined in the TNSNAMES.ORA file.
Action: Make the following checks and correct the error:
Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.
----------------------------------------------------------
Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.
----------------------------------------------------------

I hope, that your tnsnames.ora place in $ORACLE_HOME/network/admin or $ORACLE_HOME/net8/admin

Hi,

I have only one TNSNAMES.ORA and it is in %ORACLE_HOME%\net80\admin directory.

Then, I did some workaround. I added new entry with 'PROD' in Tnsnames.ora keeping other adress details as of TEST.

Now, It does not give any error in sqlnet.log.

What does it mean when my instance name and all services are starting with TEST?

Can u pl. help clarify?

Thanks,

Sam

[samirshah]

Hi,

Pl. help. Its very urgent...

Thanks,

Sam

[Shestakov]

are you have in tnsnames.ora something like this:

prod = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test_host )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test )
)
)

or

test = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test_host )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test )
)
)
or

test = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test_host )(PORT = 1521))
)
(CONNECT_DATA =
(SID = test )
)
)


this is only 3 aliases to one oracle instance and applications may use any alias.

[samirshah]

Originally posted by Shestakov
are you have in tnsnames.ora something like this:

prod = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test_host )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test )
)
)

or

test = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test_host )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test )
)
)
or

test = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test_host )(PORT = 1521))
)
(CONNECT_DATA =
(SID = test )
)
)


this is only 3 aliases to one oracle instance and applications may use any alias.

Hi,

I have

prod = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test_host )(PORT = 1521))
)
(CONNECT_DATA =
(SID = test )
)
)

and

test = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test_host )(PORT = 1521))
)
(CONNECT_DATA =
(SID = test )
)
)


My question is...

Why it looks for PROD instead of TEST?

Thanks,

Sam