on 12-31-2009 8:01 AM
hi,
sap not start that the oracle not start.
alert.log;
USER: terminating instance due to error 445
Instance terminated by USER, pid = 364796
trace:
pmon not start
open: The file access permissions do not allow the specified action.
Warning: executed in non-root mode
procstack cannot verify that /unix matches the running kernel.
Kernel symbols might not be validated.
thank in advance
1) Did you try starting the DB from SQLPLUS as orasid?.
2) After peforming the install/upgrade of oracle,as part of the upgrade/install you should apply all the necessary opatches .opatches are very critical and our helpful in resolving several critical bugs.It is a must inorder to have your DB running smooth.
go to service.sap.com ->downloads->DB Pactches ->Oracle ->yourversion->opatches
and download the list of opatches for your DB and OS and apply it
Check SAPnot 839182 to know how to install opatches.
Hope it helps,
Gerard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think some of processes hung and shouldn't get released.
kill all the oracle processes from OS level and restart....then SAP
Regards
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
open: The file access permissions do not allow the specified action
I think its perminission peoblems on files.
Check the permissions of ORACLE_HOME...
Also check if there is any more error information.
Thanks,
Sachin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Waited for process PMON to initialize for 70 seconds
2009-12-31 09:06:52.478
Dumping diagnostic information for PMON:
OS pid = 462918
loadavg : 0.00 0.01 0.06
swap info: free_mem = 5786.82M rsv = 66.00M
alloc = 5.37M avail = 16896.00M swap_free = 16890.63M
F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD
240001 A prtadm 462918 1 0 60 20 2c855b510 85156 09:05:42 - 0:00 ora_pmon_PRT
open: The file access permissions do not allow the specified action.
Warning: executed in non-root mode
procstack cannot verify that /unix matches the running kernel.
Kernel symbols might not be validated.
procstack: open(/proc/462918/ctl): The file access permissions do not allow the specified action.
2009-12-31 09:06:52.556
2009-12-31 09:07:02.557
Waited for process PMON to initialize for 80 seconds
2009-12-31 09:07:02.557
Dumping diagnostic information for PMON:
OS pid = 462918
loadavg : 0.00 0.01 0.06
swap info: free_mem = 5786.80M rsv = 66.00M
alloc = 5.37M avail = 16896.00M swap_free = 16890.63M
F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD
240001 A prtadm 462918 1 0 60 20 2c855b510 85156 09:05:42 - 0:00 ora_pmon_PRT
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.