$ORACLE_HOME has to match the ORACLE_HOME= directive in the listener.ora file EXACTLY... 3 days of tracking down a bug because I didnt put a / after the 8.1.7 in the ORACLE_HOME directive... oh well, live and learn :) thanks, jon On Thu, 7 Jun 2001, Mark Leith wrote: > 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@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) > ) > ) > My sqlnet.ora file looks like: > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Jon INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
