Oracle Database Discussions

Hi all,

when i tried to restore database ,i gave shutdown abort,and then tried to mount the database using startup mount restrict,i observed the following errors in alert log.i have only one instance with name dbstg,but when try to mount the database it is throwing the errors.



sculkget: failed to lock /u01/app/oracle/product/10.2.0/dbs/lkdbstg exclusive
sculkget: lock held by PID: 18632
Sun Sep 2 08:00:01 2007
ORA-09968: unable to lock file
Linux Error: 11: Resource temporarily unavailable
Additional information: 18632
Sun Sep 2 08:00:03 2007
ORA-1102 signalled during: ALTER DATABASE MOUNT...
Sun Sep 2 08:34:38 2007
Errors in file /u01/app/oracle/admin/dbstg/bdump/dbstg_pmon_3858.trc:
ORA-00474: SMON process terminated with error
Sun Sep 2 08:34:38 2007
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 3858
Sun Sep 2 08:45:02 2007




Sun Sep 2 07:59:59 2007
Starting ORACLE instance (restrict)
Cannot determine all dependent dynamic libraries for /proc/self/exe
Unable to find dynamic library libocr10.so in search paths
RPATH = /ade/aime_has_71410/oracle/has/lib/:/ade/aime_has_71410/oracle/lib/:/ade/aime_has_71410/oracle/has/lib/:
LD_LIBRARY_PATH is not set!
The default library directories are /lib and /usr/lib
Unable to find dynamic library libocrb10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =36
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
processes = 300
sga_max_size = 683671552
__shared_pool_size = 96468992
__large_pool_size = 4194304
__java_pool_size = 134217728
java_pool_size = 134217728
__streams_pool_size = 50331648
streams_pool_size = 50331648
sga_target = 683671552
control_files = /u02/oradata/dbstg/control01.ctl, /u02/oradata/dbstg/control02.ctl
db_block_size = 8192
__db_cache_size = 390070272
compatible = 10.2.0.3
log_archive_dest_1 = LOCATION=/u02/arch/dbstg db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=dbstg)
shared_servers = 5
plsql_debug = TRUE
job_queue_processes = 0
background_dump_dest = /u01/app/oracle/admin/dbstg/bdump
user_dump_dest = /u01/app/oracle/admin/dbstg/udump
max_dump_file_size = 10240
core_dump_dest = /u01/app/oracle/admin/dbstg/cdump
session_max_open_files = 20
db_name = dblv
db_unique_name = dbstg open_cursors = 900
pga_aggregate_target = 24000000
aq_tm_processes = 1
PMON started with pid=2, OS id=3858
PSP0 started with pid=3, OS id=3860
MMAN started with pid=4, OS id=3862
DBW0 started with pid=5, OS id=3864
LGWR started with pid=6, OS id=3866
CKPT started with pid=7, OS id=3868
SMON started with pid=8, OS id=3870
RECO started with pid=9, OS id=3872
MMON started with pid=10, OS id=3874
Sun Sep 2 08:00:01 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=11, OS id=3876
Sun Sep 2 08:00:01 2007
starting up 5 shared server(s) ...
Sun Sep 2 08:00:03 2007
ALTER DATABASE MOUNT
Sun Sep 2 08:00:01 2007
sculkget: failed to lock /u01/app/oracle/product/10.2.0/dbs/lkdbstg exclusive
sculkget: lock held by PID: 18632
Sun Sep 2 08:00:01 2007
ORA-09968: unable to lock file
Linux Error: 11: Resource temporarily unavailable
Additional information: 18632
Sun Sep 2 08:00:03 2007
ORA-1102 signalled during: ALTER DATABASE MOUNT...
Sun Sep 2 08:34:38 2007
Errors in file /u01/app/oracle/admin/dbstg/bdump/dbstg_pmon_3858.trc:
ORA-00474: SMON process terminated with error
Sun Sep 2 08:34:38 2007
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 3858
Sun Sep 2 08:45:02 2007
Starting ORACLE instance (restrict)
Cannot determine all dependent dynamic libraries for /proc/self/exe
Unable to find dynamic library libocr10.so in search paths
RPATH = /ade/aime_has_71410/oracle/has/lib/:/ade/aime_has_71410/oracle/lib/:/ade/aime_has_71410/oracle/has/lib/:
LD_LIBRARY_PATH is not set!
The default library directories are /lib and /usr/lib
Unable to find dynamic library libocrb10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2



from pmon trace file

48B6FCA0 00000814 00000000 00000000 00000000 [................]
48B6FCB0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
48B6FCF0 00000002 [....]
error 474 detected in background process
ORA-00474: SMON process terminated with error
[