LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.66.49)(PORT = 1521)) ) )
SID_LIST_LISTE
(SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) ) |
以前的 tnsnames.ora
US7 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.66.49)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = us7) ) ) |
这样一回到家后,起lsnrctl, 起数据库,sqlplus sytem/manager@us7肯定不行的。
报错,ora-12514。
如是,把这两个文件中的host改为localhost.还是不行,启动后,sqlplus去连接报错: ora-12541, no listener.
然后同时换成127.0.0.1也是不行的。
然后把host改名为当前的hostname (etdliu为我当前的hostname),这样就可以了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22161612/viewspace-664405/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22161612/viewspace-664405/