Tag: osama oracle

Step by Step Configure SSO Using Oracle Fusion Middle-ware

Posted on by Osama Mustafa in Articles, DevOps Tools, Fusion Middleware
I would like to share this document , which is describe step by step dealing with :

  • WebLogic
  • Oracle Internet Directory
  • Oracle Content Server
  • Oracle Access manager 
Every thing mentioned with Installation &  Configuration Steps.
I tried To make it simple as i can, Included with Screen Shots ,Step By Step how to install The above Oracle Products and how to configure them to prepare your application for Single-Sing-On 
Please if you would like to share this document ask me before.

You can View and Download the Document from Here
Thank you 
Osama mustafa

SIEBEL odbcsql Unable to Connect

Posted on by Osama Mustafa in Application

Logging into “SBA_81_DSN” as “SADMIN” …
ODBC error 81 in SQLConnect:
523 72
(native error 0).
Unable to login using specified ODBC parameters.

The above error appear when you are trying to run the below command:

odbcsql /s SIEBEL8_DSN /u sadmin /p sadmin

Solutions :

Make sure the you set TNS_ADMIN in .profile or .bash_profile , TNS_ADMIN Should be Directed to Client32 bit , Copy tnsnames.ora from Database home to Client32

it will be like the following :

export TNS_ADMIN=/u01/app/oracle/instanctclient32/

Thank you
Osama mustafa

Queryable Patch Inventory New Features 12c

Posted on by Osama Mustafa in Database
Again !!! Oracle 12c Under test , every time i tested it i discover new features, while i am testing today i found new folder under $ORACLE_HOME called QOPatch , for the first time when i opened this folder i only found two files,

Check the https://support.oracle.com note :

Oracle Database 12.1 : FAQ on Queryable Patch Inventory [ID 1530108.1] 

from the name you can see it’s retrieve  information  using query, and to use query you have to get access to SQL Plus, this features  allow you access to the OPatch information from within the database.  This Package called  DBMS_QOPATCH

Some of Attribute to use with this package :

  • GET_OPATCH_INSTALL_INFO
  • SET_CURRENT_OPINST
  • GET_OPATCH_LIST
  • IS_PATCH_INSTALLED
  • GET_OPATCH_DATA
  • GET_OPATCH_BUGS
  • GET_OPATCH_FILES
  • GET_OPATCH_COUNT
  • GET_OPATCH_PREQS
  • GET_OPATCH_OLAYS
  • PATCH_CONFLICT_DETECTION
  • GET_PENDING_ACTIVITY
  • GET_OPATCH_XSLT
  • GET_OPATCH_LSINVENTORY
  • GET_SQLPATCH_STATUS

Since this function used to get Opatch information within database then you have to access to SQL Plus 
Check the below examples :

SQL> select dbms_qopatch.get_opatch_lsinventory() from dual;

DBMS_QOPATCH.GET_OPATCH_LSINVENTORY()
——————————————————————————–

Another Examples :

SQL> select dbms_qopatch.GET_PENDING_ACTIVITY() from dual;
DBMS_QOPATCH.GET_PENDING_ACTIVITY()
——————————————————————————–

My Database still fresh and not patch yet So you will not find that much of information 
Thank you 
Osama mustafa

Move Datafiles Online 12c

Posted on by Osama Mustafa in Database
As you know Oracle database 12c released Yesterday and we all still test it and learn what are the new features !!

For the first time in Oracle Database you can move objects online without offline or shutdown database which is very useful and helpful for any DBA’s

Check the example below :

SQL> select file_name from dba_data_files ;

FILE_NAME
——————————————————————————–
/u01/app/oracle/oradata/db12c/system01.dbf
/u01/app/oracle/oradata/db12c/sysaux01.dbf
/u01/app/oracle/oradata/db12c/users01.dbf
/u01/app/oracle/oradata/db12c/undotbs01.dbf

Let’s move system01.dbf 
SQL> alter database move datafile ‘/u01/app/oracle/oradata/db12c/system01.dbf’ to ‘/u01/system.dbf’;

SQL> select File_name from dba_data_files ;
FILE_NAME
——————————————————————————–
/u01/system.dbf
/u01/app/oracle/oradata/db12c/sysaux01.dbf
/u01/app/oracle/oradata/db12c/users01.dbf
/u01/app/oracle/oradata/db12c/undotbs01.dbf

Thank you
Osama mustafa 

cannot unmount ‘/export/home/oracle’: Device busy

Posted on by Osama Mustafa in Operating system
Operating System : Solaris 11

When run the below command :

zfs destroy rpool/export/home/grid

 cannot unmount ‘/export/home/oracle’: Device busy

Solution :

zfs unmount rpool/export/home/grid
zfs destroy rpool/export/home/grid

Thank you
Osama mustafa

Which module You installed on Apps

Posted on by Osama Mustafa in Application
Sometimes you need to check which module you installed in oracle E-business suite and to do that there’s more one way :

using Query / as Apps User :

SELECT a.application_name,a.product_code,
DECODE (b.status, ‘I’, ‘Installed’, ‘S’, ‘Shared’, ‘N/A’) status,
patch_levelFROM apps.fnd_application_vl a,
apps.fnd_product_installations b
WHERE a.application_id = b.application_id
and b.status=’I’ order by product_code asc;

Using adutconf.sql scripts which is located in $AD_TOP

This script include information about Product installation status, version and other information.

Using Oracle Application Manager ( OAM )

Site Map —> License Manager Which licensed word means installed.

Simple

Thank you
Osama Mustafa

Step By Step Remove Oracle Table Lock

Posted on by Osama Mustafa in Database
All your query should be done using sys user or system user, after that you need to find Session SID with below query :

SQL> SELECT SESSION_ID
  2  FROM DBA_DML_LOCKS
  3  WHERE NAME = ‘EMP_INFORMATION’;

Where EMP_INFORMATION is Table_name

Output :

SID
___
424

Next step it’s talking about How to find Serial# :

SELECT SID,SERIAL#
FROM V$SESSION
WHERE SID IN (SELECT SESSION_ID
FROM DBA_DML_LOCKS
WHERE NAME = ‘EMP_INFORMATION’)

Output :

SID                SERIAL#
—-                 ——-
424                 1103

Use Alter system To kill this session :
ALTER SYSTEM KILL SESSION ‘SID,SERIALl#’;

Thank you
Osama mustafa


Deploy Agent In Enterprise Manager 12c

Posted on by Osama Mustafa in Application
After I post about how to install Oracle Enterprise manager ( em12c ) today i will talk how to deploy em12c agent

there’s two method to do that

1) Configuring Automatic Discovery
2) Adding targets Manually

I will describe the both 🙂 each one separately

Before deploy you need to decide if you want to use Oracle user or root user the below steps you have to do before using oracle :

[root@em12c ~]# vi /etc/sudoers

and change and add the following lines :
Comment this line :

#Defaults    requiretty

add the below line

oracle  ALL=(ALL)       ALL

and remove ! from this line :

Defaults   visiblepw

Now On em12c There’s something called privilege delegation

Privilege delegation allows a logged-in user to perform an activity with the privileges of another user. Sudo and PowerBroker are privilege delegation tools that allow a logged-in user to be assigned these privileges. These privilege delegation settings will be used for all provisioning and patching activities on these hosts.

Read more here.

in the screen below add these lines :
/usr/bin/sudo -u %RUNAS% %COMMAND%

/usr/bin/sudo —> location for sudo command.

 after all the above steps are done let’s configure Auto Discovery

Setup –> add target –> configure auto discovery  the below screen will open, choose the first option “Host and oracle vm manager Discovery using Ip scan”

 Press create Button

On add Button new Panel Will open , Choose your Host and Choose the Range Ip for scan The Format Mentioned above examples :

192.168.1.240-250
192.168.240/10
192.168.240,241

 Now you need to configure Job Summary

the job will start immeditaly as we choose press “Refresh Ip Scan Result” to check The result. you can check it also from here :

Check the Host

Next Post will be How to Add Agent Manually .

You can Download this Article From here.

Thank you
Osama Mustafa