Error accessing PRODUCT_USER_PROFILE问题处理

解决Oracle密码修改后登录问题
最新推荐文章于 2023-08-14 17:59:47 发布
最新推荐文章于 2023-08-14 17:59:47 发布
阅读量1.9k 收藏 1
点赞数
CC 4.0 BY-SA版权
分类专栏： Oracle 文章标签： oracle PRODUCT_USER_PROFILE Error accessing 用户登陆
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/royzhang7/article/details/46621147
本文介绍了解决Oracle数据库中修改用户密码后遇到的登录问题。问题出现的原因通常是未执行@$ORACLE_HOME/sqlplus/admin/pupbld.sql脚本。解决方法为使用system用户登录并运行此脚本。

--今天在处理修改密码的时候出现了，如下的问题，经过搜索相关问题，已解决
--原因通常是由于手动建库导致没有执行过@$ORACLE_HOME/sqlplus/admin/pupbld.sql这个脚本导致。
--解决方法报错中也给出了，You may need to run PUPBLD.SQL as SYSTEM
--使用system用户登陆，执行脚本即可

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

--首先登陆数据库，修改用户的密码，然后进行测试connect，报错
[oracle@ilogdbtest ~]$ sqlplus / as sysdba

SQL> alter user qcarilog identified by xxxxxx;

User altered.

SQL> connect qcarilog/xxxxxxx
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> exit

--用system用户登陆，执行脚本
SQL> conn system/system
Connected.
SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql

--再次尝试用该用户登陆，无报错，问题解决
[oracle@ilogdbtest ~]$ sqlplus / as sysdba

SQL> connect qcarilog/xxxxxx
Connected.

Win32 Error Codes(转)
阿荣的技术专栏
11-03 8334
  CodeDescriptionName0The operation completed successfully.ERROR_SUCCESS1Incorrect function.ERROR_INVALID_FUNCTION2The system cannot find the file specified.ERROR
ORA-04031 错误分析及处理方法
Ruishine的博客
03-25 3718
当我们在共享池中试图分配大片的连续内存失败的时候，Oracle首先刷新池中当前没使用的所有对象，使空闲内存块合并。如果仍然没有足够大单个的大块内存满足请求,就会产生ORA-04031 错误。
【问题处理】Error accessing PRODUCT_USER_PROFILE错误一例
cuanchuwei1207的博客
07-22 237
1.问题现象再现1）创建用户secSQL> create user sec identified by sec;User created.2）授权SQL> grant connect,resource to sec;...
Error accessing PRODUCT_USER_PROFILE?
weixin_33697898的博客
12-14 152
有客户发邮件来表示新建user后，尝试使用该user登录时sqlplus会出现如下警告: Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM PRODUCT_USER_PROFILE是...
Error accessing PRODUCT_USER_PROFILE
06-21 228
以普通用户登录SQL*Plus的时候，会碰到下面的错误提示：　　Error accessing PRODUCT_USER_PROFILE　　Warning: Product user profile information no...
手动建库时一个错误：Error accessing PRODUCT_USER_PROFILE
还不算晕的专栏
11-14 3578
首先感谢前辈的文章：http://space.itpub.net/14184018/viewspace-691502 手动创建数据库完成后，创建新用户，并用新用户登陆到数据库时，报错如下： SYS@ bys3>conn bys/bys ERROR: ORA-00942: table or view does not exist Error accessing PRODUCT_US
Flutter 项目中升级 google_mlkit_text_recognition 从0.11.0到 0.15.0，原来页面正常输入信息的输入框，现在只能删除，不能输入，可以调出输入法，就是无法输入信息，也没有任何错误日志出现，可能的原因是什么PS D:\zhuangyunweishi> flutter run -d emulator-5554 Flutter assets will be downloaded from https://storage.flutter-io.cn. Make sure you trust this source! Launching lib\main.dart on sdk gphone64 x86 64 in debug mode... Flutter assets will be downloaded from https://storage.flutter-io.cn. Make sure you trust this source! SourceNodeId()J (unsupported,test-api, reflection, allowed) W/ample.loadguard( 4563): Accessing hidden method Landroid/view/accessibility/AccessibilityRecord;->getSourceNodeId()J (unsupported, reflection, allowed) W/ample.loadguard( 4563): Accessing hidden field Landroid/view/accessibility/AccessibilityNodeInfo;->mChiW/ample.loadguard( 4563): Accessing hidden method Landroid/util/LongArray;->get(I)J (unsupported, reflection, allowed) W/HWUI ( 4563): Unknown dataspace 0 Syncing files to device sdk gphone64 x86 64... 349ms Flutter run key commands. r Hot reload. R Hot restart. h List all available interactive commands. d Detach (terminate "flutter run" but leave application running). c Clear the screen q Quit (terminate the application on the device). A Dart VM Service on sdk gphone64 x86 64 is available at: http://127.0.0.1:59853/CVGpwsWg3j8=/ The Flutter DevTools debugger and profiler on sdk gphone64 x86 64 is available at: http://127.0.0.1:9102?uri=http://127.0.0.1:59853/CVGpwsWg3j8=/ I/Choreographer( 4563): Skipped 61 frames! The application may be doing too much work on its main thread. I/WindowExtensionsImpl( 4563): Initializing Window Extensions, vendor API level=6, activity embedding enabled=true W/HWUI ( 4563): Failed to choose config with EGL_SWAP_BEHAVIOR_PRESERVED, retrying without... W/HWUI ( 4563): Failed to initialize 101010-2 format, error = EGL_SUCCESS I/Gralloc4( 4563): mapper 4.x is not supported I/ample.loadguard( 4563): Compiler allocated 5174KB to compile void android.view.ViewRootImpl.performTraversals() I/ample.loadguard( 4563): Compiler allocated 5417KB to compile void android.view.ViewRootImpl.performTraversals() I/Choreographer( 4563): Skipped 96 frames! The application may be doing too much work on its main thread. D/ProfileInstaller( 4563): Installing profile for com.example.loadguard I/Choreographer( 4563): Skipped 58 frames! The application may be doing too much work on its main thread. D/EGL_emulation( 4563): app_time_stats: avg=72.81ms min=12.28ms max=215.51ms count=13 W/WindowOnBackDispatcher( 4563): sendCancelIfRunning: isInProgress=false callback=io.flutter.embedding.android.FlutterActivity$1@a62fe0a D/EGL_emulation( 4563): app_time_stats: avg=39.17ms min=3.82ms max=387.11ms count=26 D/EGL_emulation( 4563): app_time_stats: avg=100.25ms min=29.67ms max=506.91ms count=10 D/EGL_emulation( 4563): app_time_stats: avg=25.05ms min=7.17ms max=82.55ms count=33 D/EGL_emulation( 4563): app_time_stats: avg=53.35ms min=18.07ms max=178.05ms count=19 W/WindowOnBackDispatcher( 4563): sendCancelIfRunning: isInProgress=false callback=io.flutter.embedding.android.FlutterActivity$1@a62fe0a D/EGL_emulation( 4563): app_time_stats: avg=171.16ms min=11.99ms max=1100.23ms count=11 I/flutter ( 4563): [LOG] _loadPresetData called, template: 平板车 I/flutter ( 4563): [LOG] after _loadPresetData: productCode=LLD-7042, batchNumber=250615F10422, quantity=20 I/flutter ( 4563): [LOG] build: productCode=LLD-7042, batchNumber=250615F10422, quantity=20 D/EGL_emulation( 4563): app_time_stats: avg=104.12ms min=6.13ms max=1251.53ms count=14 W/WindowOnBackDispatcher( 4563): sendCancelIfRunning: isInProgress=false callback=io.flutter.embedding.android.FlutterActivity$1@a62fe0a I/flutter ( 4563): [LOG] _batchNumberController: "250615F10422" I/flutter ( 4563): [LOG] _batchFocusNode.hasFocus: "true" I/flutter ( 4563): [LOG] _batchFocusNode 获得焦点，重置输入法连接 I/flutter ( 4563): [LOG] _batchNumberController: "250615F10422" D/EGL_emulation( 4563): app_time_stats: avg=87.36ms min=5.70ms max=980.71ms count=16 I/ImeTracker( 4563): com.example.loadguard:a4714024: onRequestShow at ORIGIN_CLIENT reason SHOW_SOFT_INPUT fromUser false D/InputMethodManager( 4563): showSoftInput() view=io.flutter.embedding.android.FlutterView{343be5b VFE...... .F....ID 0,0-1344,2992 #1 aid=1073741824} flags=0 reason=SHOW_SOFT_INPUT D/InputConnectionAdaptor( 4563): The input method toggled cursor monitoring on D/InsetsController( 4563): show(ime(), fromIme=true) W/InteractionJankMonitor( 4563): Initializing without READ_DEVICE_CONFIG permission. enabled=false, interval=1, missedFrameThreshold=3, frameTimeThreshold=64, package=com.example.loadguard D/EGL_emulation( 4563): app_time_stats: avg=122.23ms min=9.35ms max=322.95ms count=8 I/ImeTracker( 4563): com.example.loadguard:a4714024: onShown D/EGL_emulation( 4563): app_time_stats: avg=1130.69ms min=2.70ms max=10409.28ms count=10 I/flutter ( 4563): [LOG] _batchNumberController: "250615F1042" I/flutter ( 4563): [LOG] onChanged batchNumber: 250615F1042 I/flutter ( 4563): [LOG] _batchNumberController: "250615F104" I/flutter ( 4563): [LOG] onChanged batchNumber: 250615F104 I/flutter ( 4563): [LOG] _batchNumberController: "250615F10" I/flutter ( 4563): [LOG] onChanged batchNumber: 250615F10 I/flutter ( 4563): [LOG] _batchNumberController: "250615F1" I/flutter ( 4563): [LOG] onChanged batchNumber: 250615F1 D/EGL_emulation( 4563): app_time_stats: avg=89.75ms min=11.73ms max=260.84ms count=11 I/flutter ( 4563): [LOG] _batchNumberController: "250615F" I/flutter ( 4563): [LOG] onChanged batchNumber: 250615F I/flutter ( 4563): [LOG] _batchNumberController: "250615" I/flutter ( 4563): [LOG] onChanged batchNumber: 250615 I/flutter ( 4563): [LOG] _batchNumberController: "25061" I/flutter ( 4563): [LOG] onChanged batchNumber: 25061 I/flutter ( 4563): [LOG] _batchNumberController: "2506" I/flutter ( 4563): [LOG] onChanged batchNumber: 2506 D/EGL_emulation( 4563): app_time_stats: avg=286.45ms min=234.33ms max=332.40ms count=4 I/flutter ( 4563): [LOG] _batchNumberController: "250" I/flutter ( 4563): [LOG] onChanged batchNumber: 250 D/EGL_emulation( 4563): app_time_stats: avg=480.30ms min=474.05ms max=492.52ms count=3 D/EGL_emulation( 4563): app_time_stats: avg=500.04ms min=500.03ms max=500.05ms count=2 D/EGL_emulation( 4563): app_time_stats: avg=500.02ms min=499.29ms max=501.43ms count=3 D/EGL_emulation( 4563): app_time_stats: avg=499.61ms min=499.27ms max=500.01ms count=3 D/EGL_emulation( 4563): app_time_stats: avg=509.42ms min=500.94ms max=517.91ms count=2 I/flutter ( 4563): [LOG] _quantityController: "20" I/flutter ( 4563): [LOG] _batchFocusNode.hasFocus: "false" I/flutter ( 4563): [LOG] _quantityFocusNode.hasFocus: "true" I/flutter ( 4563): [LOG] _quantityFocusNode 获得焦点，重置输入法连接 I/flutter ( 4563): [LOG] _quantityController: "20" I/ImeTracker( 4563): com.example.loadguard:3fa548c6: onRequestShow at ORIGIN_CLIENT reason SHOW_SOFT_INPUT fromUser false D/InputMethodManager( 4563): showSoftInput() view=io.flutter.embedding.android.FlutterView{343be5b VFE...... .F...... 0,0-1344,2992 #1 aid=1073741824} flags=0 reason=SHOW_SOFT_INPUT D/InputConnectionAdaptor( 4563): The input method toggled cursor monitoring on D/InputConnectionAdaptor( 4563): The input method toggled cursor monitoring off D/InputConnectionAdaptor( 4563): The input method toggled cursor monitoring on D/InsetsController( 4563): show(ime(), fromIme=true) I/ImeTracker( 4563): com.example.loadguard:3fa548c6: onCancelled at PHASE_CLIENT_APPLY_ANIMATION D/EGL_emulation( 4563): app_time_stats: avg=132.37ms min=24.18ms max=498.39ms count=10 I/flutter ( 4563): [LOG] _quantityController: "2" I/flutter ( 4563): [LOG] onChanged quantity: 2 I/flutter ( 4563): [LOG] setState in onChanged quantity, value: 2 I/flutter ( 4563): [LOG] build: productCode=LLD-7042, batchNumber=250, quantity=2 D/EGL_emulation( 4563): app_time_stats: avg=118.76ms min=5.83ms max=501.22ms count=11 D/EGL_emulation( 4563): app_time_stats: avg=499.52ms min=499.51ms max=499.54ms count=3 D/EGL_emulation( 4563): app_time_stats: avg=499.96ms min=499.33ms max=500.58ms count=2 D/EGL_emulation( 4563): app_time_stats: avg=500.42ms min=498.21ms max=501.73ms count=3 I/flutter ( 4563): [LOG] _quantityFocusNode.hasFocus: "false" I/ImeTracker( 4563): com.example.loadguard:bb1c0f0b: onRequestHide at ORIGIN_CLIENT reason HIDE_SOFT_INPUT fromUser false D/InsetsController( 4563): hide(ime(), fromIme=true) D/InputConnectionAdaptor( 4563): The input method toggled cursor monitoring off D/EGL_emulation( 4563): app_time_stats: avg=8097.52ms min=16.38ms max=16178.67ms count=2 D/EGL_emulation( 4563): app_time_stats: avg=210.48ms min=22.28ms max=383.62ms count=5 I/ImeTracker( 4563): com.example.loadguard:3160c9a6: onRequestHide at ORIGIN_CLIENT reason HIDE_SOFT_INPUT_ON_ANIMATION_STATE_CHANGED fromUser false I/ImeTracker( 4563): com.example.loadguard:bb1c0f0b: onHidden D/EGL_emulation( 4563): app_time_stats: avg=199.13ms min=29.11ms max=877.45ms count=6 I/flutter ( 4563): [LOG] build: productCode=LLD-7042, batchNumber=250715F10422, quantity=20 W/WindowOnBackDispatcher( 4563): sendCancelIfRunning: isInProgress=false callback=io.flutter.embedding.android.FlutterActivity$1@a62fe0a D/EGL_emulation( 4563): app_time_stats: avg=71.67ms min=6.31ms max=892.22ms count=16 I/flutter ( 4563): [LOG] _batchNumberController: 250715F10422 I/ImeTracker( 4563): com.example.loadguard:64b38682: onRequestShow at ORIGIN_CLIENT reason SHOW_SOFT_INPUT fromUser false D/InputMethodManager( 4563): showSoftInput() view=io.flutter.embedding.android.FlutterView{343be5b VFE...... .F...... 0,0-1344,2992 #1 aid=1073741824} flags=0 reason=SHOW_SOFT_INPUT D/EGL_emulation( 4563): app_time_stats: avg=23.28ms min=2.54ms max=224.42ms count=29 D/InputConnectionAdaptor( 4563): The input method toggled cursor monitoring on D/InsetsController( 4563): show(ime(), fromIme=true) D/EGL_emulation( 4563): app_time_stats: avg=776.08ms min=10.58ms max=3659.82ms count=5 I/ImeTracker( 4563): com.example.loadguard:64b38682: onShown I/flutter ( 4563): [LOG] _batchNumberController: 250715F1042 I/flutter ( 4563): [LOG] onChanged batchNumber: 250715F1042 D/EGL_emulation( 4563): app_time_stats: avg=120.61ms min=16.27ms max=495.79ms count=11 I/flutter ( 4563): [LOG] _batchNumberController: 250715F104 I/flutter ( 4563): [LOG] onChanged batchNumber: 250715F104 I/flutter ( 4563): [LOG] _batchNumberController: 250715F10 I/flutter ( 4563): [LOG] onChanged batchNumber: 250715F10 I/flutter ( 4563): [LOG] _batchNumberController: 250715F1 I/flutter ( 4563): [LOG] onChanged batchNumber: 250715F1 I/flutter ( 4563): [LOG] _batchNumberController: 250715F I/flutter ( 4563): [LOG] onChanged batchNumber: 250715F I/flutter ( 4563): [LOG] _batchNumberController: 250715 I/flutter ( 4563): [LOG] onChanged batchNumber: 250715 I/flutter ( 4563): [LOG] _batchNumberController: 25071 I/flutter ( 4563): [LOG] onChanged batchNumber: 25071 D/EGL_emulation( 4563): app_time_stats: avg=108.70ms min=13.49ms max=248.17ms count=10 I/flutter ( 4563): [LOG] _batchNumberController: 2507 I/flutter ( 4563): [LOG] onChanged batchNumber: 2507 I/flutter ( 4563): [LOG] _batchNumberController: 250 I/flutter ( 4563): [LOG] onChanged batchNumber: 250 D/EGL_emulation( 4563): app_time_stats: avg=358.31ms min=157.83ms max=537.44ms count=4 D/EGL_emulation( 4563): app_time_stats: avg=489.67ms min=460.90ms max=506.42ms count=3 D/EGL_emulation( 4563): app_time_stats: avg=499.17ms min=496.25ms max=502.55ms count=3 D/EGL_emulation( 4563): app_time_stats: avg=498.30ms min=495.33ms max=500.43ms count=3 D/EGL_emulation( 4563): app_time_stats: avg=499.64ms min=497.64ms max=501.15ms count=3 D/EGL_emulation( 4563): app_time_stats: avg=501.02ms min=499.58ms max=502.46ms count=2 D/EGL_emulation( 4563): app_time_stats: avg=499.58ms min=498.45ms max=500.49ms count=3这段日志，在输入框中删除正常，无法输入信息，输入法可以调出，你能看出来问题在哪里吗？
最新发布
07-16
这通常表明输入事件被拦截或处理过程中出现了问题。 可能的原因分析： 1. **插件冲突**：升级后的google_mlkit_text_recognition插件可能引入了某些全局的输入事件监听，拦截了输入事件。特别是如果该插件使用了...
Oracle EBS R12实用配置文件列表
苏南生的优快云博客
11-24 7041
Profile Options in Oracle Application Object Library This section lists each profile option in Oracle Application Object Library. These profile options are grouped into categories based on their fu
halide hexagon
sunshineywz的博客
03-07 1039
#ifndef HALIDE____data___entropy___deps___qcv_halide_plugin___codegen___conv_____________src___op_gen___aarch64___conv3x3_h #define HALIDE____data___entropy___deps___qcv_halide_plugin___codegen___conv_____________src___op_gen___aarch64___conv3x3_h #include
sqlplus 连接scott用户，报错Error accessing PRODUCT_USER_PROFILE
MyOLsun的博客
03-31 641
问题现象再现 1、使用sys开启scott用户 2、登录，报错 SQL> conn scott/tiger； Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM Connected...
oracle数据库user_error,oracle中用户登录出现Error accessing PRODUCT_USER_PROFILE问题的解决方法...
weixin_39937635的博客
04-10 577
在oracle数据库实例中，刚刚创建的用户scott，登录时报告如下错误：sys@CNHTM> conn scott/tigerError accessing PRODUCT_USER_PROFILEWarning: Product user profile information not loaded!You may need to run PUPBLD.SQL as SYSTEMConn...
访问 PRODUCT_USER_PROFILE 时出错 警告: 未加载产品用户概要文件信息!
weixin_33841503的博客
05-04 569
今天在oracle数据库中创建了一个普通 用户，但是在连接的时候报了错了 一般这个错误：一般这个错误都是手工建库的时候忘记做了一步才会报错的SYS@icsdb >conn ics/1q2w3eERROR:ORA-00942: ???????访问 PRODUCT_USER_PROFILE 时出错警告: 未加载产品用户概要文件信息!您需要将 PUPBLD.SQL 作为 SY...
Error accessing PRODUCT_USER_PROFILE解决
cixiaoju8999的博客
05-16 235
[oracle@ocmdb1 ~]$ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 16 12:11:34 2011 Co...
maven报错error while loading ＜root＞, Error accessing
cclovezbf的博客
08-14 838
如果是老道的程序员已经发现这里的不对了。就是如果jar下载成功了不该有lastupdated文件的。删掉这里的全部文件，换个重新配置settings.xml的仓库 重新下。看没有lastupdated文件 ，jar也能正常打开。这个就是你下的jar不对 我们打开目录。
Internal error: Accessing user space memory outside uaccess.h ioctl接口
03-08
好的，我现在需要解决用户提到的内部错误问题，也就是在访问用户空间内存时出现的错误日志：“Internal error: Accessing user space memory outside uaccess.h routines: 9600004f [#1] PREEMPT SMP”，然后系统...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值