topic Re: HP-Oracle database in Operating System - HP-UX

HP-Oracle database

Deanna Tran — Thu, 21 Feb 2002 16:54:24 GMT

Hi,I have accomplished put Oracle 9i on the HP. My question is that
1.do i have to load the client as well before I can start up the database?
2. Is there any special instruction on how to start up the database?
3. If I want to run some I/O on some mount points, does the procedure to create a vg and logical and filesystem the same as stated in LVM?
Thank you very much for your help

Re: HP-Oracle database

Sanjay_6 — Thu, 21 Feb 2002 17:03:55 GMT

Hi Deanna,

Try the oracle Administrator Guide for hp-ux,

http://docs.oracle.com/HTML_Storage/a90347/toc.htm

you should be installing the client part on your workstation.

hope this helps.

Regds

Re: HP-Oracle database

Sanjay_6 — Thu, 21 Feb 2002 17:05:50 GMT

Hi Deanna,

Missed your last question. The procedure is same as creating normal lvm filesystems and vg's. you won't have to create the filesystem on the logical volume is you plan to use raw disk space to store your database.

Hope this helps.

regds

Re: HP-Oracle database

Deanna Tran — Thu, 21 Feb 2002 20:29:01 GMT

I have browsed through the documenatation that you sent out as a link. i am new at this database thing, as I read through it, i got confuse? Can you help me to simiply the procedure on how to start up the database?

Re: HP-Oracle database

Roger Baptiste — Fri, 22 Feb 2002 01:08:09 GMT

Hi,

On a tangent,
I would suggest this good book - OracleDBA 101, to get a nice and entertaining intro
do DB administration.
A quicklink:
http://www.amazon.com/exec/obidos/ASIN/0072121203/qid=1014340182/sr=1-1/ref=sr_1_1/103-2894632-2274224

-raj

Re: HP-Oracle database

Andreas D. Skjervold — Fri, 22 Feb 2002 08:31:09 GMT

Hi

1. You do not have to have a client to start the database, just run the sqlplus:
startup pfile=/oracle/admin/pfile/init.ora
(The Oracle client is installed by default if you haven't deselected it during custom install.)

2. As oracle user (oracle software owner) start sqlplus:
SQL> startup
pfile=/oracle/admin//pfile/init.ora

If link to init.ora is placed in $ORACLE_HOME/dbs :
SQL> startup

You'll see the startup sequence:
Instance started
Database Mounted
Database Open

and the SGA sizes spelled out.

3. To create I/O on specific mount points you have to push data into the database in segments (tables) placed in tablespace that is placed on that spesific mount point.

Andreas