Home » RDBMS Server » Server Administration » ORA-27121: unable to determine size of shared memory segment
ORA-27121: unable to determine size of shared memory segment [message #297610] Fri, 01 February 2008 12:55 Go to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Hi ,
I am facing the below error when trying to connect through sqlplus client, but can logon to database locally .

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


But can connect locally.

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"


Permission on oracle

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


NOTE:database created user(testA) is different from the one who own the binaries(testB) but belongs to same dba group.

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


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


Please any suggestions would be great.
Re: ORA-27121: unable to determine size of shared memory segment [message #297611 is a reply to message #297610] Fri, 01 February 2008 13:01 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
I suspect the listener.ora has a problem; possibly a incorrect ORACLE_HOME.
Re: ORA-27121: unable to determine size of shared memory segment [message #297613 is a reply to message #297610] Fri, 01 February 2008 13:17 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Here is my listener.ora.
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

[Updated on: Fri, 01 February 2008 14:54]

Report message to a moderator

Re: ORA-27121: unable to determine size of shared memory segment [message #297625 is a reply to message #297610] Fri, 01 February 2008 15:21 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
monto wrote on Fri, 01 February 2008 13:55


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





Permission on all of my oracle binaries are
-rwsr-s--x
Re: ORA-27121: unable to determine size of shared memory segment [message #298576 is a reply to message #297610] Wed, 06 February 2008 09:32 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Hi ,
I installed binaries in a new OH and when trying to configure the listener with netca got a warning saying
"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."
I went ahead and configured the listener and started it.
 /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

But when trying to connect with net service names i am getting Error:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor


Listener.ora
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)
    )
  )



Tnsnames.ora
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
Please need help to resolve this.

Regards

[Updated on: Wed, 06 February 2008 09:34]

Report message to a moderator

Re: ORA-27121: unable to determine size of shared memory segment [message #298579 is a reply to message #297610] Wed, 06 February 2008 09:52 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Thanks Guys issue resolved.
Re: ORA-27121: unable to determine size of shared memory segment [message #299113 is a reply to message #298579] Sat, 09 February 2008 08:46 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Please give us your feedback ...what is actual reason ?
Re: ORA-27121: unable to determine size of shared memory segment [message #299225 is a reply to message #297610] Sun, 10 February 2008 22:55 Go to previous message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
The reason was root.sh has not been ran,had to re-ran it for the below error .
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

Not running root.sh effects non-oracle users ,operations initiated by them to not work properly at times for no reason,as in my case database is owned by another user .
Previous Topic: run exp cmd in shell scripts
Next Topic: how to delete index stats
Goto Forum:
  


Current Time: Sun Dec 04 22:29:58 CST 2016

Total time taken to generate the page: 0.09969 seconds