Oracle 11g 手工创建数据库实验
来源:互联网 发布:js常用正则表达式 编辑:程序博客网 时间:2024/05/18 02:23
Oracle数据库的手工建库是依据Oracle数据库的体系结构,依次创建实例、创建物理结构、创建逻辑结构。
手工建库一般需要八个步骤:
1.设置oracle用户环境变量
2.准备数据库相关目录
3.生成实例的口令文件
4.生成实例的pfile参数文件
5.生成实例的spfile文件,并启动到nomount
6.执行数据库创建语句
7.执行动态性能视图创建脚本
8.确认数据库运行状态
具体操作过程如下:
1.设置oracle用户环境变量
$ cd
$ vim .bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=ENMOEDU
export PATH=$ORACLE_HOME/bin:$PATH
生效:
source .bash_profile
验证:
echo $ORACLE_HOME
echo $ORACLE_SID
2.创建所需的目录
创建目录:
$ cd $ORACLE_BASE
$ mkdir -p admin/ENMOEDU/adump
$ mkdir -p oradata/ENMOEDU
注意:这里的目录路径,与后面pfile文件中的路径一定要对应,否则后面会报错,比如:
ORA-09925: Unable to create audit trail file
3.生产密码文件
$ cd $ORACLE_HOME/dbs
$ orapwd file=orapwENMOEDU password=oracle entries=30
4.生成实例的pfile参数文件
根据已经由的init.ora内容生成待调整的pfile参数文件
$ df -h
$ cd $ORACLE_HOME/dbs
$ cat init.ora | grep -v ^# | grep -v ^$ > initENMOEDU.ora
将注释和空行去掉,得到参数文件
需要修改的六个参数为:
$ vim initENMOEDU.ora
db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
多次出现的<ORACLE_BASE> 可以用下面的命令替代:
:%s+<ORACLE_BASE>+/u01/app/oracle/g
其他的直接用vim命令修改即可;
注:参数文件中的路径参数要与实际的路径对应;内存大小的设置,需要先通过 df -h 命令确认一下,如果设置过大,会报错:
ORA-00845: MEMORY_TARGET not supported on this system
5.生产spfile参数文件
echo $ORACLE_SID
sqlplus /nolog
conn /as sysdba
sql> create spfile from pfile;
sql> startup nomount;
6.执行创建数据库语句
根据官方文档改写——官方文档参考位置:
Books - Administrator Guide - 2 Create and Configurating an Oracle Database - Step 9:Issue the Create Database Statement
sql> !
$ cd /home/oracle/scripts
$ vim cdb.sh
添加如下内容:
$ cat createdb.sh
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u01/logs/my/redo01a.log','/u02/logs/my/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/logs/my/redo02a.log','/u02/logs/my/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/logs/my/redo03a.log','/u02/logs/my/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
脚本编写好后,执行脚本:
$ exit
SQL> @createdb.sql
Database created.
SQL>
SQL> select instance_name,status from V$instance;
INSTANCE_NAME STATUS
---------------- ------------
ENMOEDU OPEN
该步骤预计会执行2分钟左右,数据库创建完毕后,自动启动到open状态;
7.执行catalog.sql 和 catproc.sql 脚本
Books - Administrator Guide - 2 Create and Configurating an Oracle Database - Step 11:Run Scripts to build Data Dictionary views
执行必选脚本:
sql> !
$ cd /home/oracle/scripts
$ vim 1.sh
添加如下内容:
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
conn /as sysdba
@?/sqlplus/admin/pupbld.sql
EXIT
$ exit
sql> @1.sh
数据字典动态性能视图创建过程:
$ cat cdfixed.sql
$ cat cdcore.sql
8.最后的校验
sql> select * from v$version;
sql> select instance_name,status from v$instance;
实际的创建过程如下:
[root@enmoedu1 ~]# [root@enmoedu1 ~]# echo "CREATE DATABASE by mamual"CREATE DATABASE by mamual[root@enmoedu1 ~]# [root@enmoedu1 ~]# ssh oracle@192.0.2.12oracle@192.0.2.12's password: Last login: Mon Apr 27 16:30:10 2015 from enmoedu1.example.com[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ echo "Step 1: confrate enviroment"Step 1: confrate enviroment[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ cd[oracle@enmoedu2 ~]$ ls Desktop profile_agent profile_emrep profile_oms scripts[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ ls -a. .bash_logout Desktop .emacs .fontconfig .gnome .gstreamer-0.10 .java .nautilus profile_oms .ssh .zshrc.. .bash_profile .dmrc .emcli .gconf .gnome2 .gtkrc-1.2-gnome2 .metacity profile_agent .redhat .Trash.bash_history .bashrc .eggcups .emcli.installations .gconfd .gnome2_private .ICEauthority .mozilla profile_emrep scripts .viminfo[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ ps -ef|grep ora_oracle 4987 4946 0 15:29 pts/1 00:00:00 grep ora_[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ vim .bash_profile # .bash_profile# Get the aliases and functions . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=ENMOEDUexport PATH=$ORACLE_HOME/bin:$PATH~~~~~~~".bash_profile" 17L, 325C written[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ source .bash_profile [oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ echo $ORACLE_BASE/u01/app/oracle[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ echo $ORACLE_SIDENMOEDU[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ echo "Step 2: mkdir directory for database"Step 2: mkdir directory for database[oracle@enmoedu2 ~]$ [oracle@enmoedu2 ~]$ cd $ORACLE_BASE[oracle@enmoedu2 oracle]$ lltotal 28drwxr-x--- 5 oracle oinstall 4096 Apr 27 12:45 admindrwxr-xr-x 7 oracle oinstall 4096 Oct 14 2014 cfgtoollogsdrwxr-xr-x 2 oracle oinstall 4096 Oct 14 2014 checkpointsdrwxrwxr-x 11 oracle oinstall 4096 Oct 14 2014 diagdrwxr-x--- 4 oracle oinstall 4096 Oct 14 2014 fast_recovery_areadrwxr-x--- 5 oracle oinstall 4096 Apr 27 12:45 oradatadrwxr-xr-x 5 oracle oinstall 4096 Oct 14 2014 product[oracle@enmoedu2 oracle]$ [oracle@enmoedu2 oracle]$ cd admin[oracle@enmoedu2 admin]$ lltotal 12drwxr-x--- 5 oracle oinstall 4096 Oct 14 2014 EMREPdrwxr-xr-x 3 oracle oinstall 4096 Apr 27 12:45 ENMOEDUdrwxr-x--- 5 oracle oinstall 4096 Oct 14 2014 PROD4[oracle@enmoedu2 admin]$ rm -fR ENMOEDU/[oracle@enmoedu2 admin]$ [oracle@enmoedu2 admin]$ mkir -p ENOMEDU/admin-bash: mkir: command not found[oracle@enmoedu2 admin]$ [oracle@enmoedu2 admin]$ mkdir -p ENMOEDU/admin[oracle@enmoedu2 admin]$ cd ..[oracle@enmoedu2 oracle]$ pwd/u01/app/oracle[oracle@enmoedu2 oracle]$ lltotal 28drwxr-x--- 5 oracle oinstall 4096 Apr 29 15:32 admindrwxr-xr-x 7 oracle oinstall 4096 Oct 14 2014 cfgtoollogsdrwxr-xr-x 2 oracle oinstall 4096 Oct 14 2014 checkpointsdrwxrwxr-x 11 oracle oinstall 4096 Oct 14 2014 diagdrwxr-x--- 4 oracle oinstall 4096 Oct 14 2014 fast_recovery_areadrwxr-x--- 5 oracle oinstall 4096 Apr 27 12:45 oradatadrwxr-xr-x 5 oracle oinstall 4096 Oct 14 2014 product[oracle@enmoedu2 oracle]$ [oracle@enmoedu2 oracle]$ [oracle@enmoedu2 oracle]$ cd oradata/[oracle@enmoedu2 oradata]$ lltotal 12drwxr-x--- 2 oracle oinstall 4096 Oct 14 2014 EMREPdrwxr-xr-x 2 oracle oinstall 4096 Apr 27 15:31 ENMOEDUdrwxr-x--- 2 oracle oinstall 4096 Oct 18 2014 PROD4[oracle@enmoedu2 oradata]$ [oracle@enmoedu2 oradata]$ rm -fR ENMOEDU/[oracle@enmoedu2 oradata]$ [oracle@enmoedu2 oradata]$ mkdir -p ENMOEDU/[oracle@enmoedu2 oradata]$ [oracle@enmoedu2 oradata]$ lltotal 12drwxr-x--- 2 oracle oinstall 4096 Oct 14 2014 EMREPdrwxr-xr-x 2 oracle oinstall 4096 Apr 29 15:34 ENMOEDUdrwxr-x--- 2 oracle oinstall 4096 Oct 18 2014 PROD4[oracle@enmoedu2 oradata]$ cd ..[oracle@enmoedu2 oracle]$ pwd/u01/app/oracle[oracle@enmoedu2 oracle]$ [oracle@enmoedu2 oracle]$ [oracle@enmoedu2 oracle]$ echo "Step 3: create password file for database"Step 3: create password file for database[oracle@enmoedu2 oracle]$ [oracle@enmoedu2 oracle]$ cd $ORACLE_HOME[oracle@enmoedu2 db_1]$ ll[oracle@enmoedu2 db_1]$ cd dbs/[oracle@enmoedu2 dbs]$ pwd/u01/app/oracle/product/11.2.0/db_1/dbs[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ lshc_EMREP.dat hc_PROD4.dat init.ora lkENMOEDU orapwEMREP orapwPROD4 spfileENMOEDU.orahc_ENMOEDU.dat initENMOEDU.ora lkEMREP lkPROD4 orapwENMOEDU spfileEMREP.ora spfilePROD4.ora[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ rm orapwENMOEDU [oracle@enmoedu2 dbs]$ rm initENMOEDU.ora [oracle@enmoedu2 dbs]$ rm spfileENMOEDU.ora [oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ orapwd file=orapwENMOEDU password='oracle' entries=30[oracle@enmoedu2 dbs]$ lshc_EMREP.dat hc_ENMOEDU.dat hc_PROD4.dat init.ora lkEMREP lkENMOEDU lkPROD4 orapwEMREP orapwENMOEDU orapwPROD4 spfileEMREP.ora spfilePROD4.ora[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ echo " Step 4:create pfile from init.ora" Step 4:create pfile from init.ora[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ lshc_EMREP.dat hc_ENMOEDU.dat hc_PROD4.dat init.ora lkEMREP lkENMOEDU lkPROD4 orapwEMREP orapwENMOEDU orapwPROD4 spfileEMREP.ora spfilePROD4.ora[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ cat init.ora | grep -v ^# | grep -v ^$ > initENMOEDU.ora[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ cat initENMOEDU.ora db_name='ORCL'memory_target=1Gprocesses = 150audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'audit_trail ='db'db_block_size=8192db_domain=''db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'db_recovery_file_dest_size=2Gdiagnostic_dest='<ORACLE_BASE>'dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'open_cursors=300 remote_login_passwordfile='EXCLUSIVE'undo_tablespace='UNDOTBS1'control_files = (ora_control1, ora_control2)compatible ='11.2.0'[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ df -hFilesystem Size Used Avail Use% Mounted on/dev/sda1 433G 25G 385G 7% /tmpfs 1.5G 0 1.5G 0% /dev/shm[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ vim initENMOEDU.ora [oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ echo " Step 5: cteate spfile and startup nomount" Step 5: cteate spfile and startup nomount[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ echo $ORACLE_SIDENMOEDU[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 dbs]$ sqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 29 15:42:52 2015Copyright (c) 1982, 2011, Oracle. All rights reserved.SQL> SQL> conn /as sysdbaConnected to an idle instance.SQL> SQL> create spfile from pfile;File created.SQL> SQL> conn /as sysdbaConnected to an idle instance.SQL> startup nomount;ORACLE instance started.Total System Global Area 836976640 bytesFixed Size 1348160 bytesVariable Size 490737088 bytesDatabase Buffers 339738624 bytesRedo Buffers 5152768 bytesSQL> SQL> [oracle@enmoedu2 dbs]$ cat initENMOEDU.ora [oracle@enmoedu2 scripts]$ cat cdb.sqlCREATE DATABASE mynewdb USER SYS IDENTIFIED BY sys_password USER SYSTEM IDENTIFIED BY system_password LOGFILE GROUP 1 ('/u01/logs/my/redo01a.log','/u02/logs/my/redo01b.log') SIZE 100M BLOCKSIZE 512, GROUP 2 ('/u01/logs/my/redo02a.log','/u02/logs/my/redo02b.log') SIZE 100M BLOCKSIZE 512, GROUP 3 ('/u01/logs/my/redo03a.log','/u02/logs/my/redo03b.log') SIZE 100M BLOCKSIZE 512 MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 CHARACTER SET US7ASCII NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE DEFAULT TABLESPACE users DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf' SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/mynewdb/temp01.dbf' SIZE 20M REUSE UNDO TABLESPACE undotbs DATAFILE '/u01/app/oracle/oradata/mynewdb/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;[oracle@enmoedu2 scripts]$ [oracle@enmoedu2 scripts]$ vim cdb.sql CREATE DATABASE mynewdb USER SYS IDENTIFIED BY sys_password USER SYSTEM IDENTIFIED BY system_password GROUP 3 ('/u01/logs/my/redo03a.log','/u02/logs/my/redo03b.log') SIZE 100M BLOCKSIZE 512 MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 CHARACTER SET US7ASCII NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED SIZE 20M REUSE SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;~~db_name='ENMOEDU'memory_target=1Gprocesses = 150audit_file_dest='/u01/app/oracle/admin/ENMOEDU/adump'audit_trail ='db'db_block_size=8192db_domain=''db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'db_recovery_file_dest_size=2Gdiagnostic_dest='/u01/app/oracle/'dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'open_cursors=300 remote_login_passwordfile='EXCLUSIVE'undo_tablespace='UNDOTBS1'control_files = (/u01/app/oracle/oradata/ENMOEDU/control01.ctl,/u01/app/oracle/oradata/ENMOEDU/control02.ctl)compatible ='11.2.0'[oracle@enmoedu2 dbs]$ [oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ sqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 29 15:58:46 2015Copyright (c) 1982, 2011, Oracle. All rights reserved.SQL> conn /as sysdbaConnected to an idle instance.SQL> startup nomount;ORACLE instance started.Total System Global Area 836976640 bytesFixed Size 1348160 bytesVariable Size 490737088 bytesDatabase Buffers 339738624 bytesRedo Buffers 5152768 bytesSQL> SQL> SQL> ![oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ echo "Step 6 : Crate database"Step 6 : Crate database[oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ cd /home/oracle/scripts/[oracle@enmoedu2 scripts]$ pwd/home/oracle/scripts[oracle@enmoedu2 scripts]$ lltotal 8-rw-r--r-- 1 oracle oinstall 106 Apr 27 15:35 1.sql-rw-r--r-- 1 oracle oinstall 1097 Apr 27 15:20 createdb.sql[oracle@enmoedu2 scripts]$ [oracle@enmoedu2 scripts]$ vim cdb.sql[oracle@enmoedu2 scripts]$ exitexitSQL> SQL> SQL> @/home/oracle/scripts/cdb.sqlDatabase created.SQL> SQL> SQL> ![oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ echo "Step 7 : create dictionaries with scripts"Step 7 : create dictionaries with scripts[oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ exitexitSQL> SQL> ![oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ pwd/u01/app/oracle/admin/ENMOEDU/adump[oracle@enmoedu2 adump]$ lltotal 12-rw-r----- 1 oracle oinstall 732 Apr 29 15:58 ENMOEDU_ora_5813_1.aud-rw-r----- 1 oracle oinstall 766 Apr 29 15:58 ENMOEDU_ora_5813_2.aud-rw-r----- 1 oracle oinstall 772 Apr 29 15:58 ENMOEDU_ora_5893_1.aud[oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ cd /home/oracle/scripts/[oracle@enmoedu2 scripts]$ lltotal 12-rw-r--r-- 1 oracle oinstall 106 Apr 27 15:35 1.sql-rw-r--r-- 1 oracle oinstall 1096 Apr 29 16:05 cdb.sql-rw-r--r-- 1 oracle oinstall 1097 Apr 27 15:20 createdb.sql[oracle@enmoedu2 scripts]$ [oracle@enmoedu2 scripts]$ cat 1.sql @?/rdbms/admin/catalog.sql@?/rdbms/admin/catproc.sqlconn system/oracle@?/sqlplus/admin/pupbld.sqlEXIT[oracle@enmoedu2 scripts]$ [oracle@enmoedu2 scripts]$ [oracle@enmoedu2 scripts]$ exitexitSQL> SQL> SQL> select instance_name,status from V$instance;INSTANCE_NAME STATUS---------------- ------------ENMOEDU OPENSQL> SQL> SQL> SQL> @/home/oralce/scripts/1.sqlSP2-0310: unable to open file "/home/oralce/scripts/1.sql"SQL> SQL> @/home/oracle/scripts/1.sqlDOC>######################################################################DOC>######################################################################DOC> The following statement will cause an "ORA-01722: invalid number"DOC> error and terminate the SQLPLUS session if the user is not SYS.DOC> Disconnect and reconnect with AS SYSDBA.DOC>######################################################################DOC>######################################################################DOC>#no rows selectedSession altered.TIMESTAMP------------------------------------------------------------COMP_TIMESTAMP CATALG_BGN 2015-04-29 16:13:23 2457142 58403Package created.Package body created.Grant succeeded....................................这个是oracle运行自身脚本的过程;时间比较长;中间会报出一些空对象无法删除的错误;不用担心,等待全部运行完毕即可。...................................QL> DROP SYNONYM PRODUCT_USER_PROFILE;DROP SYNONYM PRODUCT_USER_PROFILE *ERROR at line 1:ORA-01434: private synonym to be dropped does not existSQL> CREATE SYNONYM PRODUCT_USER_PROFILE FOR SYSTEM.SQLPLUS_PRODUCT_PROFILE;Synonym created.SQL> DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE;DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE *ERROR at line 1:ORA-01432: public synonym to be dropped does not existSQL> CREATE PUBLIC SYNONYM PRODUCT_USER_PROFILE FOR SYSTEM.PRODUCT_PRIVS;Synonym created.SQL> SQL> -- End of pupbld.sqlSQL> EXITDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ echo "Step 8 : check the new database status"Step 8 : check the new database status[oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ [oracle@enmoedu2 adump]$ sqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 29 16:21:28 2015Copyright (c) 1982, 2011, Oracle. All rights reserved.SQL> conn /as sysdbaConnected.SQL> SQL> SQL> SQL> select instance_name,status from v$instance;INSTANCE_NAME STATUS---------------- ------------ENMOEDU OPENSQL> SQL> SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - ProductionSQL> SQL>
- Oracle 11g 手工创建数据库实验
- oracle 11g手工创建数据库
- 在Linux 上手工创建 oracle 11g R2 数据库
- rhel 6.2 x64 oracle 11g下 手工创建数据库
- Oracle 11g利用Create Database手工创建数据库
- Oracle 10G手工创建数据库
- Oracle 10G手工创建数据库
- Windows Oracle 10G手工创建数据库
- Windows Oracle 10G手工创建数据库
- Windows Oracle 10G手工创建数据库
- Windows Oracle 10G手工创建数据库
- Windows Oracle 10G手工创建数据库
- 记录oracle 10g 手工创建数据库
- Windows Oracle 10G手工创建数据库
- Windows Oracle 10G手工创建数据库
- oracle 10g 创建数据库(手工)
- Linux环境下手工创建Oracle 10g数据库
- 揭开Oracle 10G手工创建数据库的神秘面纱
- 学习Swift,一定不能错过的10大开源项目
- Linux-(13)Linux中的网络连接
- Go语言WebSocket
- 校验文件名后缀是否合法
- 文件路径化简
- Oracle 11g 手工创建数据库实验
- XSS的原理分析与解剖:第四章(编码与绕过)
- ubuntu 12.04 安装Sublime Text
- SVN冲突解决
- iOS子线程更新UI的两种方法
- Memcached技术
- 面试题1(转)
- poj 3667 Hotel(线段树中级,区间合并)
- Qt中forward declaration of struct Ui::xxx的解决