Oracle 9.2.0i and sqlb
Brought to you by:
keeleyd
Menu
▾
▴
#10 Oracle 9.2.0i and sqlb
Hi, me again :-)
I'm having problems trying to connect sqlb to an Oracle
9iR2 (9.2.0) database. I've installed everything as
usual, with the latest libsqlora8 2.2.7, the Oracle
client libraries and sqlb recompiled with both.
The tnsnames.ora file has a new syntax, so it was
changed too. When trying to connect to the database
with sqlbplus, it works fine, but when trying to
connect with sqlb, it gives the default eror message :
Error during initialization of database...Exiting
Connection to oracle@XXX failed.
Check your config file or check that the database is
correctly launched.
The main difference in the config with 8i, that could
maybe explain, is that now the SID is very long : ours
is FRAERP.FR4.EGWN.NET, and "sqlplus
user@FRAERP.FR4.EGWN.NET" works whereas "sqlplus
user@FRAERP" doesn't, and that name can't easily be
changed.
FYI, here is the new tnsnames.ora file :
FRAERP.FR4.EGWN.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = FRAERP)
(PRESENTATION = RO)
)
)
As the latest libsqlora8 is said to also work with 9i,
I suspect this to be an issue with sqlb. Let me know if
you have any idea about what the problem may be or if I
can make additional tests to gather more info.
Matthias
Logged In: YES
user_id=226667
Hi!
I check out my code, but I didn't see anything that could be a
problem in relation with your error.
But, the way you explain your problem, I may guess where the
problem comes from. Check out your config file sqlb.conf, you
must have an entry like the following
<oracle@AN_NAME_AS_YOU_WANT>
DB_NAME=FRAERP.FR4.EGWN.NET
DB_LOGIN=YOUR_LOGIN
DB_PWD=YOUR_PASSWORD
</oracle@AN_NAME_AS_YOU_WANT>
And then you connect your program to sqlb with the db_name
"AN_NAME_AS_YOU_WANT" that could have no relation with
your SID !
If you have a config like this, tell me and I will check out much
deeper in the code.
good luck !
GrumZ