好久没有更新博客了,最近一直很忙,忙于一些机械的事情,所以也懒得来更新了。
今天在使用一个很久没用的库时遇到了一下错误信息:
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
第一反应跑一下PUPBLD.SQL得了,结果在$ORACLE_HOME/RDBMS/ADMIN里愣是没找到...无奈,只好翻书,结果发现这个脚本在$ORACLE_HOME/sqlplus/admin里,汗,原来这个脚本只是为了阻止SQLPLUS错误...
Description from SG:
The script. pupbld.sql, located in directory $ORACLE_HOME/sqlplus/admin, creates the Product User Profile and related procedures. Runnnig this script. among other purposes, prevents a warning message each time a user connects to SQL*Plus. The script. must be as user SYSTEM. ...
sigh...好久没写技术博只更新了这个没有多少技术含量的东西,有点惭愧。不过也算是开个头吧,希望以后能有更多时间好好研究些有技术含量的东西或者遇到些比较有价值的case~~~
Ok, cheers, see you next time:)