- ORACLE 10G UPGRADE HOW TO
- ORACLE 10G UPGRADE INSTALL
- ORACLE 10G UPGRADE MANUAL
- ORACLE 10G UPGRADE UPGRADE
- ORACLE 10G UPGRADE SOFTWARE
ORA-00600: internal error code, arguments: When click on “Ignore” an error message shows up:
In Oracle_Server.log: ($ORACLE_HOME/cfgtoollogs/dbua//upgrade/) ORA-06576: not a valid function or procedure name
ORACLE 10G UPGRADE UPGRADE
:-)Ĭase 1: XDB (Oracle XML Database) schema is invalidĭuring the upgrade process an error message shows up: In this post I will write about the errors symptoms, causes and the solutions that worked for me.
Oracle DBA, SQL Server DBA, APPS DBA, Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için a mail atabilirsiniz.During the Oracle Apps Database upgrade to 10g that I wrote about in the previous post, I ran into some errors. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA, Exadata, Goldengate, EBS Consultancy and Training you can send my email adress. I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc.
ORACLE 10G UPGRADE MANUAL
Manual Upgrade Oracle Database From 11.2.0.4 to 12.2.0.1 without DBUAĭo you want to learn Oracle Database for Beginners, then read the following articles. If you want to learn Manual Upgrade method for Oracle 12c, you should read following article. With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production Step -13: Connect to database and query version again. Step -12: Upgrade is completed without errors. Step -10: I have my own backup and restore strategy so I have chosen second option. Step -8: Don’t select if you don’t move database files to new location. Step -7: You can Configure Enterprise manager Database Express or Register with Enterprise Manager Cloud control. Step -6: If you have Custom SQL Scripts, type it in this step.
Server CPU Count> = Parallel count.Ģ- Check ” Recompile invalid objects during post upgrade ” option and select 3 parallelism.Ĥ- Gather stats before upgrade, If your database is very big, then you can unselect it. Here we need to determine the parallelism as the number of CPUs the server has.
ORACLE 10G UPGRADE HOW TO
Step -5: This step is very important to specify options how to uprade.ġ- In the First option, select parallelism count for upgrade. Step -2: Choose Upgrade Oracle Database option. Step -1: Set 12cProfile_db Profile and execute dbua tool like following. LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export LD_LIBRARY_PATHĬLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export CLASSPATH ORACLE_HOME=$ORACLE_BASE/product/12.1.0.1 export ORACLE_HOME ORACLE_HOSTNAME=Kuheylan export ORACLE_HOSTNAME Content of Oracle 12c bash Profile is like following.
ORACLE 10G UPGRADE SOFTWARE
Oracle Database 12c Step by Step Installation On Linux -3Īfter Oracle 12c Software Only installation is completed, then Set New Oracle 12c Profile.
ORACLE 10G UPGRADE INSTALL
I won’t explain how to install Oracle database 12c software in this post. Read following article to install Oracle 12c software. SQL> select instance_name from v$instance With the Partitioning, OLAP, Data Mining and Real Application Testing options Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production I’ll show you new version after the upgrade is completed. I have chosen DBUA ( Database Upgrade Assistant ) in this upgrade.īefore upgrade, connect to the Oracle 11g database and query the database name and version as follows. Oracle Database Upgrade Guide and How to Upgrade Oracle Database Read previous article to learn Oracle database upgrade methods. I will explain how to upgrade Oracle Database from Oracle 11g to Oracle 12c in this article.