Oracle 11g R2 Database for OpenSUSE Linux How-to Getting-Started to Install and Manage by SqlPlus Quick Guide

The Step-by-Step Guide to How Install the Oracle 11g R2 Database on Linux OpenSUSE and then Managing the Database Instance by Simples SQLPlus Terminal Commands

The Guide Include All Basic Details, Command and Screenshots of Fundamental Processes.

Relax and Take the Time to Reading, Understanding and Executing Carefully the Instructions Contained here.

1. How-to Install Oracle 11g R2 Database for Linux OpenSUSE:

   Install Oracle 11gR2 Db for OpenSUSE

   Link to Detailed and Step-by-Step Visual Guide on Installing Oracle 11g R2 Database for Linux OpenSUSE.
2. Open a Terminal Window

3. How-to Start and Stop All the Oracle 11g Database Components

   • Start the Oracle Listener, Database and Manager
     1. Login as Oracle User

        su oracle

     2. Start the Listner:

        lsnrctl start

     3. Start the Database process:

        sqlplus '/ as sysdba'

        Insert YourOracleAccountPassword

        >startup

        Wait until the database is Up!

        ORACLE instance started.
        ...
        Database opened.
        

        Exit from sqlplus

        >exit

     4. Start Database Manager Console

        emctl start dbconsole

     5. Access the Oracle Database Manager on Browser

        https://127.0.0.1:1158/em

   • Stop the Oracle Database
     1. Stop the Database process:

        sqlplus '/ as sysdba'

        >shutdown immediate

        >exit

     2. Stop the Listner:

        lsnrctl stop

   If you have Multiple Oracle Databases Before to Start a New one you have to Set the Database SID:

   export ORACLE_SID=<dbSID>

   Oracle 11g Database Troubleshooting Guides

   • Oracle 11g Database Troubleshooting Guides I
   • Oracle 11g Database Troubleshooting Guides II
After you Should Access the "Enterprise Manager" on Browser by the URL shown on the Last Screen. On a Localhost for Example you Should Access the Enterprise Manager by the Address:
https://127.0.0.1:1158/em
And you can Login with: User Name: SYS Password: oracleDatabasePassword From the Drop-down below Select >> Connect as SYSDBA You Should be Able to Access the Database by the Enterprise Manager!