| error starting oracle [message #142280] |
Fri, 14 October 2005 01:21  |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
hi
i have tried but it gives me following
C:\Rajdocs\perl>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 13 13:57:14 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> Shutdown abort
ORA-01031: insufficient privileges
SQL>
SQL> connect sys/manager as sysdba
Connected.
SQL>
SQL> Shutdown abort
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL>
SQL> alter database recover
2 ;
alter database recover
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> Alter database recover
2 ;
Alter database recover
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL>
|
|
|
|
| Re: error starting oracle [message #142286 is a reply to message #142280] |
Fri, 14 October 2005 01:33  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
--> Why you ran Shutdown abort ? Was there any specific reason to do that ?
see this
| Quote: |
Shutting Down with the ABORT Option
You can shut down a database instantaneously by aborting the database’s instance.If possible, perform this type of shutdown only in the following situations:
-- The database or one of its applications is functioning irregularly and none of the other types of shutdown works.
-- You need to shut down the database instantaneously (for example, if you knowa power shutdown is going to occur in one minute).
-- You experience problems when starting a database instance.
When you must do a database shutdown by aborting transactions and user connections, issue the SHUTDOWN command with the ABORT option:
SHUTDOWN ABORT
An aborted database shutdown proceeds with the following conditions:
-- No new connections are allowed, nor are new transactions allowed to be started, after the statement is issued.
-- Current client SQL statements being processed by Oracle are immediately terminated.
-- Uncommitted transactions are not rolled back.
-- Oracle does not wait for users currently connected to the database to disconnect. Oracle implicitly disconnects all connected users.
The next startup of the database will require instance recovery procedures.
|
and you wrote
| Quote: |
Alter database recover
|
The above command is used for media recovery and you are facing an instance recovery and it would be done by Oracle smon process itself.
What if you try this
post the result after running this command.
|
|
|
|
| Re: error starting oracle [message #142297 is a reply to message #142286] |
Fri, 14 October 2005 01:52 |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
HI
Thanks for reply
actually when creating database in oracle my system gets restarted.
when i tried to logon to my oracle it says
ORA-01033:Oracle initilization or shut down in progress.
plz help me to over come this problem
Oracle 9i on win 2000.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
|
|
|
|
| Re: error starting oracle [message #142301 is a reply to message #142297] |
Fri, 14 October 2005 02:00 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Try this
Shutdown the database
and then close the Oracle service named oracleSID.
control panel --> administrative tools --> services .
again restart Oracle service and then try to startup the database.
Was you able to create the database ? If not , are you trying to access the same database that was not created ?
|
|
|
|
| Re: error starting oracle [message #142308 is a reply to message #142301] |
Fri, 14 October 2005 02:06 |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
I am unable to logon to oracle, becuase when i start oracle either from cmd or from enterprise mgr. it searches for that dbf that is not created but the entry is there in control file
|
|
|
|
| Re: error starting oracle [message #142309 is a reply to message #142297] |
Fri, 14 October 2005 02:11 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| rajeev_jain2001 wrote on Fri, 14 October 2005 12:22 |
actually when creating database in oracle my system gets restarted.
when i tried to logon to my oracle it says
ORA-01033:Oracle initilization or shut down in progress.
|
If you were not able to create the database at this time then you need to create a database again. because only then you would be able to use it.
regards,
tarun
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
