oracle访问问题 我在本机装了个oracle,安装ok也启动的例程,但是配置了本地服务名后用老是访问不了sqlplus sys/password as sysdba 这样可以sqlplus sys/password@test as sysdba 这样就不可以了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我用tnsping test 是没有问题的 1. 这里如果提示是ORA-01031: 权限不足检查密码文件是否存在。可以用 / as sysdba. 登录以后执行SQL> select * from v$pwfile_users; 如果有记录就是密码文件正确。如果没有记录的话,表示密码文件已经坏掉或者缺失参考这个帖子“解决10g上 非本机SQLPLUS conn as sysdba出现ORA-01031: insufficient privileges问题”2. 如果是密码名错误检查remote_login_passwordfile选项 应该是EXCLUSIVE或者是SHARE详细可以参考“ORA-01017:用户名密码出错 故障实例” \db_1\NETWORK\ADMIN\tnsnames.ora文件的配置有问题 这里如果是tnsping test没有问题的话,基本上就不是tnsname.ora的问题了。总结了一个贴“解决sysdba不能远程登录的问题”csdn上的 “sysdba不能远程登录,我们该怎么做” 把test用户删掉,重新配置看我的文件# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORADB7 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.10.7)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = tpms) ) )TPMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.10.49)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = tpms) ) )VPN = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yzk)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = vpn) ) )ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.10.82)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yzk)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService) ) )JJXT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.10.50)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = jjxt) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 地址的模糊查询 索引的起用 一个简单的关于锁的问题 pl/sql执行存储存储过程无法正常退出,请指教 oracle等待锁,在线等!!急~~ 这个存储过程怎么建立阿??? 一个奇怪的问题。。。 服务应用程序 ORACLE'S RMAN 备份问题! ORA-03113: 通信通道的文件结束 谁知道哪有oracle10在XP上的安装手册没? 如何过滤父类信息
检查密码文件是否存在。可以用 / as sysdba. 登录以后执行
SQL> select * from v$pwfile_users; 如果有记录就是密码文件正确。
如果没有记录的话,表示密码文件已经坏掉或者缺失
参考这个帖子“解决10g上 非本机SQLPLUS conn as sysdba出现ORA-01031: insufficient privileges问题”2.
如果是密码名错误
检查remote_login_passwordfile选项 应该是EXCLUSIVE或者是SHARE
详细可以参考“ORA-01017:用户名密码出错 故障实例”
这里如果是tnsping test没有问题的话,基本上就不是tnsname.ora的问题了。总结了一个贴
“解决sysdba不能远程登录的问题”csdn上的 “sysdba不能远程登录,我们该怎么做”
# Generated by Oracle configuration tools.ORADB7 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.10.7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tpms)
)
)TPMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.10.49)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tpms)
)
)VPN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yzk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = vpn)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.10.82)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yzk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)JJXT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.10.50)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jjxt)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)