Ken,
You probably could use a DBA for support in your current project. Hasn't
the company you're working with provided one? In any case, the error
you're getting could be result of one of several things - it's W2K. First
- generally the message "shared memory realm not available" means the SID
you're using isn't available on that box. Usually due to the DB being
down, but it could be for a host of other reasons. On W2K, making Oracle
available had two parts, the windoze Oracle Services must be running, and
the database must be mounted and open. Are both these conditions
satisfied. Second - if your using terminal services client to access the
server, depending on the version of the TSC, the SP of W2K, and the version
of Oracle, you nay not be able to use SQL Plus from the command line if you
are not a member of the "DBA" group, are using the bequeath protocol, or
your environmental variables are not properly set. Third - kind of like
#2, but check your environment with the SET command. Fourth - you have an
incorrect TNS names entry, or your listener is improperly configured, or
your sqlnet.ora file has a problem.
Troubleshooting connection problems, while it can be almost be reduced to a
checklisted science, is really more of an art.
Hope this helps.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Ken Janusz
<ken.janusz@su To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
fsys.com> cc:
Sent by: Subject: Oracle DB Connection Problem
[EMAIL PROTECTED]
om
12/05/2001
07:30 PM
Please respond
to ORACLE-L
8.1.7 on Dell W2000 server.
When I try to login via sqlplus I get this:
ORA-01034 Oracle not available
ORA-27101 shared memory realm doesn't exist
Then I get:
Login:
Password:
And this error:
ORA-12560 TNS: protocol adapter error.
Any ideas as to what the problem is?
Thanks,
Ken Janusz
Sufficient Systems, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
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:
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).
