Unable to extend sys.dba_extents Oracle Enterprise
Moderators: chulett, rschirm, roy
Unable to extend sys.dba_extents Oracle Enterprise
Hello,
I am using DS8.0 and for the past couple of days, I am unable to use Oracle Enterprise Stage as it throws this error Unable to extend sys.dba_extents. I used another user id and it throws the error ORA-01017: invalid username/password; logon denied
When I checked from SQL*Plus both these user ids has access to all these tables
DBA_EXTENTS
DBA_DATA_FILES
DBA_TAB_PARTITONS
DBA_TAB_SUBPARTITONS
DBA_OBJECTS
ALL_PART_INDEXES
ALL_PART_TABLES
ALL_INDEXES
The jobs have been working fine till couple of days back and suddenly we are getting this issue, when I spoke to the DBAs and ETL admins nothing has changed from their side, atleast thats what they told me.
When I use DRS stage using the same ids it works fine. Searched the forums couldnt find anything related to this, would appreciate any help in this regard.
Chris
I am using DS8.0 and for the past couple of days, I am unable to use Oracle Enterprise Stage as it throws this error Unable to extend sys.dba_extents. I used another user id and it throws the error ORA-01017: invalid username/password; logon denied
When I checked from SQL*Plus both these user ids has access to all these tables
DBA_EXTENTS
DBA_DATA_FILES
DBA_TAB_PARTITONS
DBA_TAB_SUBPARTITONS
DBA_OBJECTS
ALL_PART_INDEXES
ALL_PART_TABLES
ALL_INDEXES
The jobs have been working fine till couple of days back and suddenly we are getting this issue, when I spoke to the DBAs and ETL admins nothing has changed from their side, atleast thats what they told me.
When I use DRS stage using the same ids it works fine. Searched the forums couldnt find anything related to this, would appreciate any help in this regard.
Chris
Being able to access the DBA_EXTENTS is very different from being able to extend them; this is an Oracle issue that needs to be addressed by your DBA. An alternative if the extents are large enough is to reduce your transaction sizes so that this space does not fill up.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
[quote="chulett"]So now you know what changed, in spite of the DBAs saying nothing had - your user's grants. ...[/quote]
Here is the part which drives us really nuts, when we login to the database using SQL*Plus/Toad using the same id, we have access to all these tables! But when tried from datastage it throws this error!
Here is the part which drives us really nuts, when we login to the database using SQL*Plus/Toad using the same id, we have access to all these tables! But when tried from datastage it throws this error!
I know it sounds crazy, but we did try all that, We double checked all the server parameters, userid, pwd etc. and everything is just fine.
From the ETL Box command line, we were able to connect to the oracle database, but from Datastage it errors out and gives misleading messages.
We are also opening up ticket with IBM.
Chris
From the ETL Box command line, we were able to connect to the oracle database, but from Datastage it errors out and gives misleading messages.
We are also opening up ticket with IBM.
Chris
Re: Unable to extend sys.dba_extents Oracle Enterprise
Find out what changed. Obviously something did.krishobby wrote:The jobs have been working fine till couple of days back and suddenly we are getting this issue
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA