| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA 01034 27101 Something is fussy
Just a thought, but what is your GLOBAL_NAMES parameter set to in your init.ora file?
Mark
-----Original Message-----
Sent: Thursday, June 07, 2001 12:06
To: Multiple recipients of list ORACLE-L
Ok folks here's whats happening when I run 'sqlplus foo/bar_at_DEV':
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 6 17:02:49 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
but 'sqlplus foo/bar' connects fine.
Oracle IS running. The instance name is DEV. 'ps -ef |grep DEV' reports:
oracle 8165 1 0 11:13:43 ? 0:00 ora_smon_DEV oracle 8163 1 0 11:13:42 ? 0:00 ora_ckpt_DEV oracle 8158 1 0 11:13:42 ? 0:00 ora_dbw0_DEV oracle 8160 1 0 11:13:42 ? 0:00 ora_lgwr_DEV oracle 8167 1 0 11:13:43 ? 0:00 ora_reco_DEV oracle 8156 1 0 11:13:42 ? 0:00 ora_pmon_DEV
ipcs prints out:
Shared Memory:
m 0 0x500005c6 --rw-r--r-- root root m 101 0 --rw-r----- oracle oinstall m 102 0 --rw-r----- oracle oinstall m 103 0 --rw-r----- oracle oinstall m 104 0 --rw-r----- oracle oinstall m 105 0 --rw-r----- oracle oinstall m 106 0x5a33e090 --rw-r----- oracle oinstall Semaphores: s 458752 0x1c444e0c --ra-r----- oracle oinstall s 65537 0x1c444e0d --ra-r----- oracle oinstall s 65538 0x1c444e0e --ra-r----- oracle oinstall s 65539 0x1c444e0f --ra-r----- oracle oinstall s 65540 0x1c444e10 --ra-r----- oracle oinstall
My listener.ora file looks like:
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = DEV)
)
(ADDRESS =
(PROTOCOL = TCP)
(Host = grape)
(Port = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DEV)
(SID_NAME = DEV)
(ORACLE_HOME = /devel/oracle/u01/app/oracle/8.1.7)
)
)
My tnsnames.ora file looks like:
DEV =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = grape)
(Port = 1521)
)
(CONNECT_DATA =
(SID = DEV)
)
)
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
Both the client and the server are 8.1.7. Listener.log tells me:
06-JUN-2001 16:26:11 *
(CONNECT_DATA=(SID=DEV)(CID=(PROGRAM=)(HOST=grape)(USER=o racle))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.0.200)(PORT=33769)) * establish * D EV *
0
Let me know if you have any suggestions, or anyplace to find the answers.
Thanks,
jon
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon INET: jon_at_slurpee.org Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: mark_at_cool-tools.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Jun 07 2001 - 05:24:45 CDT
 |
 |