quarta-feira, 22 de dezembro de 2010

Get all hidden init parameters in 11G

create pfile='/tmp/init' from memory;

RG-10758 When Creating Text Index Using File Datastor

Cause

It is an expected error as the default behavior of the CTX system parameter FILE_ACCESS_ROLE has changed.

Solution

1. (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 sysdba
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public')

terça-feira, 21 de dezembro de 2010

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

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

segunda-feira, 20 de dezembro de 2010

Moving to Oracle RAC One Node

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

domingo, 12 de dezembro de 2010

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

ID 558596.1

Cause
The 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.



Solution
Please 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 gone.

sábado, 11 de dezembro de 2010

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 folder.

sexta-feira, 10 de dezembro de 2010

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 struct:
ns main err code: 12599

TNS-12599: TNS:cryptographic checksum mismatch
ns secondary err code: 2526
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0


Solution:

Add SQLNET.ENCRYPTION_TYPES_SERVER= (3DES168)to the sqlnet.ora forthe repository database

quinta-feira, 9 de dezembro de 2010

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:09
ORA-19962: compression algorithm ZLIB is not valid with release 11.2.0.0.0


Change rman config:

CONFIGURE COMPRESSION ALGORITHM 'HIGH';

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=142


11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip
[ID 1210883.1]

quinta-feira, 2 de dezembro de 2010

11GR2 Grid Install fail with NTP error

Error:

INFO: NTP daemon slewing option check failed on some nodes
INFO: Check failed on nodes:
INFO: racpre2,racpre1
INFO: 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) failed
INFO: PRVF-9652 : Cluster Time Synchronization Services check failed


Solution:

vi /etc/sysconfig/ntpd

OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"

Move controlfile to ASM

Ex:

restore controlfile to '+DG01' from '+fra01/sigfedb/controlfile/current.260.736637371';

After, change database parameter file.

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 8288940

Database 11.1.0.7 with 11GR2 Grid

Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456.1]

terça-feira, 30 de novembro de 2010

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.pdf

quarta-feira, 17 de novembro de 2010

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 86
ORA-06512: na "SYS.DBMS_METADATA", linha 1245
ORA-04067: n?o executado, package body "DMSYS.DBMS_DM_MODEL_EXP" n?o existe
ORA-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 86
ORA-06512: na "SYS.KUPW$WORKER", linha 8353


Solution: DELETE FROM exppkgact$ WHERE SCHEMA='DMSYS';

segunda-feira, 15 de novembro de 2010

FMW Welcome Page Application (11.1.0.0.) Down

Bug Title: BROKEN 'FMW WELCOME PAGE APPLICATION' APPLICATION DISCOVERED OUT-OF-BOX

1. Apply patch 6880880 (OPatch utility release 11.1.0.8.3) for ORACLE_COMMON

2. 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 apply

3. Restart the OMS
$ $ORACLE_BASE/Middleware/oms11g/bin/emctl start oms

segunda-feira, 1 de novembro de 2010

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 sysdba
3. Using the following syntax, enter the new password:
> @apxxepwd password

sábado, 30 de outubro de 2010

ora-07445 on wwutl_cache_sys.process_background_inval

Ora-07445 on Job 31 ---> Portal after migrate database to 11G

begin wwutl_cache_sys.process_background_inval; end;

Try recompile utl_http and utl_tcp.

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;
end;

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/dbua

quarta-feira, 25 de agosto de 2010

Find the top 10 larger files in the Directory

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

Check if the installed Oracle Software is 32/64

Go to ORACLE_HOME/bin
$ file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

Or

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 bit

quinta-feira, 12 de agosto de 2010

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/login
session required pam_limits.so


DOC ID 301665.1

terça-feira, 10 de agosto de 2010

Problem with Oracle Web Services Manager login

Change default password admin OWSM

cd $ORACLE_HOME/owsm/bin

vi manageUserGroups.properties

user_id=admin
user_name=admin user
user_password={PASSWORD}
user_email=wsmadmin@xxxx.xxx


group_id=su1-grp
group_desc=super user group


./wsmadmin.sh manageUserGroups deleteUserGroup

./wsmadmin.sh manageUserGroups deleteUser

./wsmadmin.sh manageUserGroups addUser

./wsmadmin.sh manageUserGroups addUserGroup



see the $ORACLE_HOME/j2ee/oc4j_soa/log/ccore.log

segunda-feira, 9 de agosto de 2010

Oracle APEX Listener

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

sexta-feira, 9 de julho de 2010

PDF Printing in Application Express

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

quinta-feira, 27 de maio de 2010

frmwebutil.jar 10.1.2.3.0

Versão correta se encontra no Patch 7384879.

quarta-feira, 26 de maio de 2010

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

[oracle@semba scripts]$ ./chgiphost.sh -idm
Oracle Home set to /u01/app/oracle/product/as10g/Infra
Starting 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)
at java.lang.Runtime.loadLibrary0(Runtime.java:788)
at java.lang.System.loadLibrary(System.java:834)
at oracle.chgip.InteractiveInterfaceManager.(InteractiveInterfaceManager.java:72)
at oracle.chgip.InterfaceManager.createInterfaceManager(InterfaceManager.java:133)
at oracle.chgip.InterfaceManager.getInterfaceManager(InterfaceManager.java:113)
at oracle.chgip.Session.(Session.java:97)
at oracle.chgip.StartUp.main(StartUp.java:250)


Cause

There is a bug in the 10.1.2.3 patchset with the libpass.so file, as an incorrect library was included in the patchset media. Bug 7000666 has been filed for this.

Solution

Download and install Patch 7000666 for Linux x86

quinta-feira, 20 de maio de 2010

OracleAS 10.1.3 AS Control Home Page is Very Slow to Appear

Login as root and run:

mv /dev/random /dev/random.real
ln -s /dev/urandom /dev/random

quinta-feira, 15 de abril de 2010

Find a trace file in Oracle 11g

SELECT value
FROM v$diag_info
WHERE name = 'Default Trace File';

sábado, 10 de abril de 2010

"configuration for DISK channel n is ignored"

CONFIGURE CHANNEL N DEVICE TYPE DISK CLEAR;

quinta-feira, 11 de março de 2010

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

Metalink Doc Id:578441.1

Workaround is:

alter system set "_optimizer_cost_based_transformation"=off scope=both;

or create on logon trigger for designer users to alter the session, for
example:
create or replace trigger .on_logon
after logon on database
begin
execute immediate 'alter session set
"_optimizer_cost_based_transformation"=off';
end;