oracle 出现pupbld.sql,Oracle 10g 手工创建ASM数据库

Oracle 10g 手工创建ASM数据库

[日期：2013-01-20]

来源：Linux社区

作者：verrion

[字体：大 中 小]

8，创建erp表空间

SQL> create tablespace erp

2  datafile '+GROUP1/nestling/erp01.dbf' size 100M

3  autoextend on;

Tablespace created.

9，创建数据字典视图

SQL> @?/rdbms/admin/catalog.sql

......

PL/SQL procedure successfully completed.

SQL> @?/rdbms/admin/catproc.sql;

......

PL/SQL procedure successfully completed.

10，建立spfile

SQL> create spfile='+GROUP1/nestling/spfilenestling.ora' from pfile;  <==下次启动Oracle不会使用这个spfile！！

File created.

下面这个做法才是真的！

SQL> create spfile from pfile;  <==不要加参数

File created.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1157627904 bytes

Fixed Size                  1219016 bytes

Variable Size            301991480 bytes

Database Buffers          838860800 bytes

Redo Buffers              15556608 bytes

Database mounted.

Database opened.

SQL> show parameter spfile;

NAME              TYPE        VALUE

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

spfile                string        /opt/oracle/product/10.2.0/db_ 1/dbs/spfilenestling.ora

11，创建数据库用户

SQL> create user erp

2  identified by erp

3  default tablespace erp

4  temporary tablespace temptbs1

5  profile DEFAULT;

User created.

SQL> grant dba to erp;

Grant succeeded.

SQL> conn erp/erp

Error accessing PRODUCT_USER_PROFILE

Warning:  Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM

Connected.

Tips: 出现这个错误提示并不会影响数据库的使用，手动建库一般会有这个警告出现。 PRODUCT_USER_PROFILE是SYSTEM用户的一个表，存储客户端程序执行命令方面的限制信息，可以根据提示用system用户执行脚本来消除：

SQL> conn system/sys

Connected.

SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql;

Synonym created.

SQL> conn erp/erp

Connected.

12，配置网络服务

[oracle@kk admin]$ vi /opt/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

NESTLING =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.254.99)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = nestling)

)

)

[oracle@kk admin]$ lsnrctl start