OraFAQ Forum: Backup & Recovery » export geht nicht mehr nach update auf 9.2.0.6

Home » RDBMS Server » Backup & Recovery » export geht nicht mehr nach update auf 9.2.0.6

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

export geht nicht mehr nach update auf 9.2.0.6 [message #174233]

Fri, 26 May 2006 11:58

sam75
Messages: 3
Registered: May 2006

Junior Member

hi,

ich habe bei uns eine oracle DB 9i von 9.2.0.1 nach 9.2.0.6 gepatched.

Ich hatte ein export sctipt fuer das nachts immer aktuelle exports generiert.

Seit dem einspielen, des patches geht das nicht mehr , weil dem sys und system irgendweleche grants fehlen.

Woher kommt das, was ist zu tun ?

Jemand eine idee, danke erstmal

gruss
sam

Report message to a moderator

Re: export geht nicht mehr nach update auf 9.2.0.6 [message #174237 is a reply to message #174233]

Fri, 26 May 2006 12:50

aciolac
Messages: 242
Registered: February 2006

Senior Member

In english, please. There are many peoples in this forum that are not undertand German.

Report message to a moderator

Re: export geht nicht mehr nach update auf 9.2.0.6 [message #174242 is a reply to message #174233]

Fri, 26 May 2006 13:20

sam75
Messages: 3
Registered: May 2006

Junior Member

sorry i seen this too late,

i patched my sql database 9i form 9.2.0.1 to 9.2.0.6

after that .. i have the problem , that i can´t using exp anymore cause got failures ...

exp-00009 with 942 ...

i startet the catexp.sql scipt... but there some grants to new rights.

but some things are also going wrong with failure.

so at the moment don´t know what to do now ...

so which scipt form admin i must start to get all the right grants back or whats to do after installing the patchset ?

greetz
sam

Report message to a moderator

Re: export geht nicht mehr nach update auf 9.2.0.6 [message #174243 is a reply to message #174242]

Fri, 26 May 2006 13:23

aciolac
Messages: 242
Registered: February 2006

Senior Member

Try to make export connecting as SYSTEM to see if the problem are really in grants.

Report message to a moderator

Re: export geht nicht mehr nach update auf 9.2.0.6 [message #174257 is a reply to message #174242]

Fri, 26 May 2006 16:17

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What are you doing with the catexp.sql script?

You said you patched up to 9.2.0.6, did you execute the catpatch.sql script? If so, hopefully you generated a log during this process. Review the log and see if you see any errors. Also, see if you have any INVALID objects in DBA_OBJECTS.

Report message to a moderator

Re: export geht nicht mehr nach update auf 9.2.0.6 [message #174282 is a reply to message #174233]

Sat, 27 May 2006 03:41

sam75
Messages: 3
Registered: May 2006

Junior Member

hi,

catpatch was the problem !! thanks a lot to all who helped the beginner out Wink

thanks a lot ...

bye bye

best regards
sam

Report message to a moderator

Previous Topic:	Explain Rman format
Next Topic:	RMAN implematation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 03:50:06 CDT 2024