Tag: Osama mustafa dba

ODI-1545: Missing odi supervisor credentials in credential store map

Posted on by Osama Mustafa in Fusion Middleware
This Error appear because missing SuperVisor User Credentials, and you need to create it using wls.sh command, And Since we are working On Oracle_ODI So you have to use WLST.sh from there.

cd /u01/app/fmw/Oracle_ODI1/common/bin
./wlst.sh

and do the below

Jython scans all the jar files it can find at first startup. Depending on the system, this process may take a few minutes to complete, and WLST may not return a prompt right away.

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

wls:/offline> connect (‘weblogic’,’welcome1′,’t3://localhost:7001′)

 Connecting to t3://10.40.74.210:7001 with userid weblogic …
Successfully connected to Admin Server ‘AdminServer’ that belongs to domain ‘IDDomains’.

Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.

wls:/IDDomains/serverConfig> createCred(map=”oracle.odi.credmap”, key=”SUPERVISOR”, user=”SUPERVISOR”, password=”sysadmin1″, desc=”Key for Supervisor”)
Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root.
For more help, use help(domainRuntime)

wls:/IDDomains/serverConfig> createCred(map=”oracle.odi.credmap”, key=”odi11g”, user=”weblogic”, password=”welcome1″, desc=”WLS SUPERVISOR Credential”)

wls:/IDDomains/serverConfig> disconnect()
Disconnected from weblogic server: AdminServer
wls:/offline>
wls:/offline>
wls:/offline>
wls:/offline> exit()

The Red Line for to define 3 command you will use.

Some Link :
1- How To Configure The ODI JavaEE Agent and ODI Console On WebLogic Server (Doc ID 1300550.1)
2- Working with ODI Here

Thank you
Osama Mustafa

API5036: Client version 11.2.0.3.0 is not compatible with repository version 11.2.0.4.0

Posted on by Osama Mustafa in Application

To Solve this error Follow the below Steps :

  • Edit /owb/bin/admin/Preference.properties
  • And set the following parameter :-
    • OverrideRepositoryVersionCheck=true
    • OverrideRuntimeVersionCheck=true
Thank you
Osama Mustafa

Install Oracle EDQ 11.1.1.7 On Oracle Linux 6.4

Posted on by Osama Mustafa in Articles, Fusion Middleware
In This Document I will Show you How to install Oracle Enterprise Data Quality On Oracle Linux 6.4 Operating System.

In old Version Oracle EDQ was no available on Linux Only Windows Operating system as Setup File, But there’s always solution if you want it on Linux you need to use application server in our case weblogic to deploy EDQ on it , some pre requisites need to be done before you do this Please check http://support.oracle.com Document

How To Install EDQ On Linux Using Oracle DB And Apache Tomcat (Doc ID 1462376.1)

Download Document Here

Thank you
Osama mustafa 

User Not Able To Drop Even When I killed the session.

Posted on by Osama Mustafa in Database
Today while i was working on Database trying to Drop user called PRD_MDS the normal error appearing to me :

SQL> drop user PRD_MDS cascade ;
drop user PRD_MDS cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

Which is very normal error and the first thing you are trying to check is v$session

SQL> select sid,serial# ,username from v$session where username like ‘%PRD%’;
       SID    SERIAL# USERNAME
———- ———- ——————————
       745        821 PRD_MDS

SQL> alter system kill session ‘745,821’ immediate ;
System altered.

After this i should be able to drop this user without any problem BUT !!!!

SQL> drop user PRD_MDS ;
drop user PRD_MDS
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

I tried to figure out what is going on , Even i tried alter system kill session 10 times the above error will appear BUT there’s always solutions :

SQL> startup force restrict;
ORACLE instance started.
Total System Global Area 7686086656 bytes
Fixed Size                  2228032 bytes
Variable Size            1811939520 bytes
Database Buffers         5729419264 bytes
Redo Buffers              142499840 bytes
Database mounted.
Database opened.

 SQL> drop user PRD_MDS cascade ;
User dropped.

Oracle Business Intelligence Installation

Posted on by Osama Mustafa in Articles, DevOps Tools, Fusion Middleware
Before start describes steps, I would like to share some notes:
  •     Extend Weblogic Server will not work (config.sh).
  •    BI server should be added first before any managed server otherwise AdminServer will corrupted.
  •   If you already have AdminServer configured you can created new BI Domain, Or backup your AdminServer  domain and Reconfigure again.

The above notes are useful and must be considered before installing Oracle BI.
You can download the document from Here
Thank you

Osama Mustafa

Mount NFS Device Is Busy

Posted on by Osama Mustafa in Operating system
This Error Appear On Solaris when you try to mount filesystem :

mount -F nfs IP:/export/home/oracle/test /export/home/oracle/test

Output :

nfs mount: mount: /export/home/oracle/test : Device busy

Check why it’s Busy using :

fuser -u /export/home/oracle/test

/export/home/oracle/test :     1432c(oracle)

Kill the process :

kill – 9 1432 

Thank you
Osama mustafa 

Example on how to add Virtual Host On em12c

Posted on by Osama Mustafa in Application
Active/Passive Clusterware , how to use it with em12c ? How to monitor OS and Database ? As One Single host Agent will deploy on Both Hosts without Any problem but in this case you will only Deal with one Host as Single not as Clusterware.

i will provide example how to add active/passive Clusterware to em12c :
First Agent should be deploy for single Host not acitve/passive clusterware, after do that Run the below command from Single Host 
 
emctl deploy agent -o -n “Service_name” -A  
The Below Commands should be run from new agent Location 
emctl secure agent
emctl start agent
emctl config agent addinternaltargets
**I prefer to set Service_name —> OracleAgent12cShared.
** Re run the above command on the passive Node after Failover shared storage on it.
Thank you 
Osama Mustafa

Some notes you maybe need for Em12c

Posted on by Osama Mustafa in Application
I would like to share some MOS  Notes that could be useful please note that You can share yours in comments

EM12c R2: How to Upgrade to EM 12c R2 – Two System Method [ID 1363162.1]
EM12c: How to install JVM Diagnostics (JVMD) in Cloud Control [ID 1493862.1]
EM12c: How To Upgrade Plugin On 12.1 Management Agent [ID 1490762.1]
How to Install 12c Agent on Virtual Host [ID 1469995.1]

EM12c Upgrade : Agents Are Not Listed in the Upgrade Console With Error Inventory Data Is Missing From the Repository [ID 1489109.1]

EM 12c : How to Discover All Targets On a Single Host After Agent Installation ? [ID 1386817.1]
EM 12c : Understanding Promote Target Functionality [ID 1386161.1]

EM12c How to Perform Automatic Host Discovery Using IP Scan Method ? [ID 1386811.1]
EM12c Agent status Fails With “Peer Not Authenticated” Error. [ID 1510706.1]

EM12C: Agent Installation Failed With Error: “OMS_HOST and EM_UPLOAD_PORT is not active” [ID 1371873.1]

How To Upgrade Java Diagnostics In Enterprise Manager 12c With the Latest Patches [ID 1534023.1]
EM12c Cloud Control: Required Patches for Discovery and Monitoring of Coherence Targets [ID 1526316.1]

EM12c : Patch Conflict While Applying Patch 14040891 [ID 1479092.1]
Unable To Add host targets with EM12c – Valid Host Name check fails [ID 1433843.1]
Release Schedule of Current Enterprise Manager Releases and Patch Sets (10g, 11g, 12c) [ID 793512.1]
EM 12c: How to Deploy a Plug-In from Enterprise Manager Cloud Control 12.1.0.1 [ID 1364030.1]

Thank you
Osama Mustafa