Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 9iAS R2 on RH7.x...please advise

9iAS R2 on RH7.x...please advise

From: Henry Kam <kam1_at_whwpe.lucent.com>
Date: Fri, 07 Jun 2002 20:20:32 GMT
Message-ID: <3D012411.5C183B88@whwpe.lucent.com>


Hello,

Even though 9i R2 was not certified on RH7.x, I installed 9i DataBase R2 on RH7.2 successfully
(so far, all components work)

and also
installed 9iAS Release 2 on RH7.3 (AMD XP processor/ 768M/20G Disk) successfully
and all interpolation patches except "OID/SSO" were applied successfully (so far, Database/OEM/HTTP work).

The error during the OID patch was the command   "odisrvreg" which gave error "LDAP Connection Failure"   The commands (oidmon,oidctl,ldapcheck) before executing odisrvreg were OK...

I followed the instructions for tracing from the note in Metalink and still
got the same error.
I suspected my network configurations might be the cause: The output of "lsnrctl status", which was right after starting the listener by "lsnrctl start", was as follows:

LSNRCTL for Linux: Version 9.0.1.3.0 - Production on 07-JUN-2002 16:06:40

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER


Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.0.1.3.0 -
Production
Start Date                07-JUN-2002 16:06:27
Uptime                    0 days 0 hr. 0 min. 12 sec
Trace Level               support
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/o9i/network/admin/listener.ora
Listener Log File         /oracle/o9i/network/log/listener.log
Listener Trace File       /oracle/o9i/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test3.home.dom)(PORT=1521)))

Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "iasdb.test3.home.dom" has 1 instance(s).   Instance "iasdb", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

But the output of "lsnrctl status" after a couple of minutes was as follows:

LSNRCTL for Linux: Version 9.0.1.3.0 - Production on 07-JUN-2002 16:07:20

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER


Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.0.1.3.0 -
Production
Start Date                07-JUN-2002 16:06:27
Uptime                    0 days 0 hr. 0 min. 52 sec
Trace Level               support
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/o9i/network/admin/listener.ora
Listener Log File         /oracle/o9i/network/log/listener.log
Listener Trace File       /oracle/o9i/network/trace/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test3.home.dom)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))

Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "iasdb.test3.home.dom" has 2 instance(s).   Instance "iasdb", status UNKNOWN, has 1 handler(s) for this service...

  Instance "iasdb", status READY, has 3 handler(s) for this service... The command completed successfully

I wonder where those lines reference to HOST=0.0.0.0 were coming from !

test3.home.dom was defined in /etc/hosts: ping/tnsping/sqlplus userid/passwd_at_iasdb.world
worked...

All *.ora in $ORACLE_HOME/network/admin are listed as follows: *** listener.ora ***
# LISTENER.ORA Network Configuration File: /oracle/o9i/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = test3.home.dom)(PORT = 1521))

      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/o9i)
      (PROGRAM = extproc)

    )
    (SID_DESC =
      (GLOBAL_DBNAME = iasdb.test3.home.dom)
      (ORACLE_HOME = /oracle/o9i)
      (SID_NAME = iasdb)

    )
  )

TRACE_LEVEL_LISTENER = SUPPORT

DEFAULT_ADMIN_CONTEXT = "" DIRECTORY_SERVERS= (test3.home.dom:4032:4031)

DIRECTORY_SERVER_TYPE = OID

snmp.remoteaddress.iasdb.test3.home.dom = (DESCRIPTION=(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test3.home.dom)(PORT = 1521)) )
(CONNECT_DATA=(SID=iasdb)(SERVER=DEDICATED)))
ifile = /oracle/o9i/network/admin/snmp_rw.ora ifile = /oracle/o9i/network/admin/sqlnet.ora

NAMES.DEFAULT_DOMAIN = home.dom

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

System parameter file is /oracle/o9i/network/admin/listener.ora Log messages written to /oracle/o9i/network/log/listener.log Trace information written to /oracle/o9i/network/trace/listener.trc Trace level is currently 16

Started with pid=2220
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test3.home.dom)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 07-JUN-2002 16:06:27 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=test3)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=150999808))
* status * 0
07-JUN-2002 16:06:40 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=test3)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=150999808))
* status * 0
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW))

Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW))

Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))

Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))

07-JUN-2002 16:07:05 * service_register * iasdb * 0 07-JUN-2002 16:07:20 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=test3)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=150999808))
* status * 0
07-JUN-2002 16:45:28 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32807)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:28 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32808)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:28 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32809)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:38 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32810)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:39 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32811)) * establish *

iasdb.test3.home.dom * 0
07-JUN-2002 16:45:40 * service_update * iasdb * 0
07-JUN-2002 16:45:40 *

(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32812)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:40 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32813)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:41 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32814)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:41 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32815)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:42 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32816)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:42 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32817)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:42 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32818)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:48 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32819)) * establish * iasdb.test3.home.dom * 0
07-JUN-2002 16:45:50 *
(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32820)) * establish *
iasdb.test3.home.dom * 0
07-JUN-2002 16:45:52 * service_update * iasdb * 0
07-JUN-2002 16:46:00 *

(CONNECT_DATA=(SERVICE_NAME=iasdb.test3.home.dom)(CID=(PROGRAM=)(HOST=test3)(USER=oracle)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=168.6.8.38)(PORT=32821)) * establish *
iasdb.test3.home.dom * 0
07-JUN-2002 16:46:01 * service_update * iasdb * 0
07-JUN-2002 16:56:03 * service_update * iasdb * 0


Please advise,
Henry

P.S. there were over 10000 lines in listener.trc which was not included. Received on Fri Jun 07 2002 - 15:20:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US