In this article i am describing Step by step how to upgrade database using dbua , in part 2 i will use the manual upgrade process.
The Link For Document : Here
Thank you
Osama mustafa
Tag: Oracle Blog .
Enterprise manager Performance Hub (Real Time) 12c
Enterprise manager express is
SQL> drop user osama cascade ;
User dropped.
SQL> create user osama identified by osama;
User created.
SQL> grant select any table to osama;
Grant succeeded.
SQL> grant select any dictionary to osama ;
Grant succeeded.
SQL> grant create session to osama;
Grant succeeded.
SQL> conn osama/osama ;
Connected.
SQL> EXEC DBMS_SQL_MONITOR.BEGIN_OPERATION (‘My_First_JOB’, forced_tracking => ‘Y’);
BEGIN DBMS_SQL_MONITOR.BEGIN_OPERATION (‘My_First_JOB’, forced_tracking => ‘Y’); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00221: ‘BEGIN_OPERATION’ is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
to avoid this error :
SQL> VAR myjob_id NUMBER;
SQL> EXEC :myjob_id := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘My_First_JOB’, forced_tracking => ‘Y’)
PL/SQL procedure successfully completed.
Where
myjob_id : variable
My_first_Job : Job name.
Now Check Enterprise manager express Page :
if you check the second picture you will see if you don’t stop the sql_monitor the Job will still running
SQL> EXEC DBMS_SQL_MONITOR.END_OPERATION(‘My_First_JOB’, :myjob_id) ;
PL/SQL procedure successfully completed.
Thank you
Osama Mustafa
12c Oracle Support Document until now
Second day for 12c database since it was officially published, There is no much offical document from oracle https://support.oracle.com until now. But i tried to collect as much as i can and share it here
RMAN Enhancements in Oracle 12c [ID 1534487.1]
Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC) [ID 1520299.1]
Oracle Database 12.1 : FAQ on Queryable Patch Inventory [ID 1530108.1]
Oracle Database 12c Release 1 (12.1) Upgrade New Features [ID 1515747.1]
Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) [ID 1503653.1]
Changes For Oracle Database 12.1 Standalone Installation [ID 1483380.1]
Requirements for Installing Oracle Database 12.1 on Solaris 10 SPARC [ID 1517948.1]
Requirements for Installing Oracle Database 12.1 on RHEL6 or OL6 64-bit (x86-64) [ID 1529864.1]
Requirements for Installing Oracle Database 12.1 64-bit (AMD64/EM64T) on SLES 11 [ID 1519770.1]
How To Downgrade Oracle Database 12c Release 1 (12.1) To Previous Versions [ID 1516622.1]
How to Drop/Truncate Multiple Partitions in Oracle 12C [ID 1482264.1]
Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA
[ID : NOTE:1493645.1]
RMAN RECOVER TABLE Feature New to Oracle Database 12c [ID 1521524.1]
How to Merge Multiple Partitions in Oracle 12C [ID 1482263.1]
How to Create Interval-Reference Partitioned Tables in Oracle 12c [ID 1519042.1]
Include to all above documents you can find all new features and document in one place, my friend Steve Karam on his blog (Click Here) collect all folks articles that has been posted about DB12c, it’s really worth to take alook and share it.
Thank you
Osama mustafa
Oracle Java SE Critical Patch Released
“The June 2013 Oracle Java SE Critical Patch Update was released on June 18, 2013. Oracle strongly recommends applying the patches as soon as possible.
The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, a summary of the security vulnerabilities, and a pointer to obtain the latest releases and patches.”
June 2013 Oracle Java SE Critical Patch Update: Here
The next four scheduled dates for Oracle Java SE Critical Patch Updates are:
16 April 2013
18 June 2013
15 October 2013
14 January 2014
Thank you
Osama mustafa
cannot mount ‘rpool/u01’ on ‘/u01’: mountpoint or dataset is busy
When you try to use the below command :
zfs create -o mountpoint=/u01 rpool/u01
Error :
cannot mount ‘rpool/u01’ on ‘/u01’: mountpoint or dataset is busy
The Solution :
- First destroy rpool/u01
- zfs create rpool/u01
- zfs set mountpoint=/u01 rpool/u01
- mkdir /u01
- zfs mount /u01
Thank you
Osama Mustafa
Some notes you maybe need for Em12c
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
Enable FTP On Redhat
to enable FTP on Redhat on you have to follow to follow the below step,you need to define which user will use the FTP, in this article i will use root user :
Edit the files /etc/vsftpd.ftpusers and /etc/vsftpd.user_list looks like :
#
# List of users denied access to the FTP server, see ftpusers(4).
#
root
daemon
bin
sys
adm
lp
uucp
nuucp
dladm
netadm
netcfg
smmsp
xvm
mysql
openldap
webservd
nobody
noaccess
nobody4
unknown
zfssnap
aiuser
and remove root user from each file.
You can control ftp as services from
/etc/init.d/vsftpd
Thank you
Osama Mustafa
ORA-00607/ORA-00600
ORA-00600: internal error code, arguments: [4193], [4271], [4056], [], [], [], [], []
As you see the above error ORA-00600 usually Indicate for Bug, A mismatch has been detected between Redo records and Rollback (Undo) records. and to solve this issue you need to do the below :
SQL> show parameter undo
NAME TYPE VALUE
———————————— ———– ——————————
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS
SQL> alter system set undo_management=’MANUAL’ scope=spfile;
SQL > Shutdown immediate ;
SQL > Startup ;
SQL > create undo tablespace NEW_UNDOTBS datafile ‘/u01/app/oracle/oradata/SID/NEW_UNDOTBS01.DBF’ size 1G ;
SQL> alter system set undo_tablespace=’NEW_UNDOTBS’ scope=spfile;
System altered.
SQL> alter system set undo_management=’AUTO’ scope=spfile;
System altered.
After Shutdown The new Effect Should be Taken And If you want to Drop Old Undo you can do This another option you can use is Take if Offline. Sometimes when you want to drop Old Undo you receive new error :
SQL> drop tablespace UNDOTBS01 including contents;
ORA-01548: active rollback segment ‘_SYSSMU1_1255349037$’ found, terminate dropping tablespace
So What Can i do Take Offline Or The Below Option :
SQL> select * from v$rollname ;
USN NAME
———- —————–
0 SYSTEM
1 _SYSSMU1$
2 _SYSSMU2$
3 _SYSSMU3$
4 _SYSSMU4$
5 _SYSSMU5$
6 _SYSSMU6$
SQL > Create Pfile=’/u01/New.init’ from spfile
File Created
SQL > Shutdown immediate ;
Edit pfile
*.undo_management=’MANUAL’
*.undo_retention=1800
*.undo_tablespace=’NEW_UNDOTBS’
*._offline_rollback_segments= (_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$ )
- Startup database from new pfile without create spfile ;
- try to Drop Tablespace Now, this way should work.
- After drop Undo Tablespace, Remove _offline Parameter and undo_management to AUTO
Thank you
Osama Mustafa
Upgrade R12.1.1 To R12.1.3
To Upgrade Oracle EBS R12.1.1 To R12.1.3 Follow the Below Steps :
From https://support.oracle.com you have to download the following patch :
- p9239090_R12_LINUX_1of6.zip
- p9239090_R12_LINUX_2of6.zip
- p9239090_R12_LINUX_3of6.zip
- p9239090_R12_LINUX_4of6.zip
- p9239090_R12_LINUX_5of6.zip
- p9239090_R12_LINUX_6of6.zip
- p9239095_R12_GENERIC.zip
- p9822544_R12.MSC.B_R12_GENERIC.zip(Optional)
- p10349415_R12.AD.B_R12_GENERIC.zip (Optional)
- p9239089_R12.AD.B_R12_LINUX.zip
Before Start Working You have to shutdown all application Services using ( adstpall.sh ) and enable maintenance mode using adadmin
Run the Patch in Order like the following, before apply Any Patch you need to check README.txt for any Pre-Install Step/Post-Install Step
1- Start with patch Number 9239089 , before do that on Readme.txt you have to do the below :
-Open Two Session ( Terminal ) Run Apps Env On Terminal #1, Terminal #2 run database Env.
-On DB Terminal Create under $ORACLE_HOME/Appsutil/admin
-Copy adgrants.sql (Unix) from patch folder to Above folder.
-From $ORACLE_HOME/appsutil/admin Run adgrants.sql
-sqlplus /nolog
-SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
2-Apply Patch 10349415
3-Apply Patch 9239090
4-Apply Patch 9239095
5-Apply patch 9822544
6-Apply Patch 9817770
7-Apply Patch 9966055
After you Applied all the above patch Do the below steps :
On Application Tier :
- Run Autoconfig ( Which is Located $ADMIN_SCRIPT_HOME )
- Run the admkappsutil.pl ( Located in $AD_TOP/bin/admkappustil.pl ) Using the below command
perl /bin/admkappsutil.pl
This will generate new appsutil.zip located in $INST_TOP/admin/out
On Database Tier :
Copy appsutil from Application tier to $ORACLE_HOME,Unzip in under $ORACLE_HOME Like the below
- cd $ORACLE_HOME
- unzip appsutil.zip
- Run autoconfig for Database Tier located in ( $ORACLE_HOME/appsutil/admin) –> adauto.sh
Finally two more simple step, you need to run adpreclone on Database Tier & application Tier using the below command :
- perl adpreclone.pl dbTier (located in $ORACLE_HOME/appsutil/admin)
- perl adpreclone.pl appsTier (Located in $ADMIN_SCRIPT_HOME)
Disable Maintenance mode now.
Sqlplus apps/***
SQL> select release_name from fnd_product_groups;
RELEASE_NAME
————————————————–
12.1.3
Start Application Services using ( adstrtall.sh )
Thank you
Osama mustafa
" java.lang.UnsatisfiedLinkError" When Run Oracle EBS
Exception in thread “main” java.lang.UnsatisfiedLinkError: /u01/media/StageR12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXi.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.load0(Unknown Source)
at java.lang.System.load(Unknown Source)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.(Unknown Source)
at java.awt.Component.(Unknown Source
This error appear while trying to ./rapidwiz in Oracle EBS , and it’s regarding to Wrong packager version
First you need to remove the old package using :
rpm -e –nodeps
Install the required package from the below link :
Package libXi 32bit Here
Package libXi 64bit Here
Re Run the Installer again
Enjoy
Thank you
Osama Mustafa
Technology Geek 