Politechnika Śląska - strona 119

To access the Database Home page

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 434

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 connect to an Oracle database from a client computer using easy con...

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 413

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

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 413

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

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 532

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

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 294

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

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 350

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

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 343

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

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 462

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...