| odbc [message #56536] |
Mon, 07 April 2003 10:17 |
Vlad
Messages: 9
Registered: April 2003
|
Junior Member |
|
|
i'm trying to link to my Oracle9i server in read-write mode some dBase tables using Generic Connectivity with ODBC.
i've defined an ODBC system datasource "odbcdbf".
conf. files:
--------------------------------------
D:oracleora92hsadmininitdbf.ora
--------------------------------------
HS_FDS_CONNECT_INFO = odbcdbf
HS_FDS_TRACE_LEVEL = ON
--------------------------------
*** even if [[initdbf.ora]] does not exist, the error is the same. is the cause befoire it?
---------------------------------------
D:oracleora92networkadminlistener.ora
---------------------------------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vgurdiga)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = llan.bloc2)
(ORACLE_HOME = D:oracleora92)
(SID_NAME = llan)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:oracleora92)
)
(SID_DESC =
(GLOBAL_DBNAME = dbf)
(PROGRAM = hsodbc)
(SID_NAME = dbf)
(ORACLE_HOME = D:oracleora92)
)
)
TRACE_LEVEL_LISTENER = USER
----------------------------------------------
D:oracleora92networkADMINtnsnames.ora
---------------------------------------------
DBF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vgurdiga)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbf)
(INSTANCE_NAME = dbf)
(GLOBAL_NAME = dbf)
)
(HS = OK)
)
LLANO.BLOC2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = web)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = llano)
)
)
LLAN.BLOC2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vgurdiga)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = llan)
)
)
INST1_HTTP.BLOC2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vgurdiga)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
-------------------------------------------
when i do Test Service in Oracle Net Manager i get:
-----------------------------------------
Attempting to connect using userid: scott
The test did not succeed.
ORA-03113: end-of-file on communication channel
There may be an error in the fields entered,
or the server may not be ready for a connection.
-------------------------------------------
what's wrong in my conf. files???
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
