edwinah_at_customercare.com.au (Edwinah63) wrote in message news:<d714e824.0210180211.5919dac6_at_posting.google.com>...
> 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
Oracle Migration Workbench is a good tool to migrate from sql server to Oracle.
Make sure in NT all your Oracle services are started.
Michael Tubuo Ngong
Received on Fri Oct 18 2002 - 09:45:34 CDT
