Oracle-L: RE: W2K problem in connection

From: Thomas Day <tday6_at_csc.com>
Date: Tue, 28 May 2002 05:43:23 -0800
Message-ID: <F001.0046C9AD.20020528054323@fatcity.com>

What does your TNSNAMES.ORA entry look like?

                                                                                           
                    Sujatha Madan                                                          
                    <Sujatha.Mada        To:     Multiple recipients of list ORACLE-L      
                    n                    <ORACLE-L_at_fatcity.com>                            
                    @cmc.cwo.net.        cc:                                               
                    au>                  Subject:     RE: W2K problem in connection        
                    Sent by: root                                                          
                                                                                           
                                                                                           
                    05/26/2002                                                             
                    08:33 PM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L

:) ... Yes the service has been started, the listener is running (after being started).

Funny thing is, I can open a sqlplus session from my laptop and that runs perfectly but I can't run a sqlplus session from the server itself. (before you ask, the ORACLE_SID and the ORACLE_HOME are set correctly).

I am using Terminal Services to connect to the server. Do you think that could be the cause???

-----Original Message-----

Sent: Friday, 24 May 2002 8:38 PM
To: Multiple recipients of list ORACLE-L

That should be:

"I know you said the service CREATED fine"

Ahh well - it's Friday ;P

-----Original Message-----

Sent: 24 May 2002 10:48
To: Multiple recipients of list ORACLE-L

I know you said the service started fine - and this may be a stupid questions but.. Did you start the Oracle service?

Mark

-----Original Message-----

Madan
Sent: 24 May 2002 03:38
To: Multiple recipients of list ORACLE-L

Hi,

I'm having problems creating a db on W2K (Oracle version 8.1.7).

I installed the software without any errors. I then created the pfile, and created the service using ORADIM. The service created fine without errors.

Now I am trying to create the database, but I can't!!! Whenever I try and log in as sysdba it gives me an ORA-24314 Service handle not initialized. The ORACLE_HOME and SID are set correctly.

Can someone please help me. I have searched in metalink and I've seen other people facing the same problem but there aren't many solutions.

Cheers,

Sujatha

Sujatha Madan
Database Administrator
Custom Management Centre
Optus Business Operations
'yes' OPTUS
PH # +61 2 9775 5316
Mobile # +61 402 354 347
FAX # +61 2 9775 5360
Email Sujatha.Madan_at_cmc.cwo.net.au
WEB http://www.optusbusiness.com.au/

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sujatha Madan
INET: Sujatha.Madan_at_cmc.cwo.net.au

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

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: Mark Leith
INET: mark_at_cool-tools.co.uk

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

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Thomas Day
INET: tday6_at_csc.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