Using OUI to install Oracle9 i Release 2 on an OpenVMS System

1. Using OUI to install Oracle9i Release 2 on an OpenVMS System

2. Specifications (1 of 3) • PC running Xcursion and a 16 Processor GS1280 with the 2 built-in disks • In the examples we booted on disk DKA0: • Oracle account is on disk DKA100. Oracle and the database will be installed on DKA100. • Install disk MUST be ODS-5. • Installation uses the 9.2 downloaded from the Oracle website. It comes in a Java JAR file. • Oracle ships a JRE with its product. However, you will have to install Java on OpenVMS so you can unpack the 9.2 JAR file that comes from the Oracle website • Unpack the JAR file as described on the Oracle website. This will create two .BCK files.

3. Specifications (2 of 3) • Follow the instructions in the VMS_9202_README.txt file on how to restore the 2 backup save sets. • When the two backup save sets files are restored, you should end up with two directories: • [disk1] directory • [disk2] directory • These directories will be in the root of a disk. In this example they are in the root of DKA100. • The OUI requires X-Windows. If the Alpha system you are using does not have a graphic head, use a PC with an X-Windows terminal such as Xcursion.

4. Specifications (3 of 3) • During this install we discovered a problem: • Instructions tell you to run @DKA100:[disk1]runinstaller. • This will not work because the RUNINSTALLER.COM file is not in the root of DKA100:[disk1]. • You must first copy RUNINSTALLER.COM from the dka100:[disk1.000000] directory into dka100:[disk1]: $ Copy dka100:[disk1.000000]runinstaller.com dka100:[disk1] • From a terminal window execute: @DKA100:[disk1]runinstaller

5. Oracle Installer starts

6. Start the installation • Click Next to start the installation.

7. Assign name and directory structure • Assign a name for your Oracle home. • Assign the directory structure for the home: Ora_home Dka100:[oracle.oracle9] • This is where the OUI will install Oracle. • The OUI will create the directories as necessary.

8. Select product to install • Select Database. • Click Next.

9. Select type of installation • Select Enterprise Edition. • Click Next.

10. Enable RAC • Select No. • Click Next.

11. Database summary • View list of products that will be installed. • Click Install.

12. Installation begins • Installation takes from 45 minutes to an hour.

13. Installation ends • Installation ends. • Click Exit.

14. Oracle installed • Oracle is now installed in DKA100:[oracle.oracle9]. • To create the first database, you must first set up Oracle logicals. • To do this use a terminal and execute @[.oracle9]orauser . • The tool to create and manage databases is DBCA. • On the terminal, type DBCA to launch the Database Assistant.

15. Welcome to Database Configuration Assistant • DBCA starts. • Click Next.

16. Select an operation • Select Create a Database. • Click Next.

17. Select a template • Select New Database. • Click Next.

18. Enter database name and SID • Enter the name of the database and Oracle System Identifier (SID): • In this example, the database name is DB9I. • The SID is DB9I1. • Click Next.

19. Select database features • Select which demo databases are installed. • In the example, we selected all possible databases. • Click Next.

20. Select default node • Select the node in which you want your database to operate by default. • In the example, we selected Shared Server Mode. • Click Next.

21. Select memory • In the example, we selected the default. • Click Next.

22. Specify database storage parameters • Select the device and directory. • Use the UNIX device syntax I.E. • For example, DKA100:[oracle.oracle9.database] would be: /DKA100/oracle/oracle9/database/ • In the example, we kept the default settings. • Click Next.

23. Select database creation options • Creating a template saves time when creating a database. • Click Finish.

24. Create a template • Click OK.

25. Creating and starting Oracle Instance • The database builds. • If it completes successfully, click Exit. • If it does not complete successfully, build it again.

26. Running the database • Enter “show system” to see the Oracle database up and running. • Set up some files to start and stop the database.

27. Example of a start file • This command sets the logicals to manage the database: $ @dka100:[oracle.oracle9]orauser db9i1 • The next line starts the Listener (needed for client connects). • The final lines start the database.

28. Stop database example • Example of how to stop the database.

29. Test database server • Use the Enterprise Manager console to test the database server.

30. Oracle Enterprise Manager • Enter address of server and SID. • Name the server. • Click OK.

31. Databases connect information • Select database. • Enter system account and password. • Change connection box to “AS SYSDBA.” • Click OK.

32. Open database • Database is opened and exposed.

33. Listener • Listener automatically picks up the SID from the database. • Start Listener before database and the SID will display in the Listener. • If you start the database before the Listener, the SID may not appear immediately. • To see if the SID is registered in the Listener, enter: $lsnrctl stat

34. Alter a user • User is altered: SQL> alter user oe identified by oe account unlock; SQL> exit • Preferred method is to use the Enterprise Manager Console.