RE: Services and Oracle Startup

From: Kuan, Amy M <kuanam_at_texaco.com>
Date: Mon, 02 Apr 2001 08:44:53 -0700
Message-ID: <F001.002DE5E9.20010402082052@fatcity.com>

It's a bug. Refer to note 132086.1 on Metalink.

-----Original Message-----
Sent: Monday, April 02, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L

I have this small situaltion

I try to start my database from command line in win2k , I get the following error

C:\>svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

ORA-12560: TNS:protocol adapter error
SVRMGR> exit
Server Manager complete.
C:\>

But , If I go to services and start the service for starting the database I get this

C:\>svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SVRMGR> connect internal
Password:
Connected.
SVRMGR> select * from v$database;
select * from v$database
*
ORA-01034: ORACLE not available

But If I do a startup from
command line in win2000 it's starts and looks perfect .

SVRMGR>
SVRMGR> startup
ORACLE instance started.

Total System Global Area                        419173644 bytes
Fixed Size                                          70924 bytes
Variable Size                                   110940160 bytes
Database Buffers                                308084736 bytes
Redo Buffers                                        77824 bytes

Database mounted.
Database opened.
SVRMGR>
SVRMGR> exit
Server Manager complete.

Any ideas why it's doing this. I have all my required varibles set in my system.

Rk
--

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

Author: Apps Sol
INET: apps_sol_at_hotmail.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: Kuan, Amy M
INET: kuanam_at_texaco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

RE: Services and Oracle Startup - WIN2000