Oracle Data Migration Assistant

When migrating an Oracle database to Oracle9i, the Database Password and INIT.ORA File window of Oracle Data Migration Assistant prompts you for the SYS password. You must enter a password that is valid for the following connection:

SYS/password AS SYSDBA

where password is your pre-Oracle9i INTERNAL user account password (oracle by default, unless you changed it). 

 

Before you migrate an Oracle database with Oracle Data Migration Assistant, ensure the init.ora file does not contain any initialization parameter with a value defined using environment variables. For example:

background_dump_dest=%ORACLE_HOME%\trace

Substitute the environment variable value before starting the migration process. For example:

background_dump_dest=c:\oracle\orahome8\rdbms\trace

 

Ignore Error ORA-00604: During Upgrade

Ignore the following error when upgrading from Release 8.0.x to 9.0.1. Despite the error message, the upgrade has completed successfully. Note that the error does not occur during upgrade from 8.1.x to 9.0.1.

ORA-00604: error occurred at recursive SQL level 1

 

Oracle9i Network Issues

Listener does not support the IPC Protocol in this release. In order for the listener to work correctly, the IPC protocol information must be removed manually from the listener.ora file in ORACLE_HOME/network/admin folder. Please remove the IPC related lines or comment them out as shown below:

## Sample Listener.ora showing the IPC connect string commented out (in BOLD letters)

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

#      (ADDRESS_LIST =

#        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

#      )

      (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = your_computer_name)(PORT = 1521)

      )

    )

  )

 

If you have migrated listener.ora from a prior release as part of doing a database migration, please remember to modify the migrated listener.ora as specified above.

Please note that the listener may fail to start up properly if the IPC related lines are present in listener.ora.

 

SQL*Plus

SQL*Plus does not run and you cannot install the database successfully without the DLLs wininet.dll and shlwapi.dll.

If these DLLs are not present on the computer, you can get them from another computer, the MSDN Web site, or the Windows NT 4.0 installation CD-ROM. Copy the DLLs to C:\WINNT\system32\ before installing Oracle9i.

 

Developer & Oracle Personal Edition on Windows (standalone)

The following will need to be done to establish a connection from Developer to Oracle Personal Edition.

• 1. Install Oracle. Default Oracle_Home is as follows: (oracle/oraxx - xx is version number for example Oracle 8i xx=81 or 82 and for Oracle 9i xx=90, 91 or 92) If you do not have a Domain name or are unsure of - use default selections (REMEMBER: your SID for step 3) 

• 2.Install Developer into a seperate Oracle_Home from the Oracle database. Default Oracle_Home: ORAWIN95.  Change the Developer Home name to: (oradevxx - xx is version number) and the Developer Home location to: (oracle/devxx - xx is version number)  

• 3.Create a Net8 service name using the Net8 Easy config utility (start -> programs -> Oracle ->network administration -> net8 easy config)  

•     Enter the following information:

• Select "create"

• Name the service name - any name can be used. (this name must be the same as SID name on the step 1.

• Select TCP/IP as the protocol adapter

• Enter your PC name as your host (as found in your TCP/IP

• properties of the control panel or 127.0.0.1)

• Select the second radio button to change your database instance to equal the SID created during your installation or leave the default as ORCL.

• Bypass the test and remaining screens by clicking next.

• 4.Go to the following location (using Windows Explorer): (oracle/oraxx/network/admin/)  (where Oracle/Oraxx is the location of your Oracle_Home) then copy the tnsnames.ora file to the following location:  (oracle/oradevxx/net80/admin) (where oracle/oradevxx is the location of your Developer Oracle_Home)

• 5.Rename the sqlnet.ora file to sqlnet.old.  These files can be found in the following locations:  

     a.oracle/oraxx/network/admin/

     b.oracle/oradevxx/net80/admin

Some installations will not create the above files in both locations, rename only the files that are found. Now reboot.

• 6.Start your listener:

At the DOS prompt type: LSNRCTL START

NOTE: if you have an internet connection that uses TCP/IP as a protocol you may recieve a dial-up connection box when starting the listener.  Press cancel to bypass this connection.

• 7.Start your database:  (Start -> Oracle - OraHomexx -> Database Administration -> Start

     Login to any developer’s tools and make a connection using:

     username: scott

     password: tiger

     database: <enter the service name created in step #3>

 What is the Username/Password Needed for Login

The Oracle8i starter database comes with some default user names and user passwords, which are shown in the following table.  Use these default values until you establish your own user name and user password. 

         User Name/Password

Scott/tiger

System/manager

Sys/change_on_install

Internal/oracle

Demo/demo

To connect to your local database from SQL*Plus, you may be asked for the host string, database, connect descriptor, or some similar label, depending on the application. You can leave this field blank.  If you are trying to connect from an Oracle tool (Developer, Discoverer, Designer, etc) then you will need to create a connect descriptor using the Net8 configuration tool.