Linux Oracle登录问题

一,ORA-12162: TNS:net service name is incorrectly specified

sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jun 11 18:37:26 2018


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


SQL> connect / as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified

设置 环境变量 ORACLE_SID;

二,监听启动但是登不不了数据库

sqlplus /nolog

SQL> connect / as sysdba

SQL> startup

调用脚本dbstart;

同时用root账户把/etc/oratab 内的N 改为 Y;

三,dbvis软件无法登录数据库;

关闭linux服务器防火墙: systemctl stop firewalld.service;