Transcript Using OUI to install Oracle9i release 2 on an OpenVMS system

Using OUI to install Oracle9i
Release 2 on an OpenVMS
System
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.
page 2
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.
page 3
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
page 4
Oracle Installer starts
page 5
Start the installation
•
Click Next to start the
installation.
page 6
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.
page 7
Select product to install
•
Select Database.
• Click Next.
page 8
Select type of installation
•
Select Enterprise Edition.
• Click Next.
page 9
Enable RAC
•
Select No.
• Click Next.
page 10
Database summary
•
View list of products that will be
installed.
• Click Install.
page 11
Installation begins
•
Installation takes from 45
minutes to an hour.
page 12
Installation ends
•
Installation ends.
• Click Exit.
page 13
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.
page 14
Welcome to Database Configuration
Assistant
•
DBCA starts.
• Click Next.
page 15
Select an operation
•
Select Create a Database.
• Click Next.
page 16
Select a template
•
Select New Database.
• Click Next.
page 17
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.
page 18
Select database features
•
Select which demo databases
are installed.
– In the example, we selected
all possible databases.
• Click Next.
page 19
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.
page 20
Select memory
•
In the example, we selected
the default.
• Click Next.
page 21
Specify database storage parameters
•
Select the device and directory.
• Use the UNIX device syntax
I.E.
– For example,
DKA100:[oracle.oracle9.data
base] would be:
/DKA100/oracle/oracle9/database/
•
In the example, we kept the
default settings.
• Click Next.
page 22
Select database creation options
•
Creating a template saves time
when creating a database.
• Click Finish.
page 23
Create a template
•
Click OK.
page 24
Creating and starting Oracle Instance
•
The database builds.
• If it completes successfully,
click Exit.
• If it does not complete
successfully, build it again.
page 25
Running the database
Enter “show system” to see the
Oracle database up and
running.
• Set up some files to start and
stop the database.
•
page 26
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.
page 27
Stop database example
•
Example of how to stop the
database.
page 28
Test database server
•
Use the Enterprise Manager
console to test the database
server.
page 29
Oracle Enterprise Manager
•
Enter address of server and
SID.
• Name the server.
• Click OK.
page 30
Databases connect information
•
Select database.
• Enter system account and
password.
• Change connection box to “AS
SYSDBA.”
• Click OK.
page 31
Open database
•
Database is opened and
exposed.
page 32
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
page 33
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.
page 34