CLSRSC-184 CLSRSC-258: Failed to configure and start ASM


[root@rac1 ~]# /oracle/app/12.1.0.2/grid/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME=  /oracle/app/12.1.0.2/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /oracle/app/12.1.0.2/grid/crs/install/crsconfig_params
2015/11/21 22:03:46 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.

Continue reading

Advertisements

ORA-01194: file 1 needs more recovery to be consistent


ORA-01194: file 1 needs more recovery to be consistent

Method 1:

1) Start the database in mount state

SQL> startup mount;

2) Recover the database.

SQL> recover database;

If you come across below error

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: ‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBTEST\SYSTEM01.DBF’

then, do the following

1)

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 766152 generated at 03/16/2013 12:12:04 needed for thread 1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/DUPDB/archivelog/2013_03_16/o1_mf_1_14_%u_.arc

ORA-00280: change 766152 for thread 1 is in sequence #14

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_03_14/o1_mf_1_10_8n43no4v_.arc

ORA-00310: archived log contains sequence 10; sequence 14 required

ORA-00334: archived log:

‘/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_03_14/o1_mf_1_10_8n43no4v_.arc’

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1:

‘/u01/app/oracle/oradata/DUPDB/datafile/o1_mf_system_7qm3ck4o_.dbf’

2)

Continue reading

ORA-15041: diskgroup space exhausted


PROBLEM:
The following are the errors seen during tablespace creation in an Oracle DB with ASM.

ERRORS:
NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: Performing Inline Action Command: CREATE TABLESPACE “RRWEBC_IAS_WEBCENTER” EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO DATAFILE ‘+DATA’ SIZE 250M AUTOEXTEND ON NEXT 250M MAXSIZE UNLIMITED
2010-02-09 23:27:35.187 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-01119: error in creating database file ‘+DATA’
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15041: diskgroup space exhausted

SOLUTION:
The related disk group could have run out of space, due to more number of tablespaces, in this case there were 84. Firstly look for space, and appropriately cleanup some of them or just new disks.

To Check:
select NAME, OS_MB, TOTAL_MB, FREE_MB from v$asm_disk;

To Cleanup:
drop tablespace <NAME> including contents and datafiles;

To Increase Disk Space:
alter diskgroup DISK1 rebalance power 11;
alter diskgroup DISK2 add disk ‘path’;
alter diskgroup test_dg add disk ‘/dev/hdb10′,’/dev/hdb11’;

Listener Can’t Startup at Windows 64 bit


I installing Oracle 11gR2 on Windows 7 64 bit and configure my first Listener using netca when my laptop get IP 10.8.106.25. Then i want startup my listener when my laptop IP get IP 192.168.0.199, I get this error while i’m try to startup my listener in services tools. the picture shown below :

Continue reading

Solving ORA-12516: TNS:listener could not find available handler with matching protocolstack


Hai..friends…mao share pengalaman nie tentang error ORA-12516. Pagi-pagi baru aja mandi pagi dimana seharusnya hari itu sedang off day alias tidak masuk kantor, lihat handphone udah ada 4 miscall wkwkwkwk….ternyata setelah telepon balik ternyata salah satu customer yang kemarin harinya saya lakukan installation Oracle 11g dan migrasi data dari oracle 9i ke 11g. Mereka bilang muncul ORA-12516 dan tidak banyak user yang bisa konek ke oracle. alhasil setelah cek mereka ternyata mempunyai user lebih dari 100…

akhirnya saya guide mereka untuk melakukan ubah parameter :

login as sysdba then :

SQL> alter system set processes=1000 scope=spfile;

SQL> alter system set sessions=500 scope=spfile;

SQL>commit;

SQL>shutdown immediate;

SQL>Startup;

Continue reading

Solve ORA-01157 Cannot identify/lock data file string & ORA-01110 datafile unknown/missing problem


ORA-01157:cannot identify/lock data file string – see DBWR trace file


Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected.

However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.
Action: Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.

 
ORA-01111 & ORA-01110 datafile unknown/missing problem

Continue reading

ORA-01078: failure in processing system parameters


Beberapa waktu lalu, saya sedang coba installasi oracle database 10g di salah satu bank terpenting di Indonensia =p
kemudian pada saat saya aka melakukan startup database bertemu dengan error ORA-01078.

[oracle@siddb-drc ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Wed Oct 6 15:24:15 2010

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

Continue reading