Post-Install: Oracle v9.2.0 on Mandrake9.2

From: php newbie <newtophp2000_at_yahoo.com>
Date: 2 Feb 2004 10:47:37 -0800
Message-ID: <124f428e.0402021047.75efb814@posting.google.com>

I have installed Oracle a few times in the past few days, each time following different guidelines (puschitz, dizwell, Oracle's own). Each time, I end up with the same post-install state.

The user oracle can start up, shut down, and connect to the database. Any other user can not, despite their having no differences, other than user names. I will appreciate any help to resolve this.

I am including as much information as possible in the hopes that someone will see what is going on:

OS: Mandrake 9.2
Oracle: Oracle 9.2.0.1.0
RAM: 1GB users: oracle, test
user oracle's groups: oinstall, dba, oracle user test's groups: test, oracle
Global DB Name: db_lx92
SID: lx92

$ printenv |grep ORA

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/9i
ORACLE_SID=lx92
ORACLE_TERM=xterm

ORA_NLS33=/u01/app/oracle/9i/ocommon/nls/admin/data

$ printenv | grep LD_LIBRARY_PATH
LD_LIBRARY_PATH=/u01/app/oracle/9i/lib:/lib:/usr/lib:/usr/local/lib

$ sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Feb 2 13:13:16 2004

Enter user-name: system
Enter password:
oraclelx92: error while loading shared libraries: libodm9.so: cannot open shared
object No such file or directory
ERROR:
ORA-12547: TNS:lost contact

$ pwd
/u01/app/oracle/9i/bin

$ ls -l oracle*
-rwsr-sr-x    1 oracle   oinstall 44946785 May 13  2002 oracle*
-rwxr-xr-x    1 oracle   oinstall        0 May  2  2002 oracleO*

$ cd ../lib
$ pwd
/u01/app/oracle/9i/lib
$ ls -l libodm*
lrwxrwxrwx 1 oracle oinstall 11 Jan 31 21:55 libodm9.so -> libodmd9.s
o*
-rwsr-sr-x 1 oracle oinstall 6747 Apr 26 2002 libodmd9.so*

$ cd ../network/admin/
$ pwd
/u01/app/oracle/9i/network/admin

<< HERE ARE THE CONTENTS OF OF RELEVANT CONFIG FILES AND ERROR MSGS>>
<< listener.ora, sqlnet.ora, tnsnames.ora, /etc/sysctl.conf >>
<< sqlnet.log >>
<< install errors that were not fixed following various suggestions >>



###########################################################################

###########################################################################

###           listener.ora


###########################################################################

###########################################################################

# LISTENER.ORA Network Configuration File: /u01/app/oracle/9i/network/admin/list
ener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )

)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/9i)
      (PROGRAM = extproc)

)
(SID_DESC =

      (GLOBAL_DBNAME = db_lx92)
      (ORACLE_HOME = /u01/app/oracle/9i)
      (SID_NAME = lx92)

)
)

###########################################################################
###########################################################################

###           sqlnet.ora


###########################################################################

###########################################################################

# SQLNET.ORA Network Configuration File:
/u01/app/oracle/9i/network/admin/sqlnet
.ora

# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = "" NAMES.DIRECTORY_PATH= (TNSNAMES)
###########################################################################
###########################################################################

###           tnsnames.ora


###########################################################################

###########################################################################

# TNSNAMES.ORA Network Configuration File:
/u01/app/oracle/9i/network/admin/tnsn
ames.ora

# Generated by Oracle configuration tools.

LX92."" =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = db_lx92)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )
    (CONNECT_DATA =

      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)

)
)

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

)
)

###########################################################################
###########################################################################

###           $ cat /etc/sysctl.conf


###########################################################################

###########################################################################

kernel.sem    = 250 32000 100 128
kernel.shmall = 2097152
kernel.shmmax = 536870912

kernel.shmmni = 4096
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

###########################################################################
###########################################################################

###           sqlnet.log


###########################################################################

###########################################################################

***********************************************************************
Fatal NI connect error 12547, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/9i/bin/oracle)(ARG V0=oraclelx92)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH= NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=localHost)(USER=test))))

VERSION INFORMATION:

        TNS for Linux: Version 9.2.0.1.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version

9.2.0.1.0 - Produ
ction
  Time: 02-FEB-2004 00:15:02
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12547
    TNS-12547: TNS:lost contact
    ns secondary err code: 12560
    nt main err code: 517
    TNS-00517: Lost contact
    nt secondary err code: 32
    nt OS err code: 0

###########################################################################
###########################################################################
<< install errors that were not fixed following various suggestions >>
###########################################################################
###########################################################################

Error in invoking target ioracle of makefile /u01/app/oracle/9i/rdbms/lib/ins _rdbms.mk
Error in invoking target install of makefile /u01/app/oracle/9i/ctx/lib/ins_c tx.mk
Error in invoking target install of makefile /u01/app/oracle/9i/rdbms/lib/ins _rdbms.mk

Received on Mon Feb 02 2004 - 12:47:37 CST