TNSPING Error Message 3511 not found

Posted on 2006-05-02
Last Modified: 2013-12-11
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.
Question by:GeekMan
    LVL 47

    Expert Comment

    see if in Listener.ora of 10g there is a handler for the 10g instance.

      (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
    LVL 6

    Expert Comment

    What is the exact version of  10g and 9.2 databases? (ie ist /9207)?
    On what platform 10g is running?

    Pradeep George,
    Oracle Certified Master
    LVL 6

    Expert Comment

    Similar issues have  been reported with permission problems on various unix systems.

    LVL 47

    Accepted Solution

    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).

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now