oracle adg报错ORA-17628: Oracle error 19505 returned by remote Oracle server

 admin   2024-04-28 11:06   150 人阅读  0 条评论

原因是因为静态参数写错了,用的之前搭建的参数直接复制的,改漏了

改过来,重新生成动态参数就好了

SQL> startup pfile='/u01/app/oracle/product/11.2.0/db/dbs/initadg.ora' nomount;
ORACLE instance started.

Total System Global Area 3156725760 bytes
Fixed Size            2257392 bytes
Variable Size         1157631504 bytes
Database Buffers     1979711488 bytes
Redo Buffers           17125376 bytes
SQL> create spfile='/u01/app/oracle/product/11.2.0/db/dbs/spfileadg.ora' from pfile='/u01/app/oracle/product/11.2.0/db/dbs/initadg.ora';

File created.

SQL> show parameter control_files

NAME                     TYPE
------------------------------------ ----------------------
VALUE
------------------------------
control_files                 string
/u01/app/oracle/oradata/adg/co
ntrol01.ctl

本文地址:https://liuchunjie.top/?id=719
版权声明:本文为原创文章,版权归 admin 所有,欢迎分享本文,转载请保留出处!

 发表评论


表情

还没有留言,还不快点抢沙发?