ORA-29548: Java system class reported: Solution
ORA-29548: Java system class reported: Solution Check the database for error: SQL> select dbms_java.get_jdk_version() from dual; select dbms_java.get_jdk_version() from dual …
Read More12c far sync database creation and configuration Step by step using dgmgrl
Create the Pfile for farsync: ===================== Instance parameter file – as a copy of primary database configuration (not necessary) *.audit_file_dest=’/home/oracle/admin/test12c/adump’ *.audit_trail=’db’ *.compatible=’12.1.0.0.0′ *.control_files=’/u01/app/oracle/oradata/test12c/control01.ctl’,’/u01/app/oracle/oradata/test12c/control02.ctl’,’/u01/app/oracle/oradata/test12c/control03.ctl’ *.db_block_size=8192 *.db_domain=” *.db_name=’test12c’ *.diagnostic_dest=’/u01/app/oracle’ *.dispatchers='(PROTOCOL=TCP) (SERVICE=test12cXDB)’ *.log_archive_dest_1=’location=/u01/app/oracle/oradata/test12c/arch’…
Read MoreACFS File system creation Step by Step
Manual Creation of ACFS filesystem Create the directory for the acfs in each node. ================================ # mkdir -p /oracle/app/oracle/acfsmounts/data_acfsvol3 Change the permission: ================= # chown oracle:oinstall /oracle/app/oracle/acfsmounts/data_acfsvol3 Create the Volume…
Read MoreSteps to fix below constraint issue while doing an alter table
Please find the below as an example and see the steps for fixing. Failing sql is: ALTER TABLE “ABC”.”DEF” ADD CONSTRAINT “G_490” FOREIGN KEY (“ORDERS_ID”) REFERENCES “ABC”.”ORDERS” (“ORDERS_ID”) ON DELETE…
Read MoreRecreation of Temporary Tablespace
Steps to implement 1. alter database backup controlfile to trace; 2. select file_name,tablespace_name from dba_temp_files; 3. create temporary tablespace tempbkp tempfile ‘/u01/oradb/tempbkp.dbf’ size 10m; 4. alter database default temporary tablespace…
Read MoreORA-19809: limit exceeded for recovery files
SQL> startup ORACLE instance started. Total System Global Area 599785472 bytes Fixed Size 1250356 bytes Variable Size …
Read MoreORA-16028: new LOG_ARCHIVE_DEST_STATE_2 causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ALTERNATE SCOPE=BOTH; ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ALTERNATE SCOPE=BOTH * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-16028: new LOG_ARCHIVE_DEST_STATE_2 causes…
Read MoreQuery to check RMAN job status
Please use the below query to check for RMAN job status in DB level. col INPUT_TYPE format a15 col STATUS format a12 col START_TIME format a18 col END_TIME format a18…
Read MoreDRG-10701: preference CTXSYS.DEFAULT_LEXER already exists
While creating oracle text indexes when we get below error. @?/ctx/admin/defaults/drdefus.sql DRG-10701: preference CTXSYS.DEFAULT_LEXER already exists DRG-10701: preference CTXSYS.DEFAULT_WORDLIST already exists DRG-12500: stoplist DEFAULT_STOPLIST already exists DRG-12500: stoplist EXTENDED_STOPLIST already…
Read MoreChanging the oc4jadmin password for a Application Server
Log in to the server where oc4j is running Locate the following configuration file in the Oracle home of the OC4J instance: ORACLE_HOME/j2ee/oc4j_instance_name/config/system-jazn-data.xml vi system-jazn-data.xml file and locate the following…
Read More