Configure oracle software

 https://tccustomization.blogspot.com/

Configure oracle software

Configure oracle net

1. Teamcenter uses Oracle Net protocols to communicate with an Oracle database.
2. These protocols require that you run a listener process (OracleTNSListener) on the Oracle server to listen for remote connect requests and that all clients can translate the service alias identifying the server and database.

Configure oracle listener

1. Start oracle net manager.
2. Start→All Programs→Oracle -instance-name→Configuration and Migration Tools→Net Manager.
3. Or search for Net Manager.

Create a listener.ora file

• Expand Local icon.
• select Listener folder and choose Edit→Create.
• Accept the default listener name (LISTENER) and click OK.
• Click the Add Address button.
• Specify the port number.
• In the Local tree, click Profile.
• In the Naming list (to the right of the Oracle Net Configuration tree), choose General.
• Click the Advanced tab.
• In the TNS Time Out Value box, type 10.
• Save the listener information, choose File→Save Network Configuration.

Oracle Net Manager saves the listener information and creates the network\admin\listener.ora and network\admin\sqlnet.ora files in the Oracle home directory.

Exit Oracle Net Manager, choose File→Exit.

In a command prompt, create and start the listener service:

cd ORACLE_HOME\bin lsnrctl start LISTENER

Replace ORACLE_HOME with the path to the directory where you installed the Oracle server, for example, d:\app\infodba\product\12.1.0\dbhome_1. This command creates and starts the service if it does not exist. If the service exists, the command starts it.

Do you Know :

⏩For the first listener, Siemens PLM Software recommends accepting the default port number (1521).

⏩Record the number of the port used by the Oracle database server listener for an entry during corporate server installation. Teamcenter Environment Manager requires this port number.

⏩This step sets the Oracle server-side SQLNET.EXPIRE_TIME parameter. This value determines how often the Oracle server checks for aborted client connections. Teamcenter requires that this parameter be set to a nonzero value and the recommended value is 10 (10 minutes).

Read More

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.

Read More

Oracle installation For Teamcenter

Oracle Installation 

Teamcenter requires a supported RDBMS for string a Teamcenter data.

Before installing a Teamcenter we must have to install one of the supported database.

• Oracle
• Microsoft SQL Server

Teamcenter's high resource demands, Siemens PLM Software recommends a dedicated database server.

we should provide a dedicated database instance for Teamcenter.

Oracle installation

1. check Oracle database server must be a version certified for use with Teamcenter.
2. we can check it on GTAC hardware and software certifications.

Preparation and configuration of oracle server 

1. Choose a name for the Teamcenter user account. 
2. Teamcenter uses this account as the owner of all Teamcenter-created tables This account is used by the database administrator to perform tasks required by Teamcenter.
3. If you don't have a certified version of oracle a server installed you can upgrade your version.
4. Teamcenter uses Oracle Net protocols to communicate with an Oracle database.
5. These protocols require that you run a listener process (OracleTNSListener) on the Oracle server to listen for remote connect requests and that all clients can translate the service alias identifying the server and database.

Installation :

1. Log on to the server host as a member of the Administrators group.
2. If you are installing on a primary domain controller (PDC) or a backup domain controller (BDC), log on as a member of the Domain Administrator group.
3. Record the name of the Oracle database server host. Teamcenter Environment Manager (TEM) requires this name during a corporate server installation.
4. launch the setup program.
5. In the Configure Security Updates dialog box, specify whether and how you want to be informed about security updates from Oracle, and then click Next.
6. In the Download Software Updates dialog box, specify whether and how you want to download software updates for Oracle software, and then click Next. 
7. In the Select Installation Options dialog box, select Install database software only and then click Next.
8. In the Grid Installation Options dialog box, select Single instance database installation, and then click Next.
9. In the Select Product Languages dialog box, select the languages you want the Oracle instance to support and then click Next.
10. In the Select Database Edition dialog box, select the database edition to install, and then click Next.
11. In the Specify Oracle Home User dialog box, specify the system account you use to install Oracle. This can be an existing system account or a new system account.
12. In the Specify Installation Location dialog box, specify:
1. Oracle Base: Specifies the path in which to install all Oracle software and configuration files.
2. Software Location: Specifies the path in which to install Oracle software files. This is the Oracle home directory
13. In the Summary dialog box, review the information to ensure you have sufficient disk space, and then click Install.
14. In the Install Product dialog box, monitor the success of the installation stages.
15. When the Finish dialog box displays The installation of Oracle Database was a successful message, Click Close to complete the installation.

Upgrade oracle installation

Do you know

⏩The operating system user account under which you install the Oracle database server

⏩must have system administrator privileges. Siemens recommends you create a system user account named oracle to use during Oracle installation. When you use the oracle account to install Oracle, this account is automatically added to the Windows ORA_DBA local group, giving it SYSDBA privileges.

⏩Do not install a later version of Oracle into an existing Oracle home directory that contains an earlier version.

Read More