DB Startup fail „ORA-01012: not logged on” (AIX)

Opublikowano przez Wiech

— sprawdzamy czy jest proces DB

dbnod1:/u01/app/oracle/product/11.2.0.3/db/bin$ ps -ef | grep pmon

— teoretycznie brak instancji ale śmietnik mógł zostać

dbnod1:/u01/app/oracle/product/11.2.0.3/db/bin$ sqlplus / as sysdba
…
Połączono.
SQL> startup
ORA-01012: not logged on

dbnod1:/u01/app/oracle/product/11.2.0.3/db/bin$ sysresv
IPC Resources for ORACLE_SID „DB1” :
Shared Memory:
ID KEY
2097176 0xffffffff
1048599 0xffffffff
1048598 0x8b799a58
Oracle Instance not alive for sid „DB1”

dbnod1:/u01/app/oracle/product/11.2.0.3/db/bin$ ipcrm -m 2097176
dbnod1:/u01/app/oracle/product/11.2.0.3/db/bin$ ipcrm -m 104

OPATCHAUTO-72043: Patch collection failed.

Opublikowano przez Wiech

[root@db1 tmp]# /u01/app/12.1.0.1/grid/OPatch/opatchauto apply /u01/patche/29698592 -oh /u01/app/12.1.0.1/grid -analyz

OPATCHAUTO-72043: Patch collection failed.
OPATCHAUTO-72043: Failed to create bundle patch object.
OPATCHAUTO-72043: Please verify the patch supplied.
OPatchAuto failed.

kgfnGetConnDetails requires 4 parameters at /u01/app/18.0.0.0/grid/lib/asmcmdbase.pm line 6096

Opublikowano przez Wiech

[grid@exa1~]$ asmcmd
kgfnGetConnDetails requires 4 parameters at /u01/app/18.0.0.0/grid/lib/asmcmdbase.pm line 6096.
[grid@exa1 ~]$ /u01/app/18.0.0.0/grid/bin/crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [18.0.0.0.0]
[grid@exa1~]$ /u01/app/18.0.0.0/grid/bin/crsctl query crs softwarepatch
Oracle Clusterware patch level on node exa1is [1180628535].