oracle手工创建数据库

一、准备工作

1\数据库startup，lsnrctl start;

如果没有这一步，dbca过程中会有报错

 

 

2\ dbca创建数据库orcl，并生成数据库创建脚本(在步骤11的界面中选中“创建数据库”、“生成数据库创建脚本”)

3\mkdir –p /home/oracle/app/oracle/admin/shop/scripts

复制/home/oracle/app/oracle/admin/oral/scripts文件，文件清单为

[oracle@vcenteroracle scripts]$ ls

apex.sql cwmlite.sql lockAccount.sql orcl.sql

context.sql emRepository.sql ordinst.sql spatial.sql

CreateDBCatalog.sql init.ora owb.sql xdb_protocol.sql

CreateDBFiles.sql interMedia.sql postDBCreation.sql

CreateDB.sql JServer.sql orcl.sh

此处补充一句，与RAC环境下相比，只少了一个CreateClustDBViews.sql

4\将orcl.sh、orcl.sql改名shop.sh、shop.sql

通过vi将各文件中的orcl替换为shop

5\查看shop.sh，根据提示信息“echo You should Add this entry in the /etc/oratab:shop:/home/oracle/app/oracle/product/11.2.0/db_1:Y”修改/etc/oratab

二、建库进行时

1\. shop.sh

只见那屏幕chua、chua的翻滚，最后

SYS> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS> connect"SYS"/"&&sysPassword" as SYSDBA

Connected to an idle instance.

SYS> startup ;

ORACLE instance started.

Total System Global Area 855982080 bytes

Fixed Size 2233160 bytes

Variable Size 503319736 bytes

Database Buffers 343932928 bytes

Redo Buffers 6496256 bytes

Database mounted.

Database opened.

OK

三、遗留问题

Emca时提示DBSNMP、SYSMAN is locked ，所以SEVERE: Failed to unlock all EM-relatedaccounts

SYS> host/home/oracle/app/oracle/product/11.2.0/db_1/bin/emca-config dbcontrol db -silent -DB_UNIQUE_NAME shop -PORT 1521 -EM_HOME/home/oracle/app/oracle/product/11.2.0/db_1 -LISTENER LISTENER -SERVICE_NAMEshop -SID shop -ORACLE_HOME /home/oracle/app/oracle/product/11.2.0/db_1 -HOSTvcenteroracle -LISTENER_OH /home/oracle/app/oracle/product/11.2.0/db_1-LOG_FILE /home/oracle/app/oracle/admin/shop/scripts/emConfig.log;

STARTED EMCA at Jun 20, 2013 4:33:22 PM

EM Configuration Assistant, Version 11.2.0.3.0Production

Copyright (c) 2003, 2011, Oracle. All rights reserved.

Password for SYS user:

Password for DBSNMP user:

Password for DBSNMP user: Jun 20, 20134:35:33 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

WARNING: ORA-28000: the account is locked

Password for SYSMAN user:

Jun 20, 2013 4:35:47 PMoracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

WARNING: ORA-28000: the account is locked

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................/home/oracle/app/oracle/product/11.2.0/db_1

Local hostname ................vcenteroracle

Listener ORACLE_HOME ................/home/oracle/app/oracle/product/11.2.0/db_1

Listener port number ................ 1521

Database SID ................ shop

Email address for notifications............... null

Outgoing Mail (SMTP) server for notifications............... null

-----------------------------------------------------------------

Jun 20, 2013 4:35:48 PMoracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at/home/oracle/app/oracle/admin/shop/scripts/emConfig.log.

Jun 20, 2013 4:35:58 PMoracle.sysman.emcp.EMReposConfig invoke

SEVERE: Failed to unlock all EM-relatedaccounts

Jun 20, 2013 4:35:58 PMoracle.sysman.emcp.EMConfig perform

SEVERE: Failed to unlock all EM-relatedaccounts

Refer to the log file at /home/oracle/app/oracle/admin/shop/scripts/emConfig.logfor more details.

Could not complete the configuration. Referto the log file at /home/oracle/app/oracle/admin/shop/scripts/emConfig.log formore details.

因先建了orcl库，1158端口em正常，shop的emca下次再谈。

本文来源 我爱IT技术网 http://www.52ij.com/jishu/5049.html 转载请保留链接。