安装很简单,注意几个默认的用户\目录等环境变量
oracle install guide 上写的东西很多,有些不必要配,如果是实验的话
下面是一个精简的,基本能满足平时的要求
==================================================
install oracle on hpux 10.2.0.1.0
==================================================
# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G dba oracle
# passwd oracle
ORACLE_BASE
# mkdir -p /var/app/oracle
# chown -R oracle:oinstall /var/app/oracle
# chmod -R 755 /var/app/oracle
for data file and flash_recovery_area
# mkdir /usr/oradata
# chown oracle:oinstall /usr/oradata
# chmod 755 /usr/oradata
# mkdir /usr/flash_recovery_area
# chown oracle:oinstall /usr/flash_recovery_area
# chmod 755 /usr/flash_recovery_area
# mkdir /home/oracle
# chown oracle:oinstall /home/oracle
# chmod 755 /home/oracle
if there is not .profile for sh
just create it.
echo $SHELL
------
if you are using vnc
please do the following:
Starting applications specified in //.vnc/xstartup
xhost +
DISPLAY=serverip:VNCnum.0 ; export DISPLAY
-----
if you are not using vnc
xhost + server ip
or xhost +
DISPLAY=clientip:0.0 ; export DISPLAY
-----
--for testing
xclock -display clientip:0.0
finger
-----
umask 022
# su - root
# mkdir /opt/tmp
# chmod a+wr /opt/tmp
$ TMP=/opt/tmp
$ TMPDIR=/opt/tmp
$ export TMP TMPDIR
ORACLE_HOME=/var/app/oracle
ORACLE_SID=test1
run /usr/local/bin/oraenv
OR
export PATH=$PATH:$ORACLE_HOME/bin
using same password for sys,system,dbsnmp,sysman user
create database using dbca
test your database
$ sqlplus "/as sysdba"
SQL> select sysdate from dual;
SYSDATE
---------
27-JUN-08
SQL> desc v$database
Name Null? Type
----------------------------------------- -------- ----------------------------
DBID NUMBER
NAME VARCHAR2(9)
CREATED DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
PRIOR_RESETLOGS_CHANGE# NUMBER
PRIOR_RESETLOGS_TIME DATE
LOG_MODE VARCHAR2(12)
CHECKPOINT_CHANGE# NUMBER
ARCHIVE_CHANGE# NUMBER
CONTROLFILE_TYPE VARCHAR2(7)
CONTROLFILE_CREATED DATE
CONTROLFILE_SEQUENCE# NUMBER
CONTROLFILE_CHANGE# NUMBER
CONTROLFILE_TIME DATE
OPEN_RESETLOGS VARCHAR2(11)
VERSION_TIME DATE
OPEN_MODE VARCHAR2(10)
PROTECTION_MODE VARCHAR2(20)
PROTECTION_LEVEL VARCHAR2(20)
REMOTE_ARCHIVE VARCHAR2(8)
ACTIVATION# NUMBER
SWITCHOVER# NUMBER
DATABASE_ROLE VARCHAR2(16)
ARCHIVELOG_CHANGE# NUMBER
ARCHIVELOG_COMPRESSION VARCHAR2(8)
SWITCHOVER_STATUS VARCHAR2(20)
DATAGUARD_BROKER VARCHAR2(8)
GUARD_STATUS VARCHAR2(7)
SUPPLEMENTAL_LOG_DATA_MIN VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_PK VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(3)
FORCE_LOGGING VARCHAR2(3)
PLATFORM_ID NUMBER
PLATFORM_NAME VARCHAR2(101)
RECOVERY_TARGET_INCARNATION# NUMBER
LAST_OPEN_INCARNATION# NUMBER
CURRENT_SCN NUMBER
FLASHBACK_ON VARCHAR2(18)
SUPPLEMENTAL_LOG_DATA_FK VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_ALL VARCHAR2(3)
DB_UNIQUE_NAME VARCHAR2(30)
STANDBY_BECAME_PRIMARY_SCN NUMBER
FS_FAILOVER_STATUS VARCHAR2(21)
FS_FAILOVER_CURRENT_TARGET VARCHAR2(30)
FS_FAILOVER_THRESHOLD NUMBER
FS_FAILOVER_OBSERVER_PRESENT VARCHAR2(7)
FS_FAILOVER_OBSERVER_HOST VARCHAR2(512)
SQL> select name from v$database;
NAME
---------
TEST1
阅读(1672) | 评论(0) | 转发(0) |
