plsql连接不上本地oracle,plsql不能连接oracle本地数据库报无法识别标识

问题描述:sqlplus /nolog

conn sys/XXX as sysdba;

create user bnx identified by bnx;

grant create session to bnx; grant dba to bnx;

cmd e:/

imp bnx/bnx@orcl file=d:/test.dmp full=y;

导入库后在plsql连接不上库,报标识符无效或连接超时

plsql连接不上,需要检查的有以下几步:

1.oracle服务,监听是否已启动.

2.netmanager中是否有服务命名,我的就没有这个,奇怪,控制台

3.检查是否能连上数据库 cmd-tnsping orcl (127.0.0.1)

出现 "已使用tnsnames适配器来解析别名",说明没有问题

4.用户是否能连上 cmd -sqlplust -bnx(用户名)-bnx(密码)

5.oracle-network-admin-tnsnames.ora中配置的标识不正确,本地就用orcl就可以了(我的机子是这样的),

没必要再去写一样的配置,而标识符不同

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = PC-201101172021)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

bnx=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

这样写会重复,没必要写只要用orcl连接就可以