时隔很久的问题——SQLPLUS访问不了数据库

bugzbunny

帮你在metalink上面查了一下，好像是TNS

Subject:         ORA-12162 ORA-12154: ERRORS INVOKING SERVER MANAGER AND SQL*PLUS
          Doc ID:         Note:1021367.6         Type:         PROBLEM
          Last Revision Date:         07-FEB-2002         Status:         PUBLISHED



Problem Description:
====================

When invoking svrmgr and sqlplus you receive the following errors:

From SVRMGR:
     
ORA-12162 [TNS-12162]: "TNS:service name is incorrectly specified"            
// *Cause:  The connect descriptor corresponding to the service  
            name in TNSNAMES.ORA is incorrectly specified.
// *Action: Make sure there are no syntax errors in the connect  
            descriptor. Particularly look for unmatched parentheses  
            or stray characters. Any error in a TNSNAMES.ORA file  
            makes it unusable. See Chapter 4 in the SQL*Net V2
            Administrator's Guide.
     

From SQL*PLUS:

ORA-12154 [TNS-12154]: "TNS:could not resolve service name"
// *Cause:  The service name specified is not defined correctly  
            in the TNSNAMES.ORA file.
// *Action:  Make the following checks and correct the error:
             - Verify that a TNSNAMES.ORA file exists and is in  
               the proper place and accessible. See the operating  
               system specific manual for details on the required  
               name and location.
             - Check to see that the service name exists in one of  
               the TNSNAMES.ORA files and add it if necessary.
             - Make sure there are no syntax errors anywhere in the  
               file. Particularly look for unmatched parentheses or  
               stray characters. Any error in a TNSNAMES.ORA file  
               makes it unusable. See Chapter 4 in the SQL*Net V2  
               Administrator's Guide. If possible, regenerate the  
               configuration files using the Oracle Network Manager.

juan025

汗~~~~~~~~~``
先回去把ENGLISH学好再来提问

juan025

最初由 bugzbunny 发布
[B]帮你在metalink上面查了一下，好像是TNS

Subject:         ORA-12162 ORA-12154: ERRORS INVOKING SERVER MANAGER AND SQL*PLUS
          Doc ID:         Note:1021367.6         Type:         PROBLEM
          Last Revision Date:         07-FEB-2002         Status:         PUBLISHED



Problem Description:
====================

When invoking svrmgr and sqlplus you receive the following errors:

From SVRMGR:
     
ORA-12162 [TNS-12162]: "TNS:service name is incorrectly specified"            
// *Cause:  The connect descriptor corresponding to the service  
            name in TNSNAMES.ORA is incorrectly specified.
// *Action: Make sure there are no syntax errors in the connect  
            descriptor. Particularly look for unmatched parentheses  
            or stray characters. Any error in a TNSNAMES.ORA file  
            makes it unusable. See Chapter 4 in the SQL*Net V2
            Administrator's Guide.
     

From SQL*PLUS:

ORA-12154 [TNS-12154]: "TNS:could not resolve service name"
// *Cause:  The service name specified is not defined correctly  
            in the TNSNAMES.ORA file.
// *Action:  Make the following checks and correct the error:
             - Verify that a TNSNAMES.ORA file exists and is in  
               the proper place and accessible. See the operating  
               system specific manual for details on the required  
               name and location.
             - Check to see that the service name exists in one of  
               the TNSNAMES.ORA files and add it if necessary.
             - Make sure there are no syntax errors anywhere in the  
               file. Particularly look for unmatched parentheses or  
               stray characters. Any error in a TNSNAMES.ORA file  
               makes it unusable. See Chapter 4 in the SQL*Net V2  
               Administrator's Guide. If possible, regenerate the  
               configuration files using the Oracle Network Manager. [/B]

仔细看了下，发现也不是特别的恐怖（唉，谁叫我只有高中文化呢）

我的错误号是：TNS-12162
首先：语法应该是没有问题的，都是按照各位说的做的，另外今天去书店买回来了一本10G的书，照着上面的写也是同样的错误，也不会存在括号不匹配之类的问题
其次：不是很清楚TNSNAMES.ORA 位于什么目录下面
其三：不知道怎么SEE Chapter 4 in the SQL*Net V2
            Administrator's Guide.

bugzbunny

TNSNames.ora 在这里$ORACLE_HOME/network/admin

看看TNSNAMES.ORA里面是否有语法错误/括号不匹配的问题...

juan025

[root@localhost admin]# cat sqlnet.ora
# sqlnet.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

这有错误吗？

bugzbunny

最初由 juan025 发布
[B][root@localhost admin]# cat sqlnet.ora
# sqlnet.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

这有错误吗？ [/B]

这个SQLNET.ORA没错，TNSNAMES.ORA呢？

juan025

# tnsnames.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

MYFIRST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MyFirst)
     )
  )

MYFIRSTD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MyFirstDB)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      )
   )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
     )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
     )
   )


其中MyFirstDB和MyFirst是我通过DBCA创建的数据库——事实上，并没有成功，以失败告终，提示是：用户名无效，连接失败


我想我还是重新安装算了
连REDHAT一起

juan025

# tnsnames.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

MYFIRST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MyFirst)
     )
  )

MYFIRSTD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MyFirstDB)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      )
   )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
     )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
     )
   )

juan025

# tnsnames.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

bugzbunny

ORACLE_SID设置了吗？
$export ORACLE_SID = orcl
$sqlplus / as sysdba