• 未export ORACLE_SID导致ORA-12162


    新安装的数据库,本地验证登陆报错如下:

    [oracle@rac1 ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Nov 28 01:35:43 2013

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

    ERROR:
    ORA-12162: TNS:net service name is incorrectly specified

    原因为没有export ORACLE_SID

    export  ORACLE_SID 并写入.bash_profile即可登陆了。

    [oracle@rac1 ~]$ export ORACLE_SID=snaid

    [oracle@rac1 ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Nov 28 02:06:27 2013

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


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    and Real Application Testing options

  • 相关阅读:
    Web的攻击技术
    基于HTTP的功能追加协议
    确认访问用户身份的认证
    基本数据结构的模拟
    BFS与DFS
    KMP算法
    Trie字典树
    C++的结构体使用
    C++入门(命名空间)
    算法:C++入门
  • 原文地址:https://www.cnblogs.com/snaid/p/3447256.html
Copyright © 2020-2023  润新知