首页 > 代码库 > sqlplus登录提示:ORA-12162错误
sqlplus登录提示:ORA-12162错误
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ sqlplus ‘/as sysdba‘
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 22 17:10:52 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@localhost ~]$ export ORACLE_SID=PROD //向环境变量中添加实例名,说明需手动设置
[oracle@localhost ~]$ sqlplus ‘/as sysdba‘
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 22 17:11:16 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status,instance_name from v$instance; //登录后查询状态,正常
STATUS INSTANCE_NAME
------------ ----------------
OPEN PROD
[oracle@localhost ~]$ sqlplus ‘/as sysdba‘
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 22 17:10:52 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@localhost ~]$ export ORACLE_SID=PROD //向环境变量中添加实例名,说明需手动设置
[oracle@localhost ~]$ sqlplus ‘/as sysdba‘
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 22 17:11:16 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status,instance_name from v$instance; //登录后查询状态,正常
STATUS INSTANCE_NAME
------------ ----------------
OPEN PROD
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。