• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 28845
  • Last Modified:

TNSPING Error Message 3511 not found

I'm getting this trying to ping a 10g database from a windows 2000 prof. client with the Oracle 9.2 Client....Do I need to re-install the client??

Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file for product=NETWORK, facility=TNSAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=omdbcipr))(ADDRESS=(PROTOCOL=TCP)(HOST=omdbcipr)(PORT=1521)))
Message 3509 not found; No message file for product=NETWORK, facility=TNS

Any tips to fix this would be appreciated. Thanks.
0
GeekMan
Asked:
GeekMan
  • 2
  • 2
1 Solution
 
schwertnerCommented:
see if in Listener.ora of 10g there is a handler for the 10g instance.


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start
0
 
Pradeepgv03Commented:
What is the exact version of  10g and 9.2 databases? (ie ist 10.2.0.1 /9207)?
On what platform 10g is running?


Pradeep George,
Oracle Certified Master
0
 
Pradeepgv03Commented:
HI,
Similar issues have  been reported with permission problems on various unix systems.



-pradeep
0
 
schwertnerCommented:
Seems there are other Oracle products installed on your machine. The new Oracle Homes shadow the Oracle Server Home. This happens often on Windows installations ....

Make the Oracle hOME of the Oracle server installation default Home (this will reaarange also the PATH entries).

Setting DEFAULT ORACLE HOME using OUI
Go to:
           start -->
              All programs -->
                    Oracle - Ora10g_Home1 -->
                         Oracle Installation Products -->
                                Launch the Universal Installer -->
                                      Click on "Installed Products: button
                                           Click on "Environment" tab
                                                  Move your Ora10g_Home1 to the top using the arrows on the right side.
                                                       Click on "Apply" button
 oraclient8.dll"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now