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