UJP - 技術情報

PUPBLD.SQLとPRODUCT_USER_PROFILE

０．改訂履歴

2002.10.11　新規作成

１．はじめに

　このドキュメントでは，SQL*PlusからOracle接続時に表示されるエラーについて解決手順を説明する．

２．エラーを確認する

SQL*Plusで接続してみる．

[oracle@poweredge oracle]$ sqlplus testdbz/testdbz@testdbz

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Oct 11 18:22:22 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SQL>

エラーが表示されている．
これは，セキュリティに関する表が作成されていないために表示される．
解決するには，PRODUCT_USER_PROFILEテーブルを作成すればよい．

３．PRODUCT_USER_PROFILEテーブルを作製する

メッセージにあるとおり，systemユーザで接続する．

SQL> connect system/manager
Connected.
SQL>

pupbld.sqlを実行する．
- Oracle8以前　$ORACLE_HOME/dbs/pupbld.sql
- Oracle8i以降　$ORACLE_HOME/sqlplus/admin/pupbld.sql

SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
drop synonym product_user_profile
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist


  date_value from product_user_profile
                  *
ERROR at line 3:
ORA-00942: table or view does not exist


drop table product_user_profile
           *
ERROR at line 1:
ORA-00942: table or view does not exist


alter table sqlplus_product_profile add (long_value long)
*
ERROR at line 1:
ORA-00942: table or view does not exist



Table created.

drop table product_profile
           *
ERROR at line 1:
ORA-00942: table or view does not exist


drop view product_privs
*
ERROR at line 1:
ORA-00942: table or view does not exist



View created.


Grant succeeded.

drop public synonym product_profile
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



Synonym created.

drop synonym product_user_profile
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist



Synonym created.

drop public synonym product_user_profile
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



Synonym created.

SQL>

再度ユーザで接続してみる．

SQL> connect testdbz/testdbz
Connected.
SQL>

メッセージが出ていない．
一度SQL*Plusを終了する．

SQL> quit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production
[oracle@poweredge oracle]$

再度SQL*Plusで接続してみる．

[oracle@poweredge oracle]$ sqlplus testdbz/testdbz@testdbz

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Oct 11 18:53:32 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SQL>

エラーが表示されなくなった．