Using OUI to install Oracle9i 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 _at_DKA100disk1runins
  taller.
• This will not work because the RUNINSTALLER.COM
  file is not in the root of DKA100disk1.
• You must first copy RUNINSTALLER.COM from the
  dka100disk1.000000 directory into
  dka100disk1
• Copy dka100disk1.000000runinstaller.com
  dka100disk1
• From a terminal window execute
• _at_DKA100disk1runinstaller

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
• Dka100oracle.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 DKA100oracle.oracle9
  .
• To create the first database, you must first set
  up Oracle logicals.
• To do this use a terminal and execute
  _at_.oracle9orauser .
• 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, DKA100oracle.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
• _at_dka100oracle.oracle9orauser 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
• SQLgt alter user oe identified by oe account
  unlock
• SQLgt exit
• Preferred method is to use the Enterprise Manager
  Console.

35
(No Transcript)