Progress
DataServer
for ORACLE Guide
Running ORACLE
An instance must be running for the ORACLE database whose definitions make up the DataServer schema image. Before starting ORACLE, you must set environment variables on your host machine. Follow these steps to run ORACLE:
- Set the ORACLE_HOME variable to the main ORACLE directory.
- Set the ORACLE_SID variable to the ORACLE system identifier.
A process can have the ORACLE_SID set to only one value at a time. If you want to access multiple ORACLE databases on the same machine, set an ORACLE_SID variable to a different value for each database. Then create a separate broker for each database with the ORACLE_SID variable set to the matching value for each database. For more information, see the ORACLE documentation for your machine type.
- Start an ORACLE instance for the target ORACLE database.
To start the ORACLE RDBMS, start the ORACLE SQL*DBA utility by entering sqldba at the system prompt. Then start the ORACLE RDBMS with the CONNECT and STARTUP commands as documented in the ORACLE RDBMS Database Administrator’s Guide or ORACLE7, The Utilities User’s Guide . If you use the graphical interface for the SQL*DBA utility, select Session
Connect and Instance
Start Up from the main menu.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |