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) ) ) 数据库启动不了,急!急! 【笨鸟请教】PowerDisgner中可以为CDM概念模型设置主键信息吗? 协议适配器错误~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ oracle建表的问题。 存储过程如何执行select动态表名得到变量,请指教 如何从数据库文件恢复数据库 ORACLE用户登陆和权限的简单问题,大家帮我看下吧,谢谢 oracle的一个查询问题,急盼。 送分,这样两个问题的语句在ORACLE里面怎么写 表的索引问题? 谁知道哪有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)
)
)