350 likes | 499 Views
Using OUI to install Oracle9 i 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.
E N D
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.
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.
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
Start the installation • Click Next to start the installation.
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.
Select product to install • Select Database. • Click Next.
Select type of installation • Select Enterprise Edition. • Click Next.
Enable RAC • Select No. • Click Next.
Database summary • View list of products that will be installed. • Click Install.
Installation begins • Installation takes from 45 minutes to an hour.
Installation ends • Installation ends. • Click Exit.
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.
Welcome to Database Configuration Assistant • DBCA starts. • Click Next.
Select an operation • Select Create a Database. • Click Next.
Select a template • Select New Database. • Click Next.
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.
Select database features • Select which demo databases are installed. • In the example, we selected all possible databases. • Click Next.
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.
Select memory • In the example, we selected the default. • Click Next.
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.
Select database creation options • Creating a template saves time when creating a database. • Click Finish.
Create a template • Click OK.
Creating and starting Oracle Instance • The database builds. • If it completes successfully, click Exit. • If it does not complete successfully, build it again.
Running the database • Enter “show system” to see the Oracle database up and running. • Set up some files to start and stop the database.
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.
Stop database example • Example of how to stop the database.
Test database server • Use the Enterprise Manager console to test the database server.
Oracle Enterprise Manager • Enter address of server and SID. • Name the server. • Click OK.
Databases connect information • Select database. • Enter system account and password. • Change connection box to “AS SYSDBA.” • Click OK.
Open database • Database is opened and exposed.
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
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.