OraFAQ Forum: Server Administration » connect database from 7i to 9i

Home » RDBMS Server » Server Administration » connect database from 7i to 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connect database from 7i to 9i [message #194332]

Thu, 21 September 2006 09:43

703009827
Messages: 10
Registered: June 2006

Junior Member

Hi,

My Oracle 7i database NLS_LANG=AMERICAN_AMERICA.US7ASCII
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
ERROR:
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.

Thanks,
Siva

Report message to a moderator

Re: connect database from 7i to 9i [message #194441 is a reply to message #194332]

Fri, 22 September 2006 04:37

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: connect database from 7i to 9i [message #194444 is a reply to message #194441]

Fri, 22 September 2006 04:48

aorehek
Messages: 52
Registered: August 2006

Member

Direct connection from 7 to 9 is not possible !.

Report message to a moderator

Previous Topic:	Where i have see the Errors
Next Topic:	Renaming the Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:54:07 CDT 2024