æä½é¡ºåºå¦ä¸ï¼
1.å建å®ä¾å¯å¨ç¨çåæ°æ件ãå¨ç¨åºé»è®¤çåæ°æ件éä¿®æ¹å³å¯ï¼éå½åè§å initSID.ora
/u01/oracle/product/11.2.0/db_1/dbs/ ä¸ï¼ç®å½å°½é使ç¨ç»å¯¹è·¯å¾ï¼éç¨ORACLE_BASEçç¯å¢åéæå¯è½æ¥éã
ä¾ initcrm.ora
db_name='crm' --ä¿®æ¹
#memory_target=500m --注éæ
sga_target=200m --æ·»å
pga_aggregate_target=60m --æ·»å
processes = 150
audit_file_dest='/u01/oracle/admin/crm/adump' --建ç«ç®å½
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/oracle/flash_recovery_area' --建ç«ç®å½
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/oracle' ---ä¿®æ¹
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
2.å建ç¸åºç®å½ï¼
mkdir -p /u01/oracle/admin/ora11g/adump
mkdir -p /u01/oracle/admin/ora11g/dpdump
mkdir -p /u01/oracle/flash_recovery_area
3.å建å¯ç æ件ï¼å½åè§å orapwSIDï¼ç®å½ä¾æ§æ¯ /u01/oracle/product/11.2.0/db_1/dbs/
Linuxä¸orapw+å®ä¾å
Windowsä¸pwd+å®ä¾å
$ orapwd file=orapwora11g password=oracle
4.å建æ°æ®åºå®ä¾
设置ç¯å¢åé export ORACLE_SID=crm
æ§è¡ä»¥ä¸å½ä»¤
sqlplus /nolog
conn / as sysdba
注æï¼æ¬å¤å¯è½æ¥ééè¦å¯è½çåå ï¼ aï¼glibc-devel-2.5-58.el5_6.4ãlibaio-0.3.106-5å
æ¯å¦å·²å®è£
ï¼å½ä»¤åå«ä¸ºrpm -q glibc-develãrpm -q libaio
bï¼oracleç®å½æéä¸è¶³æå±ç»ä¸å¯¹ï¼chmod 6751 oracle ææãchown -R oracle.oinstall /u01/oracle ä¿®æ¹å±ç»
æ§è¡å»ºåºèæ¬ï¼
startup nomount pfile="/u01/oracle/product/11.2.0.1/db1/dbs/initcrm.ora";
CREATE DATABASE "crm"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/u01/oracle/oradata/system01.dbf' SIZE 1024M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oracle/oradata/sysaux01.dbf' SIZE 500M REUSE
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oracle/oradata/temp01.dbf' SIZE 20M REUSE
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/oracle/oradata/undo01.dbf' SIZE 300M REUSE
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/u01/oracle/oradata/log01.dbf') SIZE 50M,
GROUP 2 ('/u01/oracle/oradata/log02.dbf') SIZE 50M,
GROUP 3 ('/u01/oracle/oradata/log03.dbf') SIZE 50M;
å建USERS表空é´
CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/u01/app/oradata/user01.dbf' SIZE 1000M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER DATABASE DEFAULT TABLESPACE "USERS";
------------------------------------------
SQL> create spfile from pfile;
File created.
-----------------------------------------
sqlplus / as sysdba
SQL> show user;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catalog.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catblock.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catproc.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catoctk.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/owminst.plb;
使ç¨systemç¨æ·ç¼è¯
@/u01/oracle/product/11.2.0.1/db1/sqlplus/admin/pupbld.sql;
@/u01/oracle/product/11.2.0.1/db1/sqlplus/admin/help/hlpbld.sql helpus.sql;
使ç¨sysç¨æ·ç¼è¯
@/u01/oracle/product/11.2.0.1/db1/javavm/install/initjvm.sql;
@/u01/oracle/product/11.2.0.1/db1/xdk/admin/initxml.sql;
@/u01/oracle/product/11.2.0.1/db1/xdk/admin/xmlja.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catjava.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catexf.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catqm.sql change_on_install SYSAUX TEMP YES;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catxdbj.sql;
@/u01/oracle/product/11.2.0.1/db1/rdbms/admin/catrul.sql;
spool /oracle/admin/edidb/scripts/ordinst.log append
@/u01/oracle/product/11.2.0.1/db1/ord/admin/ordinst.sql SYSAUX SYSAUX;
spool off
spool /u01/oracle/admin/ora11g/scripts/interMedia.log append
@/u01/oracle/product/11.2.0.1/db1/ord/im/admin/iminst.sql;
spool off
set echo on
spool /oracle/admin/edidb/scripts/lockAccount.log append
BEGIN
FOR item IN ( SELECT USERNAME FROM DBA_USERS WHERE ACCOUNT_STATUS IN ('OPEN', 'LOCKED', 'EXPIRED') AND USERNAME NOT IN (
'SYS','SYSTEM') )
LOOP
dbms_output.put_line('Locking and Expiring: ' || item.USERNAME);
execute immediate 'alter user ' ||
sys.dbms_assert.enquote_name(
sys.dbms_assert.schema_name(
item.USERNAME),false) || ' password expire account lock' ;
END LOOP;
END;
/
spool off
å°æ¤ï¼æ°æ®åºå®ä¾å»ºç«å®æ¯ã
温馨提示:答案为网友推荐,仅供参考