database connection failed

[vijill]

One of my test dbserver h/d failed .vendor replaced harddidsk.afterthat We have a error msg database connection failed;check db server and network.

PLease tell me where are the places need to check.. but i can able to start the database. if i connect my client to that test environemnt , i have received above error msg.


regards.

[davey23uk]

whats the real error message and where is it coming from

[vijill]

Sorry, it seems like database itself is having pblem cannot start the database also.

error msg is ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/HISTEST/HIS/his1/HIS/system01.dbf'

SQL> startup
ORACLE instance started.

Total System Global Area 277674108 bytes
Fixed Size 116860 bytes
Variable Size 113545216 bytes
Database Buffers 163840000 bytes
Redo Buffers 172032 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/HISTEST/HIS/his1/HIS/system01.dbf'
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release
Please give me reply.

regards.

[yxez]

Its obvious your data is gone with the old disk....If u have backup then u can recover, but u can reinstall new again...anyway
its a test db, but mind you test db is as important as PROD db,
thats why you have to learn to backup often.

[vijill]

I can see below error on this test server bump alert log file. Is it need to recover or what is the solution of this error.Please give me reply.

alvernia4racle> tail -100 alert_HISTEST.log
Thu Sep 14 12:17:05 2006
Errors in file /Oracle/home/admin/HISTEST/bdump/dbw0_51724_histest.trc:
ORA-01157: cannot identify/lock data file 122 - see DBWR trace file
ORA-01110: data file 122: '/HISTEST/HIS/his3/HIS/users_indx01.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 8
Additional information: 42666
Additional information: 32767
Thu Sep 14 12:17:05 2006
Errors in file /Oracle/home/admin/HISTEST/bdump/dbw0_51724_histest.trc:
ORA-01157: cannot identify/lock data file 123 - see DBWR trace file
ORA-01110: data file 123: '/HISTEST/HIS/his3/HIS/his_sync01.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
IBM AIX RISC System/6000 Error: 13: Permission denied

[yxez]

well, its obvious ....can be one of the following:

1. Another process is using/locking the files.
2. The files have different ownership.

Check the directories/files if existing and the owner and
the flags

[vijill]

Is there any unix command to know the no. of files locks curently used?

regards.

[yxez]

None of those i knwo of....but even if there is, i dont think u can
relate it to ur database file locking problems. Do u have other
more than 1 instance running on ur server?

[vijill]

yes, there was 4 instances are running under this server.

[thomasp]

If these files exist in the right locations , you might have some process locking these files maybe, an os backup perhaps?