Versions Compared

Version Old Version 2 New Version 3
Changes made by

Ravikumar Babu CTOO (Unlicensed)

Ravikumar Babu CTOO (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleHow to connect to Oracle database through command prompt?
  1. At command prompt, type sqlplus and press ENTER.
  2. Enter the DBA User ID and press ENTER.
  3. Enter the DBA User Password and press ENTER.

    Connecting to Oracle Database

    If the credentials are correct the connection to Oracle database will be successful.


Expand
titleHow to find out the Oracle System ID (SID)?

  1. After successfully connecting to the Oracle database at the command prompt as suggested in previous question, enter the following command:

    Code Block
    languagebash
    show parameter service_name


  2. In the result, the VALUE column displays the Oracle SID.

    Finding Oracle SIDImage Added