Asmcmd cp command gives ORA-15046

Copy process with following command for asm gave ORA-15046 error ,

asmcmd> cp +DISKGROUP1/thread_1_seq_113238.728.870731045 +DISKGROUP2/thread_1_seq_113238.728.870731045


ASMCMD-8016: copy source->'+DISKGROUP1/thread_1_seq_113238.728.870731045' and target->'+DISKGROUP2/thread_1_seq_113238.728.870731045' failed
ORA-15056: additional error message
ORA-15046: ASM file name '+DISKGROUP2/thread_1_seq_113238.728.870731045' is not in single-file creation form
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 413
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

According to metalink target filename should not contain number incarnation.File is not in a form that can e used to create single file.

In order to fix this below command can be used in like form

asmcmd> cp +DISKGROUP1/thread_1_seq_113238.728.870731045 +DISKGROUP2/thread_1_seq_113238

WWC-41417 UNABLE TO LOGIN TO PORTAL

When user is unable to login Portal system with following error , deletion of user record from  portal.wwsec_person$ table can solve this issue.

Internal error (WWC-00006)
Unexpected error encountered in wwsec_app_priv.process_signon (User-Defined Exception) (WWC-41417)
There is a conflict with your assigned user name. There is a user entry with this name, but with a different globally unique identifier, which must be resolved before you can log on with this name. Notify your administrator. (WWC-41742)

According to MOS , this issue can occur when user is deleted from OID or recreated in OID and portal tables are not getting the update.

Unexpected SYSAUX tablespace growth because of WRH$_LATCH_CHILDREN

For a while , I have seen unexpected growth at SYSAUX tablespace . When listed objects ordered by size , WRH$_LATCH_CHILDREN table is on the top and as a result of examination , it was caused from statistics_level parameter. For a performance issue i have changed this parameter from TYPICAL to ALL to get more detail information . But after performance issue resolved , i have not changed parameter back and it affected tablespace SYSAUX increased to bigger values.

After changing parameter to old value "TYPICAL" , growth decreased to expected values.


Not only statistics_level parameter can cause this issue according to metalink note, also low snapshot interval can cause. For interval 60 minutes is ideal.

MapViewer Runtime Failure After Upgrading BI from Release 11.1.1.6 to Release 11.1.1.7

After upgrade of current OBIEE to 11.1.1.7 from 11.1.1.6 when trying to access mapviewer URL (http://localhost:7001/mapviewer  below error occured.

"HTTP 500 Internal Server Error" 

Mapviewer was deployed into bi_server1 and related logfile were examined located at $DOMAIN_HOME/bifoundation_domain/servers/bi_server1/logs. Log files had entries like

WatchRuleType: Log
WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'WL-101020') OR (MSGID = 'WL-101017') OR (MSGID = 'WL-000802') OR (MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802'))
WatchData: DATE = Dec 5, 2014 8:49:56 PM EET SERVER = bi_server1 MESSAGE = [ServletContext@1774584388[app:mapviewer module:/mapviewer path:/mapviewer spec-version:2.5 version:11.1.1]] Root cause of ServletException.
java.lang.NoClassDefFoundError: oracle/adfinternal/view/faces/taglib/html/HtmlHtmlTag
        at java.lang.Class.getDeclaredConstructors0(Native Method)
        at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
        at java.lang.Class.getConstructor0(Class.java:2699)
        at java.lang.Class.newInstance0(Class.java:326)
        at java.lang.Class.newInstance(Class.java:308)

As a solution Oracle  suggests to delete some files of MapViewer deployment and delete the Weblogic internal cache of the MapViewer application. 

1. Stop Managed server (bi_server1)
2. Delete the following files from MapViewer deployment MW_HOME/Oracle_BI1/bifoundation/jee/mapviewer.ear

• web.war/WEB-INF/lib/adf-faces-api.jar
• web.war/WEB-INF/lib/adf-faces-impl.jar
• web.war/WEB-INF/lib/commons-digester.jar
• web.war/WEB-INF/lib/commons-logging-1.1.jar
• web.war/WEB-INF/lib/jsf-api.jar
• web.war/WEB-INF/lib/jsf-impl.jar
• web.war/WEB-INF/lib/jsr173_1.0_api.jar
• web.war/WEB-INF/lib/mvutil.jar
• web.war/WEB-INF/lib/xdb.jar
• web.war/WEB-INF/adf-faces-config.xml
• web.war/WEB-INF/orion-web.xml

 3. Delete the directory
 MW_HOME/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/mapviewer_11.1.1

4. Restart the managed server

Source 
http://docs.oracle.com/cd/E28280_01/doc.1111/e14770/biee.htm#CHDJIDBD

Tips & Tricks 4 : Conditional index

Client asked me if it is possible to create unique index on any table on condition. For example only 1 record is acceptable for any document which has active_flag as '1'. For active_flag '0' there can be more than 1 record.

In order to do this  we will create unique index with condition

SQL> create table t1 (document_id number,active_flag char(1));

Table created.

SQL> create unique index t1_idx on t1(case when active_flag='1' then document_id else null end);



For active_flag as '1' index will be populated with document_id , and for '0' not.
 
SQL> insert into t1 values (1,'1');

1 row created.

SQL> insert into t1 values (2,'1');

1 row created.

SQL> insert into t1 values (1,'0');

1 row created.

SQL> insert into t1 values (1,'0');

1 row created. -- able to insert same record

SQL> insert into t1 values (1,'1');
insert into t1 values (1,'1')
*
ERROR at line 1:
ORA-00001: unique constraint (TEST.T1_IDX) violated

-- Not able to insert same record for active_flag '1' value .

Tips & Tricks 3 : Exclude table ,schema from Expdp

From command line if you would like to exclude table , tables or schema following command can be used .

For specific table(s)

expdp system/pass directory=dp_dir dumpfile=sample.dmp exclude=TABLE:\ "IN \(\'TAB1\',\'TAB2\',\'TAB3\'\)\"

For schema(s)

expdp system/pass directory=dp_dir dumpfile=sample.dmp exclude=SCHEMA:\ "IN \(\'SCHEMA_NAME1\',\'SCHEMA_NAME2\'\)\"

Tips & Tricks 2 : Disable autostart of High Availability Service

Whenever  any components like ASM,listener,database is down, or when server restarted, component called HAS (High Availability Service) restarts the failed components and bring them up. This is done automatically. Sometimes it is not wanted to start itself automatically. In order to disable these property below command is executed ,

[root@test01 bin]# ./crsctl disable has
CRS-4621: Oracle High Availability Services autostart is disabled.
[root@test01 bin]#

http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart004.htm#CIHGFJEB