Re: Oracle 10g (10.1.0.4), Solaris 8 64-bit import problem.....
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: ian@xxxxxxxxxxxxxxxx
- Date: Wed, 01 Jun 2005 14:12:48 -0400
The UnSeen wrote:
>
>Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 -64bit
>Production With the Partitioning, OLAP and Data Mining options
>ORA-31626: job does not exist
>ORA-31637: cannot create job SYS_IMPORT_FULL_01 for user SYSMAN
>ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
>
>
You need to grant scheduler privileges to SYSMAN
>ORA-06512: at "SYS.KUPV$FT_INT", line 601
>ORA-39080: failed to create queues "" and "" for Data Pump job
>
>
I don't have 10g in the office, so I cannot tell you which privileges
are we talking about, but
privileges are most definitely needed. Also, check if
JOB_QUEUE_PROCESSES is greater then zero.
>Now, I have recently upgraded the Oracle software running on this Solaris
>server from 10.1.0.3 to 10.1.0.4. Has anyone else out there slayed this
>dragon? Are there any Oracle patches or fixes (possibly SQL scripts I'm
>not aware of?) I have searched metalink and found references to
>exporting, not importing. I have opened a TAR for this issue but am
>hoping perhaps someone out there may have seen this issue already.
>
>
That is the beauty of upgrading to the bleeding edge: you get to tread
the path first. In a year, while most of us
will still be padawans, you'll be experienced jedi master. May the farce
be with you, my friend!
--
Mladen Gogala
Oracle DBA
Ext. 121
--
//www.freelists.org/webpage/oracle-l
Other related posts:
