Home » RDBMS Server » Server Utilities » ora-2710
ora-2710 [message #73158] Sun, 22 February 2004 02:03 Go to next message
Mona
Messages: 9
Registered: December 2001
Junior Member
Hi,

i have oracle 9I under Windows 2000 server .

i m getting ora-27100 where i try to start an instance.

I made a shutdown immediate trough sqlplus /nolog but when i want to startup it fails does anyone have the answer?

Thanks

Mona
Re: ora-2710 [message #73159 is a reply to message #73158] Mon, 23 February 2004 02:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try to startup shutodwn using control panel/services.
if it fails, make the autostart property to manual in services.
set uR SID
login to sqlplus
issue a shutdown.
startup using the pfile
Re: ora-2710 [message #73474 is a reply to message #73158] Thu, 06 May 2004 23:55 Go to previous message
Dirk Stuermer
Messages: 1
Registered: May 2004
Junior Member
Hi,

thanks a lot. This is a nice workaround. But when I return to startmode a. The same Error occurs.

Greetings
Dirk
Previous Topic: What does refreshing database dump mean?
Next Topic: Load Flat file to SQL table using SQL Loader - Very urgent
Goto Forum:
  


Current Time: Mon Jul 01 16:42:23 CDT 2024