我的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))
)
$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。