Introduction to Oracle services for Windows systems

There are two types of services associated with running an Oracle database: Oracle listener and database instance. Both types must be running on the system when running Teamcenter. Process Description Oracle listener The Oracle listener (OracleTNSListener) service monitors database connections from remote clients. This is a SQLNet V2/Net process and is required for Teamcenter to connect. Under SQLNet V2/Net, several listeners may run on the same system, each listening for connect requests to particular databases. Each listener must be configured to listen on a different port. Even if Teamcenter is run on the Oracle server, it is necessary to start this service because all Teamcenter database requests use the remote connect mechanism. Database instance There is one Oracle database service for an Oracle database instance. It must be running for Teamcenter to function properly. The service is: OracleServiceSID SID represents the database instance system identifier. Starting the instance of an Oracle database is referred to as initializing a database instance. To initialize a database instance, use the Oracle SQLPlus utility to manually start one database instance defined by the ORACLE_SID environment variable. Caution Never shut down a database instance by killing database processes from the Windows Task Manager. Oracle databases require orderly shutdowns to ensure that all necessary database transactions are completed. Failure to observe this may result in the corruption of the database. Manual termination of processes also prevents the Oracle Relational Database Management System (RDBMS) from releasing memory that is no longer needed, and could require additional database recovery procedures at the next database startup. Use the Oracle SQLPlus utility to stop a single database instance defined by the ORACLE_SID environment variable.