oracle技能培训课件.ppt

* Creating an Additional Listener By default a listener called LISTENER is created after the installation. If you need to create an additional listener, the following steps describe the procedure: 1. Start up Oracle Net Manager 2. Click the Listeners icon. 3. Select Create from the Edit menu. 4. Enter a listener name in the Listener Name field on the dialog box that appears. 5. Select Listening Locations from the drop-down list within Oracle Net Manager for your listener. 6. Click the Add Address button. 7. Change or enter information in the Protocol, the Host, and Port fields as necessary. 8. Select Save Network Configuration from the File menu of Oracle Met Manager. Opening the Database (OPEN) Normal database operation means that an instance is started and the database is mounted and open. With normal database operation, any valid user can connect to the database and perform typical data access operations. Opening the database includes the following tasks: Opening the online data files Opening the online redo log files If any of the data files or online redo log files are not present when you attempt to open the database, the Oracle server returns an error. During this final stage, the Oracle server verifies that all the data files and online redo log files can be opened and checks the consistency of the database. If necessary, the SMON background process initiates instance recovery. STARTUP Command To start up an instance, use the following command: STARTUP [FORCE] [RESTRICT] [PFILE=filename] [OPEN [RECOVER][database] |MOUNT |NOMOUNT] Note: This is not the complete syntax. where: OPEN: Enables users to access the database MOUNT: Mounts the database for certain DBA activities but does not provide user access to the database NOMOUNT: Creates the SGA and starts up the background processes but does not provide access to the database PFILE=parfile: Enables a nondefault initialization parameter file to be used to configure the instance FORCE: Aborts the runn