Tag: Oracle ACE

Enable/Disable SSH For Root User

Posted on by Osama Mustafa in Operating system
Sometimes for any reason you want to enable root ssh using any SSH Client such as putty and only the administrator can login to do this follow the below steps :-

  • vi /etc/ssh/sshd_config
  • search for line as follow :-
    • PermitRootLogin yes and change it to –>  PermitRootLogin no
  • Search for the following lines as well :-
    • DenyUsers root user2 user3
  • Remove the root from Deny User
    • DenyUsers user2 user3
  • /etc/init.d/sshd restart

Stopping sshd: [ OK ]

Starting sshd: [ OK ]

If you want to disable the SSH login for root just keep everything like the above.

Cheers
Osama Mustafa

Enterprise Manager : Performance Across Enterprise Databases

Posted on by Osama Mustafa in Application
The below link is very to understand the performance under #EM12c Provided by oracle, This demonstration shows you how to use AWR Warehouse a new feature of Oracle Enterprise Manager 12c Release 4.

https://www.youtube.com/watch?v=StydMitHtuI&feature=youtu.be

Cheers
Osama Mustafa

ldap utility BINDASAPPUSER FAILED DUE TO INVALID PASSWORD Siebel

Posted on by Osama Mustafa in Application

ldap utility BINDASAPPUSER FAILED DUE TO INVALID PASSWORD

The above error happened to Siebel CRM.

the solution is so simple :-

In my version Siebel configured as SSO because of this OID hold all the application user after check o i found that orcladmin have only one week for password expiration Siebel consider this as error so i increase password policy in OID.

Cheers
Osama  

Creating a Local Yum Repository Using ISO Image

Posted on by Osama Mustafa in Operating system
In this post i will show you how to create Yum repository Using ISO Image, will save more time :-

  • Download The ISO Image and Upload it to the server.
  • Create Folder Under Root User Like the below

cp /OEL6.6. iso /ISOs

  • now create mount point for this ISO.

mkdir p /var/ISO/OEL6.6
Run the below command to mount it :-

mount o loop,ro /ISOs/OEL6.6. iso /var/ISO/OEL6.6

  • Now under /etc/yum.respos.d you can rename it or set enable=0
  •  Create the following file /etc/yum.respos.d/OEL66.repo
  • Edit the file and add 

[OL66]
name=Oracle Linux 6.6
baseurl=file:///var/ISO/OEL6.6
gpgkey=file:///etc/pki/rpmgpg/
RPMGPGKEY
gpgcheck=1
enabled=1

  • Run the below command to clean yum

yum clean all
yum respolist

The output should be like the below :-

repo id repo name status
OL66 Oracle Linux 6.6 25,459 

Thank you
Osama Mustafa

New Features in ORAchk 12.1.0.2.3

Posted on by Osama Mustafa in News
The new ORAchk release 12.1.0.2.3 is now available to download from http://support.oracle.com

Is your database healthy ?

ORAchk can be used with any database depend on your Platform Solaris Intel, Solaris SPARC, ,HP , Linux , you can check the Oracle Support Document :-

ORAchk – Health Checks for the Oracle Stack (Doc ID 1268927.2)

That include the userGuide and how to Use ORAchk with any platforms,

New Features :-

Database performance, install, scalability & ASM
Cross stack checks for Oracle Applications running on Solaris & Oracle Hardware
Enterprise Manager Agents performance and failure to run
Oracle EBS Accounts Payables

Usually the usage like the below :-

./orachk  —> regular healtcheck  + HA best practices
./orachk-c hacheck —> HA best practices Only

Cheers
Osama Mustafa

Apply Jdeveloper Patch

Posted on by Osama Mustafa in Application
This blog post will show you how to apply Patch on Jdeveloper :-

  • Download the latest version of Opatch from http://support.oracle.com
  • Unzip the Patch Folder.
  • Set/export ORACLE_HOME to Jdeveloper hope depend on Operating system
  • Finally Opatch Apply to Jdeveloper Home.
If you faced any error with opatch commad try the below :-

opatch apply -jdk /u01/app/oracle/JDK/160_24

Cheers
Osama Mustafa

OPATCH : Problems with the lock file

Posted on by Osama Mustafa in Database

Problems with the lock file
Lock file exists, details are:
Interim Patch is holding the lock from ……
probably due to previous unsuccessful operation

Seems the Opatch has been interrupted or hanged therefore the .opatch_storage still exists under Oracle Home

ls -ltr $ORACLE_HOME

Search for .patch_storage and delete it

Try Again..

Osama Mustafa

Prerequisite check "CheckActiveFilesAndExecutables" failed

Posted on by Osama Mustafa in Database

Oracle Home       : /u01/app/oracle/product/11.2.0/db_home1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_home1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_home1/cfgtoollogs/opatch/opatch2015-03-09_16-45-09PM_1.log
Verifying environment and performing prerequisite checks…
Prerequisite check “CheckActiveFilesAndExecutables” failed.
The details are:

Following executables are active :
/u01/app/oracle/product/11.2.0/db_home1/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed.
Log file location: /u01/app/oracle/product/11.2.0/db_home1/cfgtoollogs/opatch/opatch2015-03-09_16-45-09PM_1.log

When trying to apply OPatch the above error appear , 
Some process hanged 

oracle@–:~/database_patches/19769496$ fuser /u01/app/oracle/product/11.2.0/db_home1/lib/libclntsh.so.11.1
/u01/app/oracle/product/11.2.0/db_home1/lib/libclntsh.so.11.1:    58536m

Kill -9 58536

Cheers
Thank you