ITPub博客

首页 > Linux操作系统 > Linux操作系统 > connection as SYS should be as SYSDBA or SYSOPER).

connection as SYS should be as SYSDBA or SYSOPER).

原创 Linux操作系统 作者:llmarinen 时间:2013-04-15 18:29:39 0 删除 编辑

EMP_EXT.rpt may show an error such as the following:

2009-12-08 13:01:27  GGS ERROR       182  OCI Error beginning
 session (status = 28009-ORA-28009: connection as SYS should be as SYSDBA or SYSOPER).
2009-12-08 13:01:27  GGS ERROR       190  PROCESS ABENDING.
 

This indicates that the Extract process is trying to log on as sys without being the SYSDBA. Simply change the login in the parameter file for the Extract to “system”.

We should note here that specifying SYSDBA at the end of the login line in the Extract parameter file doesn’t work, although it does work with the DBLOGIN command in GGSCI that you will see next.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/27677524/viewspace-758522/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-12-11

  • 博文量
    19
  • 访问量
    59250