sqlplus testq@test.com
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 1 18:18:49 2008

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
HP-UX Error: 13: Permission denied

ORACLE_BASE=/oracle
ORACLE_SID=test
PS1=[${ME}:${UNAME}:${ORACLE_SID}] ${PWD} >
ORACLE_ADMIN=/oracle/admin
ORACLE_HOME=/oracle/product/8.1.7ee

sqlplus testq

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 1 18:18:22 2008

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter password:

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SQL> show user
USER is "testq"

[testA:server:test] /oracle/product/8.1.7ee/bin > ll oracle
-rwxrwx--- 1 oracle testdba 38264760 Sep 14 23:30 oracle

id
uid=117(testB) gid=105(testdba) groups=104(dba)

id
uid=122(testA) gid=105(testdba) groups=104(dba)

STARTUP_WAIT_TIME_LISTENER_SERVER = 0

SID_LIST_LISTENER_SERVER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcldb.kk.xxx.com)
      (ORACLE_HOME = /oracle/product/8.1.7ee)
      (SID_NAME = orcldb)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = test.kk.xxx.com)
      (ORACLE_HOME = /oracle/product/8.1.7ee)
      (SID_NAME = test)
    )
  )

LISTENER_SERVER =
  (ADDRESS_LIST =
      (ADDRESS =(HOST = SERVER.kk.xxx.com)(PROTOCOL = TCP)(PORT = 1131))
        )



CONNECT_TIMEOUT_LISTENER_LISTENER_SERVER = 10

CONNECT_TIMEOUT_LISTENER_SERVER = 10

STARTUP_WAIT_TIME_LISTENER_LISTENER_SERVER = 0

TRACE_LEVEL_LISTENER_SERVER = OFF

SQLNET.AUTHENTICATION_SERVICES= (NONE)

TRACE_LEVEL_LISTENER_LISTENER_SERVER = OFF

-rwsr-s--x

"The information provided for the TCP is currently in use by another listener you can proceed with the configuration as it is,but it will not be possible to start the listener until conflict is resolved .Would you like to continuu with the configuration anyway."

 /u01/oracle/product/8.1.7ee/network/admin > grep lsnr    <
 test 17848     1  0 15:03:58 ?         0:00 /u01/oracle/8.1.7ee/bin/tnslsnr LISTENER -inherit

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = server.kk.xxx.com)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/oracle/product/8.1.7ee)
      (PROGRAM = extproc)
    )
  )

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

TEST.KK.XXX.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = server.kk.xxx.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TEST.KK.XXX.com)
    )

lsnrctl services LISTENER

LSNRCTL for HPUX: Version 8.1.7.4.0 - Production on 06-FEB-2008 15:27:53

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server.kk.xxx.com)(PORT=1521)))
Services Summary...
  PLSExtProc            has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
  oracldb              has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
The command completed successfully

SQL> show parameter service_

NAME                                 TYPE    VALUE
------------------------------------ ------- ------------------------------
service_names                        string  test.kk.xxx.com

sqlplus testq@test.com
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 1 18:18:49 2008

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
HP-UX Error: 13: Permission denied