ORA-03121 After installing Gateway
Hello Experts,
i am trying to connec to MS Sql Server 2000 on remote win2003 machine by using my machine which is WinXP Oracle 10g 10.1.0.2. I installed and configure Gateway as well which is on diffrent home than the oracle in my machine.
when i issue command on SQL Prompt
connect imosadmin/imos@odbc:dsnimos
i got
ORA-03121: no interface driver connected - function not performed
where as dsnimos is a dsn to MS SQL Server2000
and imosadmin/imos is a username and password for the database.
After doing all this my other database services also stop working :(
Please check the configurations which i made as well may be i am wrong somewhere.....
For further info i am pasting my configuration files.
Gateway Home C:\OraHome_1\network\admin\listener.ora
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=zahid)(PORT=1522))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=tg4msql)
(ORACLE_HOME=C:\OraHome_1)
(PROGRAM=tg4msql)
)
)
Rest everything is commented
Oracle Database home C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zahid)(PORT = 1521))
)
)
)
C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
tg4msql=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=TCP) (HOST=zahid) (PORT=1522) )
(CONNECT_DATA=
(SID=tg4msql))
(HS=OK))