Basic Library operation in Oracle database _oracle

Graphics Build Library:

1. Determine if there is a library to build
View

$ORACLE _base/admin/and $oracle_base/oradata

2. Run DBCA
3. Select New Library--general purpose (Universal Library) template--global database name: library name. Domain name, you can use only the library name--sid case-sensitive ——......—— Data path selection, the template default is $oracle_base/ oradata/dababase--The path of backup data-memory allocation (SGA dedicated memory, transaction processing, PGA system memory, data-oriented) | The block size in the sizing can only be modified in the initial configuration, the SGA each user corresponds to a process, PGA a connection pool for users, connection process number = number of users + some background running process (20) | Character Set recommendation AL32UTF8 (support XML) ——......—— save scripts when building a library Scripts are stored in $oracle_base/admin/oradata/
4. Configure OEM
Run DBCA, select Configuration database, select Database, choose to configure OEM, next ...

OMF-based Command Building (DATABASENAME:ULP):

1.

 mkdir $ORACLE _base/admin/ulp/{a,b,c,u,dp}dump–p

2.

mkdir $ORACLE _base/oradata/ulp

3.

CD $ORACLE _home/dbs/----> Preparation Parameters File

4.

VI Initulp.ora 

Compatible= ' 10.2.0.1.0 '
db_name= ' ulp '
db_block_size=8192
core_dump_dest= '/u01/oracle/admin/ulp/ Cdump '----> Log
user_dump_dest= '/u01/oracle/admin/ulp/udump '
background_dump_dest= '/u01/oracle/admin/ Ulp/bdump '
sga_max_size=200m----> Automatic management
db_create_file_dest= '/u01/oracle/oradata/'----> Data storage
db_create_online_log_dest_1= '/u01/oracle/oradata/'----> Log
undo_management=auto
undo_ Tablespace= ' Sys_undots '

5.

Orapwd file=orapwulp password=oracle----> Generate password file

6.

Export ORACLE_SID=ULP----> Specify a Startup instance

7.

Sqlplus "/as sysdba"

8.

 >startup Nomount----> Startup instance

9.

>create SPFile from Pfile;

10.

>startup Force Nomount;

11.

>create database Ulp; ----> CREATE DATABASE ULP

12.

 >create tablespace users; ----> Create User table Space

13.

>create temporary tablespace temp; ----> Create temporary table spaces

14.

 >alter database default tablespace users;

15.

 >alter database default temporary tablespace temp;

16.

>create undo Tablespace Undotbs;

17.

#vi Ulp.sql

@/u01/oracle/10g/rdbms/admin/catalog.sql
@/u01/oracle/10g/rdbms/admin/catproc.sql
Conn system/oracle
@/u01/oracle/10g/sqlplus/admin/pupbld.sql
conn/as sysdba
shutdown immediate
startup

18.

 > @ulp. SQL----> establishing a data dictionary

19. Configure Remote Access database NET 1521
Modify/u01/oracle/10g/network/admin/listener.ora and/u01/oracle/10g/network/admin/tnsnames.ora
20. Test whether the library was successfully built:

>shutdown Immediate
>startup

21. Configuration enables DBCA to manage ULP

Vi/etc/oratab

Add to:

Ulp:/u01/oracle/10g:n

22. Configure the OEM if needed

Emca–repos Create
emca–config Dbcontrol db
export Oracle_sid=ulp
emctl start dbconsole
emca–reconfig Ports–dbcontrol_http_port 1180----> can change port
EMCA–RECONIFG ports–agent_port 3940----> can change proxy port

DBCA Silent Building Library

1. Use response file:

Dbca-silent-clonetemplate-gdbname orcl-sid orcl-datafiledestion $ORACLE _base/oradata-syspassword oracle-systempass Word oracle-emconfiguration Local-dbsnmppassword Oracle-sysmanpassword oracle-responsefile/mnt/response/dbca.rsp

-datafiledestion Default $oracle_base/oradata not write
-emconfiguration configuration OEM (if required)
-responsefile Specify Response file

Modify Password:

Select Username,account_status from dba_users where account_status= ' OPEN ';
Alter user XXX identified by NewPassword;

Network configuration:

VI $ORACLE _home/network/admin/tnsnames.ora

2. Use Template:

To create a template from an existing database (clone database):

Dbca-silent-createclonetemplate-sourcedb Orcl-templatename Tempname 

Template tempname stored in $oracle_home/assistants/dbca/templates/
Under this directory, the CTL is a control file backup; The DBC is a template; The DFB is a backup set made by Rman, including all running files in the library
You can also use Oracle-brought templates. The following example uses a self-modeled version.

-----

Dbca-silent-createdatabase-templatename $ORACLE _home/assistants/dbca/templates/general_purpose.dbc-gdbname Foway -sid foway-responsefile no_value-characterset al32utf8-nationalcharacterset al16utf16-datafiledestion $ORACLE _base/ Oradata-emconfiguration Local

-datafiledestion Default $oracle_base/oradata not write
-templatename Specify template
-characterset Specify the encoding set
-emconfiguration configuration OEM (if required)

Attached: DBCA silently Delete database

Dbca-silent-deletedatabase-sourcedb dbname