我的tnsnames.ora是:####################################
# TNSNAMES.ORA Configuration File:D:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Thu Aug 03 15:14:18 CST 2006
####################################XIANGSU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Xiangsu)(PORT = 1521))
)
(CONNECT_DATA = (SID = Xiangsu)(SERVER = DEDICATED))
)# TNSNAMES.ORA Network Configuration File: D:\oracle\ora90\network\admin\tnsnames.oraINST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Xiangsu)(PORT = 1521))
)
(CONNECT_DATA = (SERVER = SHARED)(SERVICE_NAME = MODOSE)(PRESENTATION = http://HRService))
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))
)TOHEN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.123.56)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = tohen))
)
# TNSNAMES.ORA Configuration File:D:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Thu Aug 03 15:14:18 CST 2006
####################################XIANGSU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Xiangsu)(PORT = 1521))
)
(CONNECT_DATA = (SID = Xiangsu)(SERVER = DEDICATED))
)# TNSNAMES.ORA Network Configuration File: D:\oracle\ora90\network\admin\tnsnames.oraINST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Xiangsu)(PORT = 1521))
)
(CONNECT_DATA = (SERVER = SHARED)(SERVICE_NAME = MODOSE)(PRESENTATION = http://HRService))
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))
)TOHEN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.123.56)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = tohen))
)
解决方案 »
- Oracle启动失败 help!!
- orcale 439报错
- oracle11G 有对应的客户端吗?有的话给出下载网址!
- 把次序不对的列找出来
- 请问用oracle做后台,JSP为前台的WEB项目需要用连接池技术吗?
- 如何往嵌套表里插入一条数据啊
- 100分求教:%TYPE,%ROWTYPE详解
- 我用dblink把远程数据库的表复制到本地数据库,表的纪录有2000多万条,我直接在本地CREATE TABLE 总报TEMP表空间无法扩展,如何解决
- 请问oracle有没有类似charindex的函数,获取某个子串在一个字符串里的位置?
- 这样的语句如何写?
- 求助:导入导出数据库疑惑
- preparedStatement 至急 在线等!!!!!!!!!!!
$sql>connect /as sysdba
$sql>alter user sys identified by sys; --改密码为SYS
$sql>alter user system identified by manager;
用sysman /oem_temp登录,
还是跳出“ORA-01017:invalid username/password;logon denied”
$sqlplus /nolog
$sql>connect /as sysdba
$sql>alter user sys identified by sys; --改密码为SYS
$sql>alter user system identified by manager;
***************************************没有用户和密码,我怎么进sqlplus啊???
确认你已经运行了。 如果运行了则一定可以的。(我估计是没有)。sysman是repository 库(配置oem是后产生)中一个表格的一条记录。
如果repository 库的owner是oemrep(假设是这个),那么用它登陆,并执行一下语句即可恢复密码为oem_temp。update SMP_VDU_PRINCIPALS_TABLE set password = '9ed0fa64a76b4bd912310580f74926ca'
where principal_name = UPPER('SYSMAN').再看不懂就没有办法了。
已连接。
SQL> show user;
USER 为"SYS"
SQL> alter user sys identified by sys;
...
$sql>connect /as sysdba
$sql>alter user sys identified by sys; --改密码为SYS
$sql>alter user system identified by manager;
密码:manager或change_on_install
你试试看看如何!!!
請問zmzbs123(小阵阵)
這樣可以修該密碼,那安全不是很差嗎?
dba不要密码的么
orapwd file=文件路径 password=newpassword
这里的password就是内部口令。可以随便用。
如果是操作系统认证..你可以不用密码直接as sysdba.然后再修改密码.
如果是口令文件.就建议口令文件,然后OK
密码:manager或change_on_install
你试试看看如何!!!要加一点:用户必须是dba。