This content has been marked as final. Show 9 replies
Seems you got a problem with a controlfile.
IBM AIX RISC System/6000 Error: 13: Permission deniednote that the O.S. error seems to be an access right problem, so run:
to check if you have enough access rights to open/lock the file.
ls -al /oracle/QAS/sapdata1/cntrl/cntrlQAS.dbf id
check do u have proper permission to access this file?
and also check whether Is this file is access by 9i database or not.if this is the condition then shutdown the database and startup from 10g home.
27086, 00000, "skgfglk: unable to lock file - already in use"
// *Cause: the file is locked by another process, indicating that it is
// currently in use by a database instance.
// *Action: determine which database instance legitimately owns this file.
When i ls -al is gives this '
-rwxrwxr-x 1 oraqas dba 31678464 Jul 03 13:03 /oracle/QAS/sapdata1/cntrl/cntrlQAS.dbf
And on this server there is only one database and i m opening by oracle_home 10g
this file system is on Raw Device SAN any idea...........
Thanks for quick response
1.before starting the oracle,verify there is no oracle process on server by
ps -ef|grep ora_
2.Did you started ur database after logging from oraqas user(OS user).?
this is the output below
oraqas 16> ps -ef|grep ora_
oraqas 20802 1 0 Jul 02 - 0:01 ora_mmnl_QAS
oraqas 22088 1 0 Jul 02 - 0:01 ora_mmon_QAS
oraqas 23014 1 0 Jul 02 - 0:00 ora_reco_QAS
oraqas 25134 1 0 Jul 02 - 0:01 ora_smon_QAS
oraqas 26492 1 0 Jul 02 - 0:04 ora_ckpt_QAS
oraqas 28206 1 0 Jul 02 - 0:01 ora_lgwr_QAS
oraqas 28486 1 0 Jul 02 - 0:01 ora_dbw0_QAS
oraqas 28884 1 0 Jul 02 - 0:01 ora_mman_QAS
oraqas 29400 1 0 Jul 02 - 0:01 ora_psp0_QAS
oraqas 32950 1 0 Jul 02 - 0:06 ora_pmon_QAS
oraqas 42326 39020 0 13:23:35 pts/0 0:00 grep ora_
yes im logging with this user only yaar.
Already one database is running and controlfile is in use. Did you migrated the 9i database to 10g...?
yes im migrating form 9i to 10g r2.
What does fuser -c /oracle/QAS/sapdata1/cntrl/cntrlQAS.dbf come back with?This lists what processes are accessing the file and in what mode.
When you are migrating, you should shutdown your 9i database first and then from 10g Oracle home start the database as "startup upgrade" and then run the catupgrd.sql ( found in the new 10g Oracle_home/rdbms/admin).