Upgrade an oracle server and database

https://tccustomization.blogspot.com/

Upgrade an oracle server and database

• Log on to the oracle server with an administrator account.
• Export the contents of your Teamcenter Oracle database to the dump file using the following command in SQL plus.

ORACLE_HOME\bin\expdp db-user/password full=y dumpfile=file-name.dmp logfile=export.log

replace db-user = teamcenter database usernae e.g: infodba

replace password = teamcenter database password e.g.infodba 

• Store a dump file.
• If you have multiple databases repeated a process for each database.

Terminate oracle session

• Log in on the operating system as the user having the administrative privilege.
• an open Service dialog box in the windows control panel.
• Select the Oracle TNS listener services (Oraclerelease-IDTNSListener) and click Stop.

shutdown oracle database

Using the window control panel

• Log in on the operating system as the user having the administrative privilege.
• Open the Services dialog box in the Windows Control Panel
• Select the OracleServiceSID service Replace SID with the system identifier of the database instance.
• Click stop.

Using SQL*plus

• Log in on the operating system as the user having the administrative privilege.
• start a SQL utility.
• replace password with a password for sys account.
• Oracle starts the Oracle SQL*Plus utility

sqlplus sys/password@Oracle—SID as sysdba

• Shut down the database instance by typing the following command.
• shutdown
• Exit SQL*Plus:
• exit

Backup of oracle installation

1. Before upgrading a new version of oracle backup an existing version of the oracle.
2. Back up the following :
1. The Oracle home directory on each installed workstation.
2. The directories containing database files for each configured database.
3. The Oracle Net listener.ora and tnsnames.ora configuration files.

Upgrading oracle :

there are two ways to upgrade the oracle server and database:

1. Oracle installer.
2. Uninstalling/reinstalling Oracle.

Using oracle installer :

1. Launch oracle installer.
2. When the Oracle installer prompts you to upgrade existing databases, enter the required information about the databases you want to upgrade.

Using  uninstalling and reinstalling

1. Remove existing Oracle databases.
2. Uninstall all existing Oracle server software.
3. Install oracle server then Configure oracle and create an Oracle database.
4. After completing the installation, import your Teamcenter database from the oracle dump file into a new oracle database.

ORACLE_HOME\bin\imp db-user/password fromuser=db-user touser=db-user file=file-name.dmp log=import.log

 

replace a user and password with your system administrator password.

Do you Know :

The sys user must be in the Oracle sysdba group for the Oracle system identifier (SID) used by Teamcenter. To connect as internal (without a password), the account must be part of the ORA_DBA local group in Windows.