I dont have the GLOBAL_NAMES parameter set.
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).
