Get all hidden init parameters in 11G

create pfile='/tmp/init' from memo...

Read More

RG-10758 When Creating Text Index Using File Datastor

CauseIt is an expected error as the default behavior of the CTX system parameter FILE_ACCESS_ROLE has changed.Solution1. (Recommended) Create a new role, grant it to the owners of the impacted indexes, and set file_access_role to the new role.- or -2. Set file_access_role to 'public'To change file_access_role, you must be connected as SYSDBA.SQL> connect as sysdbaSQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'publi...

Read More

11gR2 – empty tables skipped by export (deferred segment creation)

http://www.nativeread.com/2010/04/09/11gr2-empty-tables-skipped-by-export-deferred-segment-creati...

Read More

Moving to Oracle RAC One Node

http://www.databasejournal.com/features/oracle/article.php/10893_3906196_1/article....

Read More

On EL/RH 5 ORACLEASM LISTDISKS not Showing Devices After Reboot or Restart

ID 558596.1CauseThe oracleasm scans /proc/partitions and expects devices to be available in /dev. If the device doesn't exist in /dev it will fail to open the device. RHEL/OEL5 does not create dm-xx devices in /dev by default. SolutionPlease comment out the following line in file /etc/udev/rules.d/50-udev.rules#KERNEL=="dm-[0-9]*", ACTION=="add", OPTIONS+="ignore_device"reboot and the problem should be go...

Read More

11g Database Installation failed with “File not found .. WFMLRSVCApp.ear”

If you are installing 11g database and hit error File not found… WFMLRSVCApp.ear, ensure that you have downloaded two disks (for database software) and both disks are unzipped in same fold...

Read More

NI cryptographic checksum mismatch error: 12599.

NI cryptographic checksum mismatch error: 12599 errors in the alert.logs of databases monitored by Oracle Enterprise Manager 11gR1 .***********************************************************************NI cryptographic checksum mismatch error: 12599. VERSION INFORMATION: TNS for Linux: Version 11.2.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production Time: 10-DEC-2010 06:48:19 Tracing not turned on. Tns error...

Read More

RA-19962: compression algorithm ZLIB is not valid with release 11.2.0.0.0

RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of backup plus archivelog command at 12/09/2010 22:12:09ORA-19962: compression algorithm ZLIB is not valid with release 11.2.0.0.0Change rman config: CONFIGURE COMPRESSION ALGORITHM 'HIG...

Read More

Virtual private IP runs on top of the private interface

Highly Available IP / Redundant Private IP in Oracle Grid Infrastructure 11g Release 2 (11.2.0.2 or above)http://oraxperts.com/wordpress/?p=14211gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883...

Read More

11GR2 Grid Install fail with NTP error

Error:INFO: NTP daemon slewing option check failed on some nodesINFO: Check failed on nodes:INFO: racpre2,racpre1INFO: PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "-x"INFO: Clock synchronization check using Network Time Protocol(NTP) failedINFO: PRVF-9652 : Cluster Time Synchronization Services check failedSolution:vi /etc/sysconfig/ntpdOPTIONS="-x -u ntp:ntp -p /var/run/ntpd.p...

Read More

Move controlfile to ASM

Ex:restore controlfile to '+DG01' from '+fra01/sigfedb/controlfile/current.260.736637371'; After, change database parameter fi...

Read More

DBCA 11.1.0.7 fail on Grid 11Gr2

"DBCA could not startup the ASM instance configured on this node. To processd with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?"Apply patch 8288...

Read More

Database 11.1.0.7 with 11GR2 Grid

Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456...

Read More

Oracle Validated rpm

Preparing a Linux box for Oracle Clusterware and RAC installation is made fast and simple with the help of the Oracle Validated Rpm. Downloading and installing the rpm that match you Linux Kernel, automatize the install of the numerous components required to setup OCW and RAC on Linux.http://blogs.oracle.com/AlejandroVargas/Installing-the-Oracle-Validated-rpm-on-EL5....

Read More

KUPW$WORKER.GET_TABLE_DATA_OBJECTS

ORA-39126: Erro fatal inesperado do processo de trabalho em KUPW$WORKER.GET_TABLE_DATA_OBJECTS [] ORA-31642: falha na seguinte instruc?o de SQL: BEGIN "DMSYS"."DBMS_DM_MODEL_EXP".SCHEMA_CALLOUT(:1,0,1,'11.00.00.00.00'); END;ORA-06512: na "SYS.DBMS_SYS_ERROR", linha 86ORA-06512: na "SYS.DBMS_METADATA", linha 1245ORA-04067: n?o executado, package body "DMSYS.DBMS_DM_MODEL_EXP" n?o existeORA-06508: PL/SQL: n?o foi possivel encontrar a unidade de programa que esta a ser chamada : "DMSYS.DBMS_DM_MODEL_EXP"ORA-06512: na "SYS.DBMS_SYS_ERROR", linha 86ORA-06512:...

Read More

FMW Welcome Page Application (11.1.0.0.) Down

Bug Title: BROKEN 'FMW WELCOME PAGE APPLICATION' APPLICATION DISCOVERED OUT-OF-BOX1. Apply patch 6880880 (OPatch utility release 11.1.0.8.3) for ORACLE_COMMON2. Apply patch 9431704- Stop OMS$ cd $ORACLE_BASE/Middleware/oms11g/bin$ ./emctl stop oms -all- Unzip patch 9431704$ cd /home/oracle$ unzip p9431704_111120_Generic.zip- Apply patch$ cd /home/oracle/9431704$ export $ORACLE_BASE/Middleware/oracle_common$ $ORACLE_BASE/Middleware/oracle_common/OPatch/opatch apply3. Restart the OMS$ $ORACLE_BASE/Middleware/oms11g/bin/emctl start ...

Read More

Reset INTERNAL password in APEX

To change the password for the ADMIN account:1. Change your working directory to $ORACLE_HOME/apex.2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:$ sqlplus sys/SYS_password as sysdba3. Using the following syntax, enter the new password:> @apxxepwd passw...

Read More

ora-07445 on wwutl_cache_sys.process_background_inval

Ora-07445 on Job 31 ---> Portal after migrate database to 11Gbegin wwutl_cache_sys.process_background_inval; end;Try recompile utl_http and utl_t...

Read More

wwsrc_event_q_mgmt.propagate(true); - job broken

begin wwsrc_event_q_mgmt.disable_propagation_job; wwsrc_event_q_mgmt.stop_queue; wwsrc_event_q_mgmt.drop_queue; e...

Read More

The Upgrade Assistant failed in bringing up the database

"The Upgrade Assistant failed in bringing up the database . Oracle Home obtained from file /etc/oratab was used to connect to the database. Either the database is not running from Oracle Home or the correct Initialization Parameter file (pfile) was not found." Try to remove files on:/u01/app/oracle/cfgtoollogs/d...

Read More

Find the top 10 larger files in the Directory

$ls -lrt | awk '{print $5,$9}' | sort -nr head | xargs ls -...

Read More

Check if the installed Oracle Software is 32/64

Go to ORACLE_HOME/bin$ file oracleoracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not strippedOr select metadata from sys.kopm$ ;If the output has 'B023' string then the database is 32 bit else if it is B047 then it is 64 ...

Read More

pam_limits.so setting for 64-bit Linux

Removing the hardcoded path allows the OS to choose the correct pam_limits.so/etc/pam.d/loginsession required pam_limits.soDOC ID 30166...

Read More

Problem with Oracle Web Services Manager login

Change default password admin OWSMcd $ORACLE_HOME/owsm/binvi manageUserGroups.propertiesuser_id=adminuser_name=admin useruser_password={PASSWORD}user_email=wsmadmin@xxxx.xxxgroup_id=su1-grpgroup_desc=super user group./wsmadmin.sh manageUserGroups deleteUserGroup./wsmadmin.sh manageUserGroups deleteUser./wsmadmin.sh manageUserGroups addUser./wsmadmin.sh manageUserGroups addUserGroupsee the $ORACLE_HOME/j2ee/oc4j_soa/log/ccore....

Read More

Oracle APEX Listener

http://www.oracle.com/technology/products/database/application_express/apex_listener/apex_listener.h...

Read More

PDF Printing in Application Express

http://www.oracle.com/technology/products/database/application_express/html/configure_printing.h...

Read More

frmwebutil.jar 10.1.2.3.0

Versão correta se encontra no Patch 73848...

Read More

chgiphost.sh - ELF file data encoding not little-endian

[oracle@semba scripts]$ ./chgiphost.sh -idmOracle Home set to /u01/app/oracle/product/as10g/InfraStarting Change Hostname/IP...Change Hostname/IP completed successfully.Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/app/oracle/product/as10g/Infra/chgip/lib/libpass.so: /u01/app/oracle/product/as10g/Infra/chgip/lib/libpass.so: ELF file data encoding not little-endian at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586) at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1511)...

Read More

OracleAS 10.1.3 AS Control Home Page is Very Slow to Appear

Login as root and run:mv /dev/random /dev/random.realln -s /dev/urandom /dev/ran...

Read More

Find a trace file in Oracle 11g

SELECT valueFROM v$diag_infoWHERE name = 'Default Trace Fil...

Read More

"configuration for DISK channel n is ignored"

CONFIGURE CHANNEL N DEVICE TYPE DISK CLE...

Read More

Oracle Designer - ORA-7445 when deleting an object from the Repository

Metalink Doc Id:578441.1Workaround is:alter system set "_optimizer_cost_based_transformation"=off scope=both;or create on logon trigger for designer users to alter the session, forexample:create or replace trigger .on_logonafter logon on databasebeginexecute immediate 'alter session set"_optimizer_cost_based_transformation"=off';e...

Read More