OCM实验-手工建库

来源：互联网发布：游戏支付软件编辑：程序博客网时间：2024/05/01 21:35

startup nomount; --先确保参数文件有效

CREATE DATABASE orclUSER SYS IDENTIFIED BY sysUSER SYSTEM IDENTIFIED BY systemLOGFILE GROUP 1 ('/u01/redo_logs/redo01a.log','/u01/redo_logs/redo01b.log') SIZE 100M BLOCKSIZE 512,GROUP 2 ('/u01/redo_logs/redo02a.log','/u01/redo_logs/redo02b.log') SIZE 100M BLOCKSIZE 512,GROUP 3 ('/u01/redo_logs/redo03a.log','/u01/redo_logs/redo03b.log') SIZE 100M BLOCKSIZE 512MAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100CHARACTER SET ZHS16GBKNATIONAL CHARACTER SET AL16UTF16EXTENT MANAGEMENT LOCALDATAFILE '/home/oracle/oradata/system01.dbf' SIZE 325M REUSESYSAUX DATAFILE '/home/oracle/oradata/sysaux01.dbf' SIZE 325M REUSEDEFAULT TABLESPACE usersDATAFILE '/home/oracle/oradata/users01.dbf'SIZE 10M REUSE AUTOEXTEND ON MAXSIZE UNLIMITEDDEFAULT TEMPORARY TABLESPACE tempts1TEMPFILE '/home/oracle/oradata/temp01.dbf'SIZE 20M REUSEUNDO TABLESPACE undotbs1DATAFILE '/home/oracle/oradata/undotbs01.dbf'SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

SQL> show parameter serviceNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------service_names                        string      ORCL

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

In SQL*Plus, connect to your Oracle Database instance as SYSTEM user:

@?/sqlplus/admin/pupbld.sql

--配置连接字符串vict = (DESCRIPTION =    (ADDRESS =    (PROTOCOL = TCP)(HOST = 192.168.180.128 )(PORT = 1521)) (CONNECT_DATA =    (SERVICE_NAME = ORCL )  ))