Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2010
    Posts
    4

    Unanswered: Namesctl starting error Oracle 7.3.4 on Windows NT4

    I have installed Oracle 7.3.4 on a Win NT4 machine (old stuff, I know, but for a client) I have been following the guide provided by Oracle for this version and am at the point where I must start LSNRCTL and NAMESCTL.

    LSNRCTL starts automatically on startup
    NAMESCTL does not, and when I try to start it manually from cmd, I get the following output:

    NAMESCTL> start
    Starting "names.exe". . .Service OracleNamesService start pending.
    Service OracleNamesService started.
    service not started, errors follow
    NNC-00002: error listening on stream (ADDRESS=(PARTIAL=yes)(PROTOCOL=spx))
    TNS-12538: TNS:no such protocol adapter
    TNS-12560: TNS: protocol adapter error
    TNS-00508: No such protocol adapter


    I found a thread on this site from '01 talking about this, but OP failed to post resolution: http://www.dbforums.com/oracle/255838-network.html

    I took a look at my listener.ora but I'm such a raw Oracle n00b that I don't know what I'm looking for.

    Please Help, any and all comments will be greatly appreciated.

    The following is my Listener.ora:

    ################
    # Filename......: listener.ora
    # Node..........: local.world
    # Date..........: 24-MAY-94 13:23:20
    ################
    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS=
    (PROTOCOL= IPC)
    (KEY= oracle.world)
    )
    (ADDRESS=
    (PROTOCOL= IPC)
    (KEY= ORCL)
    )
    (ADDRESS=
    (COMMUNITY= NMP.world)
    (PROTOCOL= NMP)
    (SERVER= WBNT4)
    (PIPE= ORAPIPE)
    )
    (ADDRESS=
    (COMMUNITY= TCP.world)
    (Host = wbnt4)
    (PROTOCOL= TCP)
    (Port= 1521)
    )
    (ADDRESS=
    (COMMUNITY= TCP.world)
    (Host = 127.0.0.1)
    (PROTOCOL= TCP)
    (Port= 1521)
    )
    (ADDRESS=
    (COMMUNITY= TCP.world)
    (Host = wbnt4)
    (PROTOCOL= TCP)
    (Port= 1526)
    )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = OFF
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = ORCL)
    )
    )
    PASSWORDS_LISTENER = (oracle)

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Novell?

    This seems to be pointing to a Novell network (spx):
    Code:
    ...)(PROTOCOL=spx))
    Try find a configuration file (maybe sqlnet.ora?) that refers to this protocol.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I did V7.3.4.5 more than a decade ago & never used NAMESCTL.
    It is not required to run Oracle RDBMS.
    What business problem are you trying to solve?
    I hope you have a support contract with Oracle.
    Open SR on Metalink.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jan 2010
    Posts
    4
    Quote Originally Posted by LKBrwn_DBA View Post
    This seems to be pointing to a Novell network (spx):
    Code:
    ...)(PROTOCOL=spx))
    Try find a configuration file (maybe sqlnet.ora?) that refers to this protocol.
    The following is my sqlnet.ora file:

    Automatic_ipc = OFF
    TRACE_LEVEL_CLIENT = OFF
    names.directory_path = (TNSNAMES)
    names.default_domain = world
    names.default_zone = world
    names.default_domain=world

    Thanks for the replies everyone!

  5. #5
    Join Date
    Jan 2010
    Posts
    4
    I found an spx protocol being called in Tnsnames.ora, but removing the section of code specifying the spx protocol didn't fix the issue.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post contents of names.ora & cman.ora

    make sure the OS networking configuration is correct & consistent; hostname must resolve to correct IP#.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool tnsnames.ora

    If you insist on using NAMES server, you would need to add to the sqlnet.ora something like the following:
    Code:
    #-- etc
    NAMES.DIRECTORY_PATH = (ONAMES,TNSNAMES)
    NAMES.PREFERRED_SERVERS=
      (ADDRESS=(PROTOCOL=TCP) (HOST=NAMESRV1)(PORT=1575))
    #-- etc
    Otherwise, as anacedent pointed out, "NAMES is not required to run Oracle RDBMS".
    Your sqlnet.ora is configured already to use the tnsnames.ora file.

    PS: Also as anacedent observed, you may need to configure names.ora & cman.ora.

    SPX Confirmed:

    Quote Originally Posted by Net8 Administrator's Guide
    The Sequenced Packet Exchange (SPX) protocol enables client/server conversation over a network using SPX/IPX. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through SPX/IPX (if the Oracle database is running on a host system that supports network communication using SPX/IPX). This protocol is predominantly used in Novell Netware environments.
    Last edited by LKBrwn_DBA; 01-11-10 at 13:55.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  8. #8
    Join Date
    Jan 2010
    Posts
    4
    I am unable to find names.ora or cman.ora through windows search and by manually searching.

    What does namesctl really get me?

    I really appreciate everyone's help!

  9. #9
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Headaches.

    Quote Originally Posted by john.cottone View Post
    I am unable to find names.ora or cman.ora through windows search and by manually searching.
    If you do not have (cannot find) those files, then you would need to create them.

    Quote Originally Posted by john.cottone View Post
    What does namesctl really get me?
    Mainly headaches.

    The names server has a repository of connections, like a replacement for the tnsnames.ora file.

    Also, the names server is OBSOLETE and even though you are working with an obsolete and unsupported database version, it would be easier to use tnsnames.ora file.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •