Home » RDBMS Server » Server Administration » connect database from 7i to 9i
connect database from 7i to 9i [message #194332] Thu, 21 September 2006 09:43 Go to next message
Messages: 10
Registered: June 2006
Junior Member

and oracle 9i database NLS_LANG=AMERICAN_AMERICA.UTF8

I was trying to connect from 7i database to 9i I am getting
the below error.

Error accessing package DBMS_APPLICATION_INFO
ORA-06550: line 1, column 40:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

But its connecting to 9i database.

I want to connect 9i database from 7i database and want to insert/update a row in 9i db.

I just want know is there any effect in 9i db if i insert the row.

Please let us know how to ignore the above error messages.

I can't change the character set any of the dbs bconz its prod dbs.

Help me on this issue.

Re: connect database from 7i to 9i [message #194441 is a reply to message #194332] Fri, 22 September 2006 04:37 Go to previous messageGo to next message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I'm not wrong, you'll have to create an intermediate Oracle 8 instance which will be some kind of a gateway; there will be two hops: Oracle 7 -> Oracle 8 -> Oracle 9. I'm quite certain that direct database link between 7 and 9 isn't possible.
Re: connect database from 7i to 9i [message #194444 is a reply to message #194441] Fri, 22 September 2006 04:48 Go to previous message
Messages: 52
Registered: August 2006
Direct connection from 7 to 9 is not possible !.
Previous Topic: sqlplus error
Next Topic: db_domain
Goto Forum:

Current Time: Sun Aug 20 12:26:56 CDT 2017

Total time taken to generate the page: 0.10327 seconds