Attempting to create 2nd instance and links for Ingres to Oracle conversion
I have an oracle instance called ORCL that was set up with a DB link to the Ingres Database and it works. I want to create
a second instance using the same binaries so that I don't clobber a developer. Using DBCA I created CONVERT.
Here's were my memory is faulty as to how the first instance was set up. I create a db link, and also entries in the
ORACLE_HOME\hs directory for the init.ora I have one listener running at it lists both instances in the sid_list ...
then when I try to query the ingres database I get
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.
ORA -02063: preceeding 2 lines from SDFA_INGRES
My oracle Database is on Windows. This is Oracle 11
ORACLE_HOME is F:\apps\oracle\product\11.1.0\db_1\ for both ORCL and CONVERT
db_2 is set up for the 2nd instance for only the redo logs and control files...
db_1\hs has two init files ... one for ORCL and CONVERT
initsdfa_odbc.ora
# HS init parameters
HS_FSD_CONNECT_INFO = sdfa_odbc
HS_FDS_TRACE_LEVEL= off
TNSNAMES.ORA
SDFA_ODBC = <<< this is my 2nd entry ... the other is just the same different name.... >>>>>>
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp) (HOST = localhost) (PORT = 1521))
(CONNECT_DATA =
(SID = sdfa_odbc)
)
(HS = OK)
)
LISTENER.ORA
Under SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=sdfa_odbc)
(ORACLE_HOME=F:\apps\oracle\product\11.1.0\db_1) <<< binaries for both ... I have a db_2 for file locations
(program=dg4odbc)
)
My link is public
Create public database link "SDFA_INGRES" connect to "DBA" identified by "*****"
using "SDFA_ODBC";
My select is from the CONVERT instance as SYS ...
select count(*) from test_table@SDFA_INGRES;
and then I get the above error.
What am I missing or have wrong ? Can I have 2 HS services defined in one listener or do a need seperate listeners ?
Appreciate all assistance. Excuse my typing errors ... I am on a another system and can't cut and paste. So I might have
some typos ... thank you.