cd /oracle/product/11g/client
./runInstaller -silent -debug -force \
oracle.install.option=INSTALL_DB_SWONLY \
UNIX_GROUP_NAME=dba \
ORACLE_HOME=/oracle/product/11g \
ORACLE_BASE=/oracle \
INVENTORY_LOCATION=/oracle/oraInventory \
oracle.install.db.InstallEdition=EE \
oracle.install.db.DBA_GROUP=dba \
oracle.install.db.OPER_GROUP=dba \
oracle.install.db.OSBACKUPDBA_GROUP=dba \
oracle.install.db.OSDGDBA_GROUP=dba \
oracle.install.db.OSKMDBA_GROUP=dba \
oracle.install.db.OSRACDBA_GROUP=dba \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
DECLINE_SECURITY_UPDATES=true


export ORACLE_SID=rb
mkdir -p /oracle/admin/rb/scripts 
cd /oracle/admin/rb/scripts 
vi init.ora
################################################
##############################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
################################################
##############################
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_cache_size=40G
db_file_multiblock_read_count=128
###########################################
# Cursors and Library Cache
###########################################
open_cursors=2000
###########################################
# Database Identification
###########################################
db_domain=""
db_name=rb
###########################################
# Diagnostics and Statistics
###########################################
core_dump_dest=/oracle/diag/rdbms/rb/rb/cdump
###########################################
# File Configuration
###########################################
control_files=("/rbdata/rb/control01.ctl", "/rbdata/rb/control02.ctl","/rbdata/rb/control03.ctl")
###########################################
# Job Queues
###########################################
job_queue_processes=1920
###########################################
# Miscellaneous
###########################################
compatible=19.19.0.0.0
###########################################
# Pools
###########################################
streams_pool_size=512M
java_pool_size=512M
large_pool_size=512M
###########################################
# Processes and Sessions
###########################################
processes=8000
sessions=1655
###########################################
# Security and Auditing
###########################################
audit_file_dest=/oracle/admin/rb/adump
remote_login_passwordfile=EXCLUSIVE
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=20G
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1 

sqlplus / as sysdba
create spfile from pfile='/oracle/admin/rb/scripts/init.ora';

startup nomount;

CREATE DATABASE rb
USER SYS IDENTIFIED BY ZTEsoft123
USER SYSTEM IDENTIFIED BY ZTEsoft123
LOGFILE GROUP 1 ('/rbredo/rb/redo1_1.dbf','/rbredo/rb/redo1_2.dbf') SIZE 2G BLOCKSIZE 512,
GROUP 2 ('/rbredo/rb/redo2_1.dbf','/rbredo/rb/redo2_2.dbf') SIZE 2G BLOCKSIZE 512,
GROUP 3 ('/rbredo/rb/redo3_1.dbf','/rbredo/rb/redo3_2.dbf') SIZE 2G BLOCKSIZE 512,
GROUP 4 ('/rbredo/rb/redo4_1.dbf','/rbredo/rb/redo4_2.dbf') SIZE 2G BLOCKSIZE 512,
GROUP 5 ('/rbredo/rb/redo5_1.dbf','/rbredo/rb/redo5_2.dbf') SIZE 2G BLOCKSIZE 512,
GROUP 6 ('/rbredo/rb/redo6_1.dbf','/rbredo/rb/redo6_2.dbf') SIZE 2G BLOCKSIZE 512,
GROUP 7 ('/rbredo/rb/redo7_1.dbf','/rbredo/rb/redo7_2.dbf') SIZE 2G BLOCKSIZE 512,
GROUP 8 ('/rbredo/rb/redo8_1.dbf','/rbredo/rb/redo8_2.dbf') SIZE 2G BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/rbdata/rb/system01.dbf' SIZE 1024M REUSE
SYSAUX DATAFILE '/rbdata/rb/sysaux01.dbf' SIZE 1024M REUSE
DEFAULT TABLESPACE users
DATAFILE '/rbdata/rb/users01.dbf'
SIZE 50M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/rbdata/rb/temp01.dbf'
SIZE 1024M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/rbdata/rb/undotbs01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

SQL>alter user sys identified by "1jian8Shu!";
SQL>alter user system identified by "1jian8Shu!"; 

SQL>select instance_name,status from v$instance;

SQL> @?/rdbms/admin/catalog.sql 
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/utlrp.sql
SQL> @?/sqlplus/admin/pupbld.sql 

配置监听
vi $ORACLE_HOME/network/admin/listener.ora
LISTENER_crm =
(DESCRIPTION_LIST =
   (DESCRIPTION =
       (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.187.175)(PORT = 11521))
       )
    )
)

SID_LIST_LISTENER_crm =
(SID_LIST =
     (SID_DESC =
           (GLOBAL_DBNAME = crm)
           (ORACLE_HOME = /oracle/product/19c)
           (SID_NAME = crm)
      )
)

lsnrctl start LISTENER_cc
lsnrctl stop LISTENER_cc

vi $ORACLE_HOME/network/admin/tnsnames.ora
crm =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.184.175)(PORT = 11521))
    )
  (CONNECT_DATA =
    (SERVER = DEDICATED)
      (SERVICE_NAME = crm)
    )
  )

crm：
创建profile
create profile ZSMART limit
 sessions_per_user unlimited
 cpu_per_session unlimited
 cpu_per_call unlimited
 connect_time unlimited
 idle_time unlimited
 logical_reads_per_session unlimited
 logical_reads_per_call unlimited
 composite_limit unlimited
 private_sga unlimited
 failed_login_attempts unlimited
 password_life_time unlimited
 password_reuse_time unlimited
 password_reuse_max unlimited
 password_lock_time 1/24
 password_grace_time 7
 password_verify_function ORA12C_VERIFY_FUNCTION;

SQL >commit;


创建表空间
create tablespace TAB_RB datafile '/rbdata/rb/tab_rb_001.dbf' size 30G;
alter database datafile '/rbdata/rb/tab_rb_001.dbf' autoextend off;
扩容表空间
alter tablespace TAB_RB add datafile '/rbdata/rb/tab_rb_006.dbf' size 30G autoextend off;
创建用户 
create user RB identified by "1jian8Shu!" default tablespace TAB_RB  profile ZSMART;

分配新的默认表空间
ALTER USER MDB DEFAULT TABLESPACE TAB_RB;
赋予用户表空间
ALTER USER RB QUOTA unlimited ON IDX_RB;

create tablespace IDX_RB datafile '/rbdata/rb/idx_rb_001.dbf' size 30G;
alter database datafile '/rbdata/rb/idx_rb_001.dbf' autoextend off;
扩容表空间
alter tablespace IDX_RB add datafile '/rbdata/rb/idx_rb_005.dbf' size 30G autoextend off;
赋予用户表空间
ALTER USER RB QUOTA unlimited ON IDX_RB;

赋权
grant SET CONTAINER to rb;
grant CREATE SESSION to rb;
grant CREATE TRIGGER to rb;
grant CREATE SEQUENCE to rb;
grant CREATE TYPE to rb;
grant CREATE PROCEDURE to rb;
grant CREATE CLUSTER to rb;
grant CREATE OPERATOR to rb;
grant CREATE INDEXTYPE to rb; 
grant CREATE TABLE to rb;
grant CREATE SYNONYM to rb;
grant CREATE VIEW to rb;
grant CREATE MATERIALIZED VIEW to rb;
grant CREATE DATABASE LINK to rb;
grant ALTER SESSION to rb;
grant DEBUG ANY PROCEDURE to rb;
grant DEBUG CONNECT SESSION to rb;
grant SELECT ANY TABLE to rb;
grant SELECT ANY TRANSACTION to rb;
grant CREATE JOB to rb;
grant EXP_FULL_DATABASE to rb;
grant IMP_FULL_DATABASE to rb;
grant UNLIMITED TABLESPACE to rb;

修改为归档模式
alter system set log_archive_dest_1='LOCATION=/archcc2' scope=spfile;
shutdown immediate
startup mount
alter database archivelog;
alter database open;
archive log list

ALTER DATABASE NOARCHIVELOG;
SHUTDOWN IMMEDIATE;
startup;




SELECT table_name
FROM all_tables
WHERE owner=mccm;


DROP USER CC CASCADE;