Cannot connect to Database Oracle Error -1033

[Pine]

Hello,

I have a Problem with my B132L-Workstation, running HP-UX 10.20 and Oracle 7.x. An application, which is based on the Oracle database won't start any more with the Error Message:
Cannot connect to Database Oracle Error -1033.

My first guess was, that the Harddisk is defective, or the Database is somehow corrupt. Against this theory speaks, that the System is normally booting, and the filesystem looks OK. (I checked with bdf).
Now what I could probably do, is to buy a new Harddisk, and install all the applications again, but I would loose all the data inside the Database.
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? I heard of fsck. Can this be done safely on a mounted Filesystem?

- is there a way, to repair the Database?

Please help !!!
Pine

[DCE]

if there were no errors during startup, and the files and directories look ok, there probably is nothing wrong with your hard disk. The oracle 1033 error is related to the database being busy

ORA-01033: ORACLE initialization or shutdown in progress
Cause: An attempt was made to log on while Oracle is being started or shut down.
Action: Wait a few minutes. Then retry the operation.


Look at your database itself to correct the problem

[A. Clay Stephenson]

Run oerr ora 1033.

You will be told that you are trying to to login while a shutdown or initialization is in progress. The action associated with this Oracle error is to wait a few minutes and try again

I doubt that you have a corrupt filesystem.
You may have to shutdown the database using svrmgrl. Try shutdown immediate first and then after being patient a shutdown abort. The shutdown abort is a non-friendly shutdown.

[Steven E. Protter]

Shalom Pine,

First, find out if the disk is deffective.

as root:

dmesg

Any warning about lbolt, bad disk?

mstm/cstm/xstm your choice. Test the disk with the excerize function.

If the disk fails the test, then yes you have probably lost the data. The tone of your message seems to apply that you do not in fact have a backup.

It could however be an oracle problem with the data itself. You need to see if the database can be recovered. Of course you can't call oracle, because the database is years past end of support.

The tests above can be safely done on a mounted filesystem.

Next:

umount the filesystem

run this:

fsck -F vxfs -o full -y

example
fsck -F vxfs -o full -y /dev/dsk/c1t1d0

SEP

[Victor Fridyev]

Hi,
The reason for such an error may be a problem with the file system where files of databases are located.
Firs of all ensure that the database is up and running. For this login on the db server as user oracle and run
export ORACLE_SID=YOUR_SID
sqlplus system/manager
If this connect you to the db, check listener status by
lsnrctl stat
If this is OK, check Oracle environment on the client (TWO_TASK and tnsnames.ora file)

HTH

[Indira Aramandla]

Hi Pine,

The error message could happen for numerous reasons.

Error: ORA 1033 : Oracle startup or shutdown in progress. One of the reasons would be that an attempt was made to log on to oracle database, while Oracle is being started up or shutdown.

Wait till the database is up as normal and then try your application. The order should be that when startup, the database should be started first and then the applications accessing the database. When shutdown, the applications accessing the databases should be shutdown first and then the database.
Check the database alert log for more messages and details. And also as Steven mentioned make sure the disk is fine and the file system is ok so as to eliminate them form the problem analysis.

Indira A

[Yogeeraj_1]

hi Pine,

above all make sure you have backups

Keep you old backup and do a full backup immediately. You may be required to do media recovery..

After that you can start troubleshooting.

Using various OS utilities or methods outlined in above replies, you can locate the exact problem.

hope this helps too!

kind regards
yogeeraj

[Pine]

Hello all,

thanks for your replies!
It's unfortunately true, that the last backup is very old.

I checked my Alert.log:

*********************************************************
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 7.3.2.3.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 6000000
control_files = /home/opt/adaaaa/oracle/standard/cntrl1adaaaadb.ctl, /home/opt/adaaaa/oracle/standard/cntrl2adaaaadb.ctl
log_buffer = 163840
log_checkpoint_interval = 10000
db_files = 1021
rollback_segments = rs_1, rs_2, rs_3, rs_4, rs_5, rs_6, rs_7, rs_8, rs_9, rs_10, rs_11, rs_12
sequence_cache_hash_buckets= 10
remote_login_passwordfile= NONE
global_names = TRUE
mts_service = adaaaadb
mts_servers = 0
mts_max_servers = 0
mts_max_dispatchers = 0
audit_trail = NONE
sort_area_retained_size = 65536
sort_direct_writes = AUTO
db_name = adaaaadb
open_cursors = 150
background_dump_dest = /var/opt/adaaaa/log/oracle
user_dump_dest = /tmp
DBWR started
LGWR started
PMON started
RECO started
Wed Nov 30 15:30:31 2005
alter database mount exclusive
Wed Nov 30 15:30:31 2005
Successful mount of redo thread 1.
Wed Nov 30 15:30:31 2005
Completed: alter database mount exclusive
Wed Nov 30 15:30:31 2005
alter database open
Beginning crash recovery of 1 threads
Wed Nov 30 15:31:10 2005
Errors in file /tmp/ora_1269.trc:
ORA-00333: redo log read error block 3003 count 64
ORA-00312: online log 1 thread 1: '/home/opt/adaaaa/oracle/standard/log1adaaaadb.dbf'
ORA-07372: sfrfb: read error, unable to read requested block from database file.
HP-UX Error: 5: I/O error
Additional information: 3003
ORA-333 signalled during: alter database open...
**********************************************************

Usually I connect to the Database from my application. How can I connect to the db-server from a terminal window?

I tried the STM utilities, but these are not installed on my machine. Is it possible to install them on HP-UX 10.20. Is it freeware?

I tried to unmount the filesystem to do a fsck. But it would tell me for all logical volumes, that the device is busy.


Greetings
Pine

[Lars Ebeling]

Is the there no Oracleprocesses running?

If not try to find a file named sgadef.dbf or something like taht.

Move that file to something else and try to start the database.

Regards
Lars

[Lars Ebeling]

I didn't read the last post. If the databaseserver is stopped without shutting down the database first the my soluton could work.

But probably you have to make a recovery see:
http://www.orafaq.net/maillist/oracle-l/2001/12/04/0156.htm

regards
Lars