To access the Database Home page: Ensure that the HTTPS port for EM Express is configured. 2. In your Web browser, enter the following URL: https://database-hostname:portnumber/em For example, if you installed the database on a host computer named mydbhost.example.com, and port number 5500 is c...
To configure operating system environment variables for your database instance on Linux and UNIX systems: 1. Open an operating system command window. 2. Ensure that the environment variables ORACLE_HOME and ORACLE_SID are set properly. The ...
To configure operating system environment variables for your database instance on Windows systems: 1. Open an operating system command window. Introduction to Oracle Enterprise Manager Database Express Getting Started with Database Administ...
To connect to an Oracle database from a client computer using easy connect naming: 1. Complete the steps in "Configuring the Operating System Environment Variables" on page 3-2. 2. Do one of the following to start SQL*Plus: ■ (UNIX, Linux, or Windows systems) Open a command window and...
To create a database using DBCA: 1. Start DBCA as described in "Starting DBCA" on page 2-11. 2. In the Database Operation window, select Create Database and click Next to start the guided workflow for creating a database. If you then ...
To create a description index on the SH.PRODUCTS table: 1. View the tables in the SH schema, by following the instructions in "Viewing Tables" on page 8-10. 2. Right-click the PRODUCTS table, and select Index, and then Create Index. The Create Index dialog box
To determine if a datafile can be restored to a specified SCN: RESTORE DATAFILE 1 VALIDATE UNTIL SCN 23456; Starting restore at 29-MAR-12 using channel ORA_DISK_1 channel ORA_DISK_1: starting validation of datafile backup set channel ORA_DISK_1: reading from backup piece /ade/b/191802369/oracl...
To determine if a specified tablespace can be restored: RESTORE TABLESPACE example VALIDATE; Starting restore at 29-MAR-12 using channel ORA_DISK_1 channel ORA_DISK_1: starting validation of datafile backup set channel ORA_DISK_1: reading from backup piece /ade/b/191802369/oracle/work/orcva/RD...
To grant the SYSBACKUP privilege to an existing user: 1. Log into EM Express as user SYS. Be sure to select the as sysdba check box on the Login page. See "Accessing the Database Home Page" on page 3-6. 2. From the Security menu, select Users. 3. On the Users page, click the name of t...
To manually configure the HTTPS port for EM Express: 1. Configure and start the Oracle Net Listener (the listener). You can use lsnrctl to start, stop, and view the status of the listener. 2. If the listener is running on a nonstandard port (for example, not 1521), then the init.ora file for the...
