ORACLE11G Manual Hard Steps

Source: Internet
Author: User

#create Oracle Instance parameter
VI initkevin.or
Db_name= ' Kevin '
Memory_target=0
sga_max_size=5g
sga_target=3g
pga_aggregate_target=1g
processes = 150
Audit_file_dest= '/u01/app/oracle/admin/kevin/adump '
Audit_trail = ' db '
db_block_size=8192
Db_domain= "
Db_recovery_file_dest= '/u01/app/oracle/flash_recovery_area '
db_recovery_file_dest_size=2g
Diagnostic_dest= '/u01/app/oracle '
Dispatchers= ' (protocol=tcp) (SERVICE=ORCLXDB) '
open_cursors=300
Remote_login_passwordfile= ' EXCLUSIVE '
Undo_tablespace= ' Undotbs '
Control_files = ('/u01/app/oracle/oradata/kevin/disk1/controflie01.ctl ', '/u01/app/oracle/oradata/kevin/disk2/ Controlfile02.ctl ')
compatible = ' 11.2.0 '


#create audit_file directory, db_recovery directory and Orther directories
Mkdir-p/u01/app/oracle/admin/kevin/adump
Mkdir-p/u01/app/oracle/flash_recovry_area
Mkdir-p/u01/app/oracle/oradata/kevin/disk1
Mkdir-p/u01/app/oracle/oradata/kevin/disk1


#configure Oracle User Environment value
Export Oracle_sid=kevin


#create Oracle Password Pfile
Orapwd File=orapwdkevin password=oracle entries=3 force=y



#start Nomount Oracle Database instance


Startup Nomount Pifle=?/dbs/initkevin.ora


sql> Startup Nomount Pfile=?/dbs/initkevin.ora
ORACLE instance started.


Total System Global area 5344731136 bytes
Fixed Size 2262656 bytes
Variable Size 2885683584 bytes
Database buffers 2449473536 bytes
Redo buffers 7311360 bytes


#create SPFile from Pfile
Create SPFile from Pfile;


Sql>
Sql> create SPFile from Pfile;


File created.




#create database;


CREATE DATABASE Kevin
USER SYS identified by Oracle
USER SYSTEM identified by Oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/kevin/disk1/redo01a.log ', '/u01/app/oracle/oradata/kevin/disk2/ Redo01b.log ') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/kevin/disk1/redo02a.log ', '/u01/app/oracle/oradata/kevin/disk2/redo02b.log ') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/kevin/disk1/redo03a.log ', '/u01/app/oracle/oradata/kevin/disk2/redo03b.log ') SIZE 100M BLOCKSIZE 512
Maxlogfiles 5
Maxlogmembers 5
Maxloghistory 1
Maxdatafiles 100
CHARACTER SET Al32utf8
National CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DataFile '/u01/app/oracle/oradata/kevin/disk1/system01.dbf ' SIZE 325M reuse
Sysaux datafile '/u01/app/oracle/oradata/kevin/disk2/sysaux01.dbf ' SIZE 325M reuse
DEFAULT tablespace Users
DataFile '/u01/app/oracle/oradata/kevin/disk1/users01.dbf '
SIZE 500M Reuse autoextend on MAXSIZE UNLIMITED
DEFAULT Temporary tablespace tempts1
Tempfile '/u01/app/oracle/oradata/kevin/disk2/temp01.dbf '
SIZE 20M Reuse
UNDO tablespace Undotbs
DataFile '/u01/app/oracle/oradata/kevin/disk3/undotbs01.dbf '
SIZE 200M Reuse autoextend on MAXSIZE 1024m;





#create Oracle Dictionary Information


@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql




@?/sqlplus/admin/pupbld.sql




The database was created successfully















ORACLE11G Manual Hard Steps

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.