When accessing Oracle with SYSDBA, the following information is prompted:
[[email protected] ~]$ 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:
[[email protected] ~]$ 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:
- Tns-03505: the ultimate solution to failed to resolve name
- Oracle 12C installation process related errors and Solutions
- How to Fix “Oracle sp2-0640 unable to connect” Error
- Oracle stops a job
- Oci-22053: overflow error problem
- Solution to Oracle error 17002
- Oracle error collection solution
- Oracle11gr2 database suddenly “TNS no listener” protocol adapter error
- Oracle reports an error and lsnrctl listening cannot be started
- Oracle database error: fatal Ni connect error 12170
- Oracle can’t start the database due to deleting DBF file by mistake
- Deployment project error: Oracle 11g ora-12505, TNS:listener does not currently know of SID given in connect descriptor
- Creation and use of Oracle sequence
- Solution: ora-00205: error in identifying control file, check alert log for more info
- Insufficient table space ORA-00604 unable to extend table SYS.AUD by 8192
- SQL Server import MDF and LDF files appear: unable to open physical file “D:\ XX.mdf “。 Operating system error 5: “5 (access denied. )”Solutions
- How can Oracle query tables of other users without adding a table user name
- [Oracle] when inserting data, “ora-00001: unique constraint” appears
- Call to undefined function oci_ Connect() problem solving
- Solve the error of dual system installation: the grub-efi-amd64-signed package failed to install into /target/.