Re: SuSE Linux 7.2 /etc/services and Oracle 9i - Help!

> Sybran wrote:
> Now if you would only post listener.ora, sqlnet.ora and tnsnames.ora
> I might be able to resolve it for you.
> These should use linux.local as host as localhost will work on the server
> only.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
> Sybrand,

Thanks for your insight. I'll be hunting for the Network book you mentioned, which suggests 8i, not 9i. It would not be logical for me to think to look for a book addressing 8i, as you suggest, but hey, there's a lot of 8 stuff going on in the 9i engine. So I'll be looking for that book.

Interestingly, after I changed the 'bogus' ( your words ) sqlnet to 1521/tcp , voila, I could connect and use oem. So changing services was productive.

By the way what is the significance of case? Are these files case-sensitive in their usage? Again I could find no reference to tell me if I should be case-sensitive with the settings. Another one for the FAQ, or simply basic docs.

Thanks,

Tim Schaefer
Neophyte Oracle DBA

Per your request, here are the gang of three:

--begin listener.ora:

oracle_at_linux:~/product/9.0.1/network/admin > cat listener.ora # LISTENER.ORA Network Configuration File: /opt/oracle/product/9.0.1/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux.local)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.0.1)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = mutt01)
(ORACLE_HOME = /opt/oracle/product/9.0.1)
(SID_NAME = mutt01)

    )
    (SID_DESC =
(GLOBAL_DBNAME = OEMREP.local)
(ORACLE_HOME = /opt/oracle/product/9.0.1)
(SID_NAME = OEMREP)

    )
  )

oracle_at_linux:~/product/9.0.1/network/admin >

--end listener.ora

--begin tnsnames.ora

oracle_at_linux:~/product/9.0.1/network/admin > cat tnsnames.ora # TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.0.1/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

MUTT01.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux.local)(PORT = 1521 ))
    )
    (CONNECT_DATA =
(SERVICE_NAME = mutt01)

    )
  )

OEMREP.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux.local)(PORT = 1521 ))
    )
    (CONNECT_DATA =
(SERVICE_NAME = OEMREP.local)

    )
  )

INST1_HTTP.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux.local)(PORT = 1521 ))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)

    )
  )

oracle_at_linux:~/product/9.0.1/network/admin > --end tnsnames.ora

--begin sqlnet.ora

oracle_at_linux:~/product/9.0.1/network/admin > cat sqlnet.ora # SQLNET.ORA Network Configuration File: /opt/oracle/product/9.0.1/network/admin/sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = local

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) oracle_at_linux:~/product/9.0.1/network/admin >

--end sqlnet.ora Received on Mon Oct 01 2001 - 07:50:23 CDT