creating a connection to Oracle 7.3 from Oracle 9i

Dear Oracle Community,

i am a newbie to oracle (being reasonably fluent with mssql server 2000) and have been asked to evaluate 9i with a view to migrating a current oracle 7.3 database (on sun solaris) to oracle 9i on win 2000.

my questions are these:

• i was asked to change the passwords for sys and system as part of the installation - now it won't let me log into the enterprise manager using these (nor sysdba, sysoper, sysman) but.... it would let me log into sql worksheet as sys/sysdba using the passwords i supplied during install - any advice on this one?
• how do i create a connection from 9i to the oracle 7.3 database?

i have looked all over the oracle 9i enterprise manager (i am logged in as scott to whom i assigned dba privledges in sql worksheet) but..... the net wizard does not seem to make any sense - is this the same as SQL* Net? also, in the Help on modifying tnsnames.ora, i had to use configurations/add new service - but this option is not available to me on the menu bar.

what steps should i take to make a successful connection? (i would appreciate being taken by the hand on this one)

• is it possible to connect from OEM 9i (or sql worksheet) to Oracle 7.3 using ODBC?
• if our oracle 9i trials are successful we may migrate our mssql database to oracle - is it possible to connect from the enterprise manager to mssql?

ideally, i would like the oracle 7.3 database (and if poss, the mssql server tables) and all their dbs and tables visible through the oracle 9i enterprise manager.

• finally, i would like to import all the tables, data, stored procs/packages and roles from oracle 7.3 to oracle 9i - where to start? what ought i do?

i am very new to oracle, so please forgive my ignorance. any and all help will be greatly appreciated.

regards

Edwina Received on Fri Oct 18 2002 - 05:11:58 CDT