Oracle Error Code 1033
Also check your alertlog /opt/oracle/admin/databasename/bdump/alert_databasename.log if there are any clues here. ORA-01033: ORACLE initialization or shutdown in progress Cause: An attempt was made to log on while Oracle is being started up or shutdown. Disclaimer: The intent of the site is to help students and professional in their academics and career.Though best effort are made to present the most accurate information, No guarantees are made Against this theory speaks, that the System is normally booting, and the filesystem looks OK. (I checked with bdf). have a peek here
Please try again later. You're now being signed in. but Problem not fixed Regards Poornima Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... anyway this thread again remember your 'BETWEEN DATE QUERY".;-) regards Taj Like Show 0 Likes(0) Actions 11.
Ora-1033 During Publish To Emon Channel
We'll let you know when a new response is added. By this will be best for you. If you can connect then the database is more than likely fine as well.
The usual way of remedying the problem is to use the following sequence of commands from the command line: sqlplus /nolog SQL> connect / as sysdba SQL> shutdown abort SQL> startup So jst followed ur step of accessing as "sqlplus /nolog" and performed the steps mentioned. currently we are using oracle 10g. Cobrowse Error Code 1033 Following Follow Hardware Thanks!
Lutful replied May 21, 2013 Please attach the alert log file that would give a clear understanding of the problem. Ora-01033 Oracle Initialization Or Shutdown In Progress Solution Privacy Reply Processing your reply... first you should take a backup NOW!! I heard of fsck.
SQL> alter database mount; SQL> alter database open; Trial 3 ( if Problem is with the DB service ) go to services.msc and restart the respective DB service. Ora 01033 Oracle Initialization Or Shutdown In Progress 11g Xe Register Hereor login if you are already a member E-mail User Name Password Forgot Password? Thanks 198227Views Tags: none (add) sanContent tagged with san This content has been marked as final. By submitting you agree to receive email from TechTarget and its partners.
Ora-01033 Oracle Initialization Or Shutdown In Progress Solution
The service says that oracle is started. http://itknowledgeexchange.techtarget.com/itanswers/cannot-connect-to-database-oracle-error-1033/ Not the answer you're looking for? Ora-1033 During Publish To Emon Channel more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Ora 1033 Error First thing to do is to check the alert log.
Please try again later. http://sisei.net/error-code/pacemaster-error-code-304.html and check the alert log file ...tell me the detail info from the alter log file..so that i can figer out the actual problem Sep 29 '11 #5 reply Message Re: ORACLE Initialization or shutdown in progress 629530 Mar 20, 2008 9:04 AM (in response to 99427) Thanks Nikhil... Therefore before taking such a drastic measure, I would like to make sure, that the Harddisk is really defective. - is there a way, to check the Harddisk? Ora 01033 Error Solution
Please type your message and try again. rjngh2005 replied May 18, 2013 how is this possible ? Join them; it only takes a minute: Sign up ORA-1033: ORACLE initialization or shutdown in progress up vote 2 down vote favorite I am stuck with a little Oracle problem. Check This Out SQL> alter database mount; Database altered.
Re: ORACLE Initialization or shutdown in progress Mohammed Taj Jan 22, 2007 8:04 AM (in response to 505462) Hi, Can you post complete error ?
but when I exit from SQL * plus GUI Editor and again log in then I can not find my table row with select*from command.the row can not automatically saved. Admin Hi Krishna, When you insert any row in Oracle using SQL * Plus GUI Editor, it doesn't make the changes permanent. Start with setting that to where you installed your Oracle software. Ora-00333 Redo Log Read Error Block How to improve this plot?
Pine Asked: November 30, 20053:15 PM Last updated: December 1, 200510:40 AM Related Questions what is the reason for Harddisk view look like folder view? Then you will avoid all this ping-ponging of questions back to you that slows your resolution. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... this contact form Please solution this problem.
What game is this picture showing a character wearing a red bird costume from? if not then it might be complicated but not undoable to reopen your database but you'll lose some data that was in the logfile 30 pointsBadges: report Cannot connect to Database Get Access Questions & Answers ? Register Hereor login if you are already a member E-mail User Name Password Forgot Password?
If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. If you have any concern regarding the copyright of the content, Contact us with the original reference and the content will be removed. Thanks in anticipation Report message to a moderator Re: ORA-1033 error initialization or shutdown in progress [message #554621 is a reply to message #554617] Wed, 16 May 2012 Post your question and get tips & solutions from a community of 418,616 IT Pros & Developers.