— w sqlplusie zwiększamy:
set serveroutput on
set serveroutput on size 1000000
set serveroutput on size unlimited
Autor: Wiech
ORA-16033: parameter LOG_ARCHIVE_DEST_3 destination cannot be the same as parameter LOG_ARCHIVE_DEST_2 destination
— zdarza się jak zestawiamy Data Guarda idąc na łatwiznę z Cloud Controla i się wysypie, a następnie ponawiamy (wszystko działa aż do restartu bazy i jest niespodzianka bo nie chce wstać)
– wyciagamy spfile z asm-a (bo baza już nie działa)
– robimy pfile ręcznie
ORA-04031: unable to allocate * bytes of shared memory
ORA-04031: unable to allocate * bytes of shared memory
— doraźnie czyscimy shared pool-a
alter system flush shared_pool;
— dodajemy RAM-u i zmieniamy SGA, PGA
show parameter pga;
show parameter sga;
DB Startup fail „ORA-01012: not logged on” (AIX)
— 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
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
— należy zweryfikować zmienne i hosty
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage
RMAN-00571: =======================================
RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571: =======================================
RMAN-03009: failure of backup command on CH1 channel at 03/24/2020 10:45:23
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage
OPATCHAUTO-72043: Patch collection failed.
[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.
ORA-20005: object statistics are locked (stattype = ALL)
— blad przy przeliczaniu statystyk
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at „SYS.DBMS_STATS”, line 34634
ORA-06512: at line 2
kgfnGetConnDetails requires 4 parameters at /u01/app/18.0.0.0/grid/lib/asmcmdbase.pm line 6096
[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].