Welcome Guest.


How to start the ORACLE database instance

Asked by: Gary Hill 222 views IT November 18, 2018

Are, great god

1 Answers

  1. +8Votes  

    Check if the database is started, you can use ipcs to view under linux, you can view the service under windows, you can also enter the database to see the current state of the database select status from v$instance; if status = open, the oracle service is normal.
    View the listener, execute lsnrctl status, you can see the corresponding instance of the listener.
    If there is a scott user, you can check the user status of the dba_users table.
    After the service starts, use shutdown immediate to shut down the service

    Steven Taylor- November 18, 2018 |