- Oracle 10g upgrade install#
- Oracle 10g upgrade update#
- Oracle 10g upgrade upgrade#
- Oracle 10g upgrade windows#
Oracle 10g upgrade upgrade#
CONNECT role after upgrade has only CREATE SESSION privilege. WARNING: -> Deprecated CONNECT role granted to some user/roles.
Oracle 10g upgrade install#
To successfully upgrade Ultra Search, install it from required to be installed from the 10g Companion CD. The 'Oracle interMedia Image Accelerator' is is required to be installed from the 10g Companion CD. The 'JServer JAVA Virtual Machine' JAccelerator (NCOMP) Obsolete/Deprecated Parameters: Ĭomponents: WARNING: -> "session_max_open_files" needs to be increased to at least 20 WARNING: -> "streams_pool_size" is not currently defined and needs a value of AUTOEXTEND additional space required: 2 MB > XDB tablespace is adequate for the upgrade. > ODM tablespace is adequate for the upgrade. > EXAMPLE tablespace is adequate for the upgrade. AUTOEXTEND additional space required: 13 MB > DRSYS tablespace is adequate for the upgrade. > CWMLITE tablespace is adequate for the upgrade. > TEMP tablespace is adequate for the upgrade. > UNDOTBS1 tablespace is adequate for the upgrade. > SYSTEM tablespace is adequate for the upgrade. The sections describe the output of the Upgrade Information Tool (utlu102i.sql). Then, check the spool file and examine the output of the upgrade information tool. A few registry$ tables may be created, if they do not already exist, and some rows may be inserted into existing Upgrade tables.
Also, the instance must not be running in read-only mode. Please note: The instance can be running in normal mode and does not need to be running in a restricted (migrate / upgrade) mode to run the script. Then run and spool the utlu102i.sql file. Start SQL*Plus and connect to the database instance you are intending to upgrade (running from the original old ORACLE_HOME) as a user with SYSDBA privileges.
Change to the temporary directory that you copied files in previous step. Make a note of the new location of these files.ġ4. copy the following files from the 10gR2 ORACLE_HOME/rdbms/admin directory to a directory outside of the Oracle home, such as the e:\upgradetemp directory on your system: Total System Global Area 1469131144 bytesġ3. Start the 9i database in normal mode (Must) from 9i sqlplus tool,
Oracle 10g upgrade update#
Update the path entry and remove 10ghome that is in begining of PATH variable so that we can connect to 9i database using 9i home.Īfter update in path parameter the new value is,Ĭ:\Documents and Settings\jde.QIA>set pathġ2. \system32 C:\WINDOWS C:\WINDOWS\System32\Wbem C:\Program Files\System Center Ope Re\1.4.2\bin\client E:\oracle\ora92\jre\1.4.2\bin C:\Program Files\Oracle\jre\1.ģ.1\bin C:\Program Files\Oracle\jre\1.1.8\bin C:\Program Files\HP\NCU C:\WINDOWS Studio 8\VC\bin E:\JDEdwards\E812\DDP\Verity\winx86\_nti40\bin E:\oracle\ora92\j Path=e:\oracle\ora10g\bin E:\oracle\ora92\bin C:\Program Files\Microsoft Visual Install Oracle 10g Release 2 in a new Oracle Home i.e, Install 10201+companion(select Oracle Database 10g Products 10.2.0.1+10204patchset in e:\oracle\ora10g Backup c:\program files\oracle folder which contains Inventory directory.ġ0. Les\Oracle\jre\1.1.8\bin C:\Program Files\HP\NCU C:\WINDOWS\system32 C:\WINDOWS Ĭ:\WINDOWS\System32\Wbem C:\Program Files\System Center Operations Manager 2007\ Path=E:\oracle\ora92\bin C:\Program Files\Microsoft Visual Studio 8\VC\bin E:\JDĮdwards\E812\DDP\Verity\winx86\_nti40\bin E:\oracle\ora92\jre\1.4.2\bin\client E Before 10g install note the path parameter. SQL> select objecT_name,Object_type,owner from dba_objects where status='INVALIDĨ. Made startmode=manual for database in registryĦ. Exported Oracle Registry as backup to flash\jdedbupgraderough directory.ĥ. Delete OracleOraHome92TNSListenerlistener_10g service through the add+remove services.exe tool.Ĥ. On SRPSFTWEB: Stopped Oracle-oc4jadminProcessManagerģ. On SRPSFTDEP: Stopped OracleMTSRecoveryService service Most important stop JDE service 'JDE E812'. OracleMTSRecoveryService services manual, On SRPSFTENT: Stopped and made OracleOraHome92HTTPServer &
Oracle 10g upgrade windows#
SRPSFTENT -> Microsoft Windows 2003 Server Enterprise Edition SP2. Upgraded JDEdwards oracle database from 9i to 10g using the standard database upgrade procedure,ġ.
0 kommentar(er)
