这里是tnsnames.ora 文件里的内容,那位高手指点下哦
超级用户: 用户名system/密码manager
用户名sys/密码change_on_install
普通的用户: 用户名scott/密码tiger
都试过了,没一个可以成功
都是提示:
ERROR:
ORA-12560:TNS:protocol adapter error
tnsnames.ora文件里的内容:
# tnsnames.ora Network Configuration File: F:\oracle\product\10.1.0\Db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
HXH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 4b4e7147dd70493)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HXH)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 4b4e7147dd70493)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Oracle里sql*plus的用户名即system用户,密码是自己设置的密码。如果密码忘记,可通过如下方法重置。
1、cmd中输入sqlplus /nolog
2、继续输入conn /as sysdba
3、输入 alter user 用户名 identified by 密码;
4、修改成功后,会有上图“用户已更改”的提示,再次登录时用自己设定的密码即可。