Re: Oracle DB Connection Problem

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_at_su       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    fsys.com>            cc:                                           
                       
                    Sent by:             Subject:     Oracle DB Connection Problem     
                       
                    root_at_fatcity.c                                                     
                       
                    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: ken.janusz_at_sufsys.com

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: 
  INET: DBarbour_at_austin.isd.tenet.edu

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