Ask a question

How To Resolve Ora-01033

How to slove error 1503?

Hmm. . . try changing your regional setting to Japanese.

How do I resolve the message "Status: Failure -Test failed: IO Error: The Network Adapter could not establish the connection" from Oracle 12?

If your Oracle XE installation was normal and you are still facing the issue, You may try this .Get your local IP address (IPv4 Address) from the command prompt using ipconfigNow, connect to sqlplus as sysdba from the promptsqlplus "/ as sysdba"
Execute the following commandsalter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=&IP)(PORT=1521))' scope=both;
When prompted for IP address, provide your local host’s IP address obtained before .Then run,alter system register;
If it does not work try uninstalling your XE and re-install again.

Oracle error?

Use the below link to solve this error:

Why i am getting this error message after installing oracle 11 g data-base in my lap-top?

Seems like an issue with the shortcut. Also for standalone systems, Oracle 11g XE is sufficient. Unless you need to setup a Database server, install XE.

EXP-00056 :- oracle error 1033 encounter ORA - 01033 -ORACLE initialization or shut down in progress?

It means exactly that - the database is starting up and not yet ready or it's shutting down and will not allow you to connect. (You won't get this if the listener isn't available.)

Schedule your export to occur either before the DB shuts down or several minutes after it starts up.

Oracle initialization or shutdown in progress in oracle 9i?

when i trying to login to oracle 9i database server using sql*plus then this message "oracle initialization or shutdown in progress in oracle 9i" is display, how can i solve this problem.

How do I fix an Oracle error that shows ora-01031?

The ORA-01031: "insufficient privileges" error occurs when you attempt to execute a program or function for which you have not been granted the appropriate privileges.For the DBA, the ORA-01031 can happen if the target OS executables do not have read and execute permissions (e.g. (770) in UNIX/Linux), and ensure that the oracle user is a member of the dba group (e.g. /etc/group). There are similar permission in the Windows registry.Inside Oracle, the "ORA-01031: insufficient privileges" error can be avoided by signing on "as sysdba" with unlimited database privileges.The oerr utility notes this on the ORA-01031 error:ORA-01031: insufficient privilegesCause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the appropriate privilege at a higher label, ask the database administrator to re-grant the privilege at the appropriate label.

I am trying to log in to Oracle 10g via CLI but I am getting an error that says "ERROR: ORA-01033: ORACLE initialization or shutdown in progress." How can I fix this?

Hello ,Check here !ERROR - ORA-01033 oracle initialization or shutdown in progressPossible Causes1. Database might be starting or closing.2. Problem with the Database CTL , DBF or ORA files. These files could have been moved or gone corrupt.3. Database not mounted properly.4. Problem with the DB service.5. Improper shut down of Database.Source: Link AboveThanksSandeep Satone

I am getting this error when connecting to oracle, "ORACLE initialization or shutdown in prgogress"?

Hi -

Either your database is actually in the process of starting up or shutting down - or it is in a bad state and needs to be brought down and started again.

If you're on Windows and have the correct privileges on the server where the database is running, you can stop the OracleService in the Services section of the Control Panel (or Administrative Tool depending on which -version of Windows you're on). Then restart the same service after it stops.
Usually when you start the OracleService on Windows it also tried to open the database, which will happen under normal circumstances. But if recovery is needed it won't start.
Once you've restarted the OracleService, check to see if the database is open:

cmd> set ORACLE_SID=
cmd> sqlplus /nolog
SQL>connect sys/sys_pwd as sysdba

Once connected, then do:

SQL>select count(*) from user_tables;

If you get an error about "fixed-views only" that means your database instance isn't open yet. But if you get actual results
then the database is open for business.
If it isn't open, then do this:

SQL>shutdown immediate;
SQL>startup mount;
SQL>recover automatic database;

Here you'll get a message saying "media recovery complete" or another message with more details about what's wrong

If you get the message "media recovery complete", then
SQL>alter database open;

If you're on Linux or Unix, the process above is mostly different. You'll have to do a kill first (there are no "services" to stop). First, find what to kill off:

$ ps -ef | grep ora

to get a listing of all the Oracle processes still running and kill them

$kill -9 123456

where 123456 is the actual PID of the process returned from the grep above. There's no "service" to start on Linux/Unix, so we'll just start the database.

$sqlplus /nolog
SQL>startup mount;
SQL>alter database open;

Again, you'll either open the database here or get a message about media recovery being needed or another message about what's wrong. In either case, the commands in SQL are the same from here on out for all OS platforms.

Hope this helps.