Oracle Certification by me

-



OCA Certified Associate


OCI Foundation Certified .

Comments

Post a Comment

Popular posts from this blog

SSO USER SYNC Steps

-
Image
  USER SYNC IN PRODUCTION   1.        Login to PRD System Administrator -> Security -> User 2.        Query the user F11 -> Enter username -> Ctrl F11   If User does not exists, Check it in ODSM   3.        Login to ODSM http://x1oama01.mnao.net:7012/odsm   Click Data Browser -> Enter the Username & Search In the Name section if User exists. Click on User Attributes-> Managed Attributes -> Show all   Scroll down to get the GUID of the user. Note down the orclguid   To manually create the user Disable the profile option Application SSO LDAP Synchronization   Create the user manually with default password. DO NOT ASSIGN ANY RESPONSIBILITY   Make the user SSO enabled select user_name,user_guid from fnd_user where user_name in ('RKURLE');   Update the guid: ...
Read more

PSU Patching step by step on RAC

-
OPatch utility version 12.1.0.1.7 or later to apply this patch. Grid Patch:---------------------------------------------------------------------------------------------------------------- From Oracle Home as oracle user:- /o001/home/oracle/product/12.1.0/db_1/OPatch/opatch lsinventory -detail -oh /o001/home/oracle/product/12.1.0/db_1 From Grid Home as grid user:- /o001/home/12.1.0/grid/OPatch/opatch lsinventory -detail -oh /o001/home/12.1.0/grid As root user:- /o001/home/12.1.0/grid/OPatch/opatchauto apply /o002/Oct_PSU_Patch/26635815 -analyze export PATH=/o001/home/12.1.0/grid/OPatch:$PATH opatchauto apply <UNZIPPED_PATCH_LOCATION>/27010872 Check Oracle permission $ORACLE_HOME/lib/libsqlplus.so --- Should be 644 From both oracle and grid users:- opatch lsinventory col ACTION_TIME for a30 col BUNDLE_SERIES for a15 select ACTION_TIME,PATCH_ID,PATCH_UID,VERSION,ACTION,STATUS,BUNDLE_SERIES,BUNDLE_ID from dba_registry_sqlpatch; ###################################Amar Jadhav ######...
Read more

Configure PCP [Enabling Internal monitor in distributed Application tiers

-
Image
Set Up Parallel Concurrent Processing in Apps/EBS R12 Edit the applications context file via Oracle Applications Manager, and set the value of the variable APPLDCP to ON. Go to - System Administrator responsibility  -> OAM Setup -> Site Map -> Auto Config -> click on Edit Parameters icon of the desired application tier node       Repeat the same for the second Apps Tier node i.e. appsode_new.localdomain Execute AutoConfig by running the following command on all concurrent processing nodes: -- Node 1 [oracle@appsnode_new ~]$ hostname appsnode_new.localdomain [oracle@appsnode_new ~]$ adautocfg.sh -- Node 2  [oracle@appsnode2_new ~]$ hostname appsnode2_new.localdomain [oracle@appsnode2_new ~]$ adautocfg.sh Check the tnsnames.ora and listener.ora configuration files, located in $INST_TOP/ora/10.1.2/network/admin. Ensure that the required FNDSM and FNDFS entries are present for all other concurrent nodes. -- Node 1 [oracle@appsnode...
Read more