oracle ORA-12154: TNS:could not resolve the connect identifier specified 错误

发布网友 发布时间：2022-04-11 19:10

我来回答

共5个回答

懂视网 时间：2022-04-11 23:31

INFO: Checking specified location on remote nodes... INFO: size estimation for Completeinstall is 3017.24600315094 SEVERE: [FATAL] [INS-32026] The Software Location specified should not be under Oracle base location. CAUSE: Grid Infrastruct

INFO: Checking specified location on remote nodes...
INFO: size estimation for Completeinstall is 3017.24600315094
SEVERE: [FATAL] [INS-32026] The Software Location specified should not be under Oracle base location.
CAUSE: Grid Infrastructure for a Cluster installation will assign root ownership to all parent directories of clusterware software location. As a result, all named directories in the software location path will acquire root ownership. This may create problems for subsequent installations into the same Oracle base.
ACTION: Specify software location outside of Oracle base.

grid目录结构:

ORACLE_BASE=/u01/app/grid

ORACLE_HOME=/u01/app/grid/11.2.0

查询了半天 才从英文网站获知 ORACLE_HOME不可是ORACLE_BASE的子目 FUCK ORACLE 11G

ORACLE_BASE=/u01/app/grid

ORACLE_HOME=/u01/app/11.2.0/grid

热心网友 时间：2022-04-11 20:39

ora-16020的错误是因为你的归档路径设置少于参数LOG_ARCHIVE_MIN_SUCCEED_DEST的值；
首先，检查该参数的设置。
使用sys用户登录，
$ sqlplus "/ as sysdba"
sql> show parameter LOG_ARCHIVE_MIN_SUCCEED_DEST;
如果该值大于1 ，则需要检查归档目的参数
sql> show parameter log_archive_dest

但，默认的参数设置是1，如果参数LOG_ARCHIVE_MIN_SUCCEED_DEST的值为1，这时情况较为简单。
登录数据库使用archive log list，或者上面的show parameter参数检查归档目的地；并确认归档路径文件夹存在，并且oracle用户对其有write权限即可。
SQL> archive log list;

# chown oracle:dba /dest

热心网友 时间：2022-04-11 21:57

首先确认一下以下问题：
问题：你在服务器上用SQLPLUS登录，是通过主机认证还是通过密码（@xxx）
如果是密码，那应该是程序问题？
如果是主机认证，那这个tnsname.ora的IP是不是能够ping，同时检查主机名。

热心网友 时间：2022-04-11 23:32

在2，tnsnames.ora文件中也把lister加进来,
你要在服务器上用
sqlplus owner/password@服务名 能登录上才可以连接的.
2，tnsnames.ora文件：
# tnsnames.ora Network Configuration File: E:\app\H00726092\proct\11.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prm1)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora11g)
(ORACLE_HOME = /oracle/app/proct/11g/db)
(SID_NAME = ora11g)
)
)
ora11g =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.237.220)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora11g)
)
)

热心网友 时间：2022-04-12 01:23

listener.ora 里的host=prm1 换成地址192.168.237.220 然后重启监听试一试
tnsping 192.168.237.220看看