Thursday, 26 April 2018

To start Oracle SQL and connect to the database from the Windows Start menu

Requirement: To start Oracle SQL and connect to the database from the Windows Start menu, after installation of Oracle Database 12C.

Solution: For solution of the above requirement follow the steps as shown below:
  • Click Start  > All Programs > Oracle-HOME_NAME, > Application Development > SQL Plus
  • When prompted, enter the user name and password for the account to use to connect to the database. For the user name, you can use the SYS or SYSTEM administrative accounts, and we can use the password that we set up during installation. If we use SYS or / as the user name, follow them with a space and then the clause AS SYSDBA, as shown in the following examples:
                Enter user-name: SYS AS SYSDBA
                Enter password: password
                    or
                Enter user-name: / AS SYSDBA

Hence the solution to our requirement.

If you like the post, please comment, share the post and do like me on Facebook

Thanks & Regards,
Susanto Paul.