[Oracle]IMP-00058&ORA-12541 error.

After create a new database ... I met an error when I tried to import data into the new database.



------------------------------------------

OS: Windows 2003 Enterprise Edition

CPU:2.80GHz

RAM:3.75GB

------------------------------------------



The error code as following:



imp bbvsvc/bbvsvc@testw
Import: Release 9.2.0.3.0 - Production on 星期三 2月 4 16:23:31 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
IMP-00058: ORACLE 錯誤 12541

發生ORA-12541: TNS:沒有監聽器

IMP-00000: 匯入作業異常終止



I checked the tnsname.ora and listener.ora, them seems okay...

So, I don't know why it happened...







following shows the part of tnsnames.ora contents:



testw =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.32)(PORT = 1521))

)

(CONNECT_DATA = (SERVICE_NAME = testw)

)

)



and here is the part of Listener.ora contents:



LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))

)

(DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

)



SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = O:\oracle\ora92)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = TSCSVCT)

(ORACLE_HOME = O:\oracle\ora92)

(SID_NAME = TSCSVCT)

)

)

Already dealed with...

There are a client and a server on the machine. So ...

The TNS_ADMIN is not O:\oracle\ora92client\network\admin, the correct path is "O:\oracle\ora92\network\admin\".

And the connection information is no correctly, especially "Port" number on the tnsnames.ora.

Changed the Port number from "1526" to "1521", then the Export data process can run smoothly.