2010 Alex Zaballa - DBA Oracle - ex-Oracle ACE Director, OCM, OCA, OCP, OCE, OCS

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')

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

10:24 No comments

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

Moving to Oracle RAC One Node

12:41 No comments

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

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

13:23 No comments

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.

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

13:28 1 comment

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.

NI cryptographic checksum mismatch error: 12599.

03:53 No comments

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

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

19:22 No comments

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

17:18 No comments

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]

11GR2 Grid Install fail with NTP error

13:40 No comments

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

13:39 No comments

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

13:37 No comments

"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

13:32 No comments

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

Oracle Validated rpm

14:17 No comments

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

KUPW$WORKER.GET_TABLE_DATA_OBJECTS

13:13 No comments

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

FMW Welcome Page Application (11.1.0.0.) Down

07:44 No comments

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

Reset INTERNAL password in APEX

05:41 No comments

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

ora-07445 on wwutl_cache_sys.process_background_inval

17:29 No comments

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

16:18 No comments

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

12:17 3 comments

"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

Find the top 10 larger files in the Directory

08:56 No comments

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

Check if the installed Oracle Software is 32/64

08:55 No comments

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

pam_limits.so setting for 64-bit Linux

06:39 No comments

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

Problem with Oracle Web Services Manager login

13:05 No comments

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

Oracle APEX Listener

12:46 No comments

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

PDF Printing in Application Express

13:13 No comments

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

frmwebutil.jar 10.1.2.3.0

12:57 No comments

Versão correta se encontra no Patch 7384879.

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

07:42 No comments

[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

OracleAS 10.1.3 AS Control Home Page is Very Slow to Appear

11:38 No comments

Find a trace file in Oracle 11g

13:19 No comments

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

"configuration for DISK channel n is ignored"

15:41 No comments

CONFIGURE CHANNEL N DEVICE TYPE DISK CLEAR;

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

05:59 No comments

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;