Monthly Archives: July 2017

Invalid Username/Password for all users logging into OBIEE (#OBIEE11g)

Issue: Invalid Username/Password for all users logging into OBIEE <Jan 9, 2017 9:26:15 AM EST> <Error> <oracle.wsm.resources.security> <hostname> <bi_server2> <[ACTIVE] ExecuteThread: ’12’ for queue: ‘weblogic.kernel.Default (self-tuning)’> <<anonymous>> <> <jjskshdmdm@kl^^^hmdbnsl123> <1389277575608> <WSM-00008> <Web service authentication failed.javax.security.auth.login.LoginException: [Security:090304] Authentication Failed: User bisystemoid … Continue reading

Posted in OBIEE, WebLogic | Leave a comment

Running ADOP on 12.2.6 is failing at initial Validation with error “adop is not able to detect any valid application tier nodes”

Issue: While running the “Prepare” phase in adop in R12.2.6, I encountered the below error, Running ADOP on 12.2.6 is failing at initial Validation with error “adop is not able to detect any valid application tier nodes” Enter the APPS … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

Add Bulk of users to Weblogic and add groups to user using WLST and Python Scripting (#addweblogicusers)

Create user: The syntax for creating the user is as below, but the command for creating user should be passed in a python script from WLST. Invoke the wlst and connect to Domain in which the users need to be … Continue reading

Posted in WebLogic | 3 Comments

Informatica Power Center Migration to a Different server (#InformaticaMigration, #PowerCenter)

Scope of this blog post: Informatica Power Center Domain and Repository service which is setup on a server (single node) needs to be migrated to a new/different server. This information is analogous to do a DR (Disaster Recovery) for Power … Continue reading

Posted in Informatica | 5 Comments

Migrating 2 node RAC Cluster to new H/W and Adding a Failed Node back in RAC Cluster (#OracleRACAddNode, #OracleRAC)

Scenario: RAC Cluster Database which was setup on 2 nodes, needs a migration to new H/W. Also, adding to this, the 2nd node of RAC Cluster is dead just before this activity was started (& this 2nd node cannot be … Continue reading

Posted in Oracle Database, Oracle RAC | Leave a comment

ORA-39117: Type needed to create table is not included in this operation

Issue: ORA-39117: Type needed to create table is not included in this operation. Failing sql is: CREATE TABLE “MVDEMO2″.”CITIES_US” (“LOCATION” “MDSYS”.”SDO_GEOMETRY” , “CITY” VARCHAR2(42 BYTE), “STATE_ABRV” VARCHAR2(2 BYTE), “POP90” NUMBER, “RANK90” NUMBER) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS … Continue reading

Posted in OBIEE, Oracle Database | Leave a comment