ORA-12541/ORA-01034/ORA-27101/ORA-01017

Oracle19c在SQLPLUS中登录数据库遇到ORA-12541/ORA-01034/ORA-27101/ORA-01017相关报错,特此记录具体过程。

[oracle@DATABASE ~]$ sqlplus system/oracle@orcl

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 21 06:46:32 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name: system
Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4376
Additional information: 1851074587
Process ID: 0
Session ID: 0 Serial number: 0


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@DATABASE ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 21 06:47:25 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

SQL> conn / as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn sys/oracle as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1577056040 bytes
Fixed Size		    9135912 bytes
Variable Size		 1056964608 bytes
Database Buffers	  503316480 bytes
Redo Buffers		    7639040 bytes
Database mounted.
Database opened.
SQL> 

原创文章,作者:lzb,如若转载,请注明出处:https://www.wlkjzx.com/2023/07/02/ora-12541-ora-01034-ora-27101-ora-01017/

(0)
打赏 微信扫一扫 微信扫一扫
lzblzb
上一篇 2023年7月2日
下一篇 2024年8月6日

相关推荐

发表回复

登录后才能评论