pooh

여기에서 가져옴 -------------------------------------------------------------------------------------- lsThis article presents how to install Oracle 12C(12.2) Release 2 on Oracle Enterprise Linux 7 (OEL7) in silent mode.Read following article how to install Oracle Enterprise Linux 7: Install Oracle Linux 7 (OEL7) (for comfort set 4G memory for your virtual machine before proceeding with Oracle software..

여기에서 펌 -------------------------------------------------------------------------------------- This article presents how to install Oracle 12C Release 1 in silent mode.Silent mode installation allows to configure necessary Oracle components without using graphical interface nor any interaction with end user. It’s very useful method especially when you want to prepare standard installation using s..

service 등록 [root@oracle11g ~]# /etc/rc.d/init.d/oradb #!/bin/sh## chkconfig: 345 99 99# description: oracle Database# processname: $ORA_HOME/bin/dbstart# config:# pidfile:## source function library. /etc/rc.d/init.d/functions# pull in sysconfig settings RETVAL=0 prog="Oracle Database" lock_file="oradb" ORA_OWNER="oracle" ORA_HOME=`su - $ORA_OWNER -c env | grep ORACLE_HOME | awk -F'=' '{print $2}..

여기에서 가져옴 OS configuration and preparationOS configuration is executed as root. To login as root just execute following command in terminal.su - rootAdd groups--groups for database management --groups id are the same as for 12C installations --some groups are not required here but can be used --later for grid binaries installation groupadd oinstall groupadd dba groupadd operAdd user Oracle--get d..

- tablespace 확인 select tablespace_name, bytes, file_name from dba_data_files; - tablespace 생성 create tablespace [new table name] datafile '[tablespace name].dbf' size 500M - user 생성create user [user name]identified by [password]default tablespace [new tablespace name]quota unlimited on [new tablespace name];* 12c에서 ORA-65096: invalid common user or role name 발생 시 user name 앞에 "c##" 을 붙인다. 또는 "al..