Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1036614
  • 博文数量: 74
  • 博客积分: 10000
  • 博客等级: 上将
  • 技术积分: 2950
  • 用 户 组: 普通用户
  • 注册时间: 2007-05-15 00:17
文章分类

全部博文(74)

文章存档

2009年(1)

2008年(73)

我的朋友

分类: 服务器与存储

2008-06-28 13:02:28

安装很简单,注意几个默认的用户\目录等环境变量
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
阅读(1608) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~