Pavan DBA's Blog

The DBA Knowledge Store

Posts Tagged ‘message 3505 not found’

Resolving TNS – Message 3511 not found

Posted by Pavan DBA on September 14, 2010


Today i got the following error message when trying to do tnsping for a instance. This is the only database existing on this server.

blacksun037@root# tnsping ora11db

TNS Ping Utility for Solaris: Version 11.2.0.1.0 – Production on 14-SEP-2010 04:26:51

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS
I wondered and started analyzing what happend exactly wrong….and finally found solution to be pretty simpler

we need to set home path and sid (which i had not done yet as its new database server)

blacksun037@root# export ORACLE_SID=ora11db
blacksun037@root# export ORACLE_HOME=/oracle/product/11.2.0/dbhome_1

After setting above variables, its working

blacksun037@root# tnsping ora11db

TNS Ping Utility for Solaris: Version 11.2.0.1.0 – Production on 14-SEP-2010 04:42:12

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = blacksun037)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ora11db)))
OK (0 msec)

Posted in Networking with Oracle | Tagged: , , , | 14 Comments »

 
Follow

Get every new post delivered to your Inbox.

Join 2,243 other followers

%d bloggers like this: