Re: shared memory realm does not exist

From: No Spam <nospam_at_home.com>
Date: Tue, 13 Jan 2004 17:44:55 -0000
Message-ID: <I9WMb.3560$1q3.75@news-binary.blueyonder.co.uk>

Here is my sqlnet.ora, tnsnames.ora and listerner.ora file in the /network/admin directory

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.akan.com)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL DBNAME = test.akan.com)
(SID_NAME = test)

(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0)

(PROGRAM = extproc)

    )
  )

# SQLNET.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DEFAULT DOMAIN = akan.com

NAMES.DIRECTORY_PATH= (TNSNAMES) # TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

AKAN.LOCALDOMAIN =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = akan.com)

    )
  )

"No Spam" <nospam_at_home.com> wrote in message news:kmVMb.3361$1q3.224_at_news-binary.blueyonder.co.uk... > When I installed oracle 9.2i on redhat linux 9 I created usergroups for user

> oracle as stated in the manuals
>  #  groupadd dba
>   #  useradd oracle
>   #  mkdir /opt/oracle
>   #  mkdir /opt/oracle/product/9.2.0/
>   #  chown -R oracle:dba /opt/oracle
>
> Now whatever I type at the sqlplus I get shared realm does not exist
> even logging in as sysdba
> sqlplus /nolog
> connect as sysdba
>
> I get connected to an idle instance
>
> trying sqlplus oracle/oraclepassword_at_thenameofmydatabase I created with

dbca
> gets me the shared realm does not exist > I am at loggerheads what could be wrong, everything seemed to have install ed

> ok
>
>

Received on Tue Jan 13 2004 - 11:44:55 CST