cancel
Showing results for 
Search instead for 
Did you mean: 

HP-Oracle database

Deanna Tran
Frequent Advisor

HP-Oracle database

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
5 REPLIES
Sanjay_6
Honored Contributor

Re: HP-Oracle database

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
Sanjay_6
Honored Contributor

Re: HP-Oracle database

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
Deanna Tran
Frequent Advisor

Re: HP-Oracle database

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?
Roger Baptiste
Honored Contributor

Re: HP-Oracle database


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
Take it easy.
Andreas D. Skjervold
Honored Contributor

Re: HP-Oracle database

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!