When accessing Oracle with SYSDBA, the following information is prompted:
[oracle@localhost ~]$ sqlplus/as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 2 20:21:40 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
solve:
First, make sure to start listening:
[oracle@localhost ~]$ lsnrctl start
Then start instance:
SQL> startup;
This is the open status when you view the database instance again:
SQL> select status from v$instance;
STATUS
------------------------
OPEN
Read More:
- C# Member XXX cannot be accessed with an instance with an instance reference;qualify it with a type
- Failed to create Oracle Oracle home user solution appears in oracle12c installation
- Dca1000 reports an error and the SPI port cannot be connected
- How to Fix distributed training report terminate called after throwing an instance of’std::length_error’
- Oracle reports an error and lsnrctl listening cannot be started
- Idle line number setting and linenumbers modification
- After adb is connected to an android phone, remount failed: operation not permitted when adb remount is a roundabout solution
- An error was reported when springboot connected to redis Servlet.service () for servlet [dispatcherServlet] in context with path [] threw e
- The connection pool of SSM project database cannot be connected. The project can run normally and the database cannot be connected
- Oracle database file is damaged, Error:ORA-01033 :ORACLE initialization or shutdown in progress
- Implementation of screen cleaning in Python idle
- Putty encountered an error when logging into alicloud CentOS: dis connected:No supported authentication methods available
- How to Fix Error accessing PRODUCT_USER_PROFILE
- Python idle add configuration shortcut (Ctrl + L)
- Oracle12c client32 bit installation error: [ins-20802] Oracle net configuration assistant failed
- How to Fix “Oracle sp2-0640 unable to connect” Error
- Mybatis integrates Oracle query and reports an error in the datetime type field
- An error is reported when kettle connects Oracle database and MySQL database
- C++: terminate called after throwing an instance of ‘std::length_error‘ (sort function cmp sorting rules problem)
- Solution to redis error in CentOS of idea connected virtual machine