Help requested ! Protocol Adapters Missing oracle 9i...

From: Crowe <martincrowe23_at_hotmail.com>
Date: 28 Dec 2003 15:26:51 -0800
Message-ID: <f4e8126b.0312281526.5d8a7902_at_posting.google.com>


Greetings Everyone:

Oracle 9i installed on a sun solaris box. No protocol adapters available.
I would greatly appreciate any help from the db gurus on this forum.

after bringing up the database, i am using the netca (Oracle Net Services Configuration assistant). When i try to create a listener and configure the protocol for that listener, i do not see any available protocols (the available protocols box is empty!!) but, the selected protocols box/list shows TCP. so anyway i go ahead and use the TCP to create a listener. next i select the local net service name configuration and try to add a net service name, and again the there are no available protocols to select from.

when i issue a 'adapters' command in the OraHome1 directory i get this result:

Installed Oracle Net transport protocols are:

    IPC
    BEQ
    TCP/IP
    SSL
    RAW Installed Oracle Net naming methods are:

    Local Naming (tnsnames.ora)
    Oracle Directory Naming
    Oracle Host Naming
    Oracle Names Server Naming
    NIS Naming

and when i issue a 'adapters sqlplus' the result is :

Oracle Net transport protocols linked with sqlplus are:

Oracle Net naming methods linked with sqlplus are:

Although i am very new in this DB admin area, after googling I *think* that the protocols are installed properly. Can someone please help me to figure out why the protocols do not show up for selection when i try to configure a protocol for a listener and again when i try to add a service name to that listener.

I will greatly appreciate any help/hints/suggestions/advice in this regard. Received on Mon Dec 29 2003 - 00:26:51 CET

Original text of this message