Home » RDBMS Server » Server Utilities » Import error "ORA-01925: maximum of 148 enabled roles exceeded"
Import error "ORA-01925: maximum of 148 enabled roles exceeded" [message #178930] Fri, 23 June 2006 07:40 Go to next message
n_rajasekhar
Messages: 2
Registered: June 2006
Junior Member
Hi,

When i am importing data, i have got the following error and i couldn't complete the import.
The total # of enabled roles for one user is 487.
init.ora file of my database not allowing me to increase the max_enabled_roles more than 148.
============
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by DIMENSION, not by you

import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. importing SYSTEM's objects into SYSTEM
. importing DIMENSION's objects into DIMENSION
. importing SUPPORT's objects into SUPPORT
. importing UPDATESHELFNAME's objects into UPDATESHELFNAME
. importing NDCIF's objects into NDCIF
. importing NDBIF's objects into NDBIF
. importing DIMULL's objects into DIMULL
. importing REC's objects into REC
IMP-00003: ORACLE error 1925 encountered
ORA-01925: maximum of 148 enabled roles exceeded
IMP-00003: ORACLE error 1925 encountered
ORA-01925: maximum of 148 enabled roles exceeded

IMP-00000: Import terminated unsuccessfully
==================================
Please help me how to rectify this error.

Thanks and regards,
N Raja Sekhar.
Re: Import error "ORA-01925: maximum of 148 enabled roles exceeded" [message #178935 is a reply to message #178930] Fri, 23 June 2006 07:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check the value of MAX_ENABLED_ROLES and increase it.
Re: Import error "ORA-01925: maximum of 148 enabled roles exceeded" [message #178943 is a reply to message #178935] Fri, 23 June 2006 08:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Response from private message.
Quote:


Its already set to 148.
But the data dump is having enabled roles 487.
Oracle not allowing me to set max_enabled_roles more than 148.

Do you have any idea?how to tackle it?


Import with roles=n.
Recreate the roles manually later ( you can get a complete description using show=y logfile=somelogfile.lst option. this will not import anything.DDL of objects are dumped into somelogfile.lst)
or
try this first.
Your log says
>>Warning: the objects were exported by DIMENSION, not by you
There is a minor bug in older versions which is supposed to be fixed in 9i.
Try export and import as the SAME DBA USER.
Re: Import error "ORA-01925: maximum of 148 enabled roles exceeded" [message #178947 is a reply to message #178943] Fri, 23 June 2006 09:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

>>Import with roles=n.
That was a mistake. Apologies. There is no such option.
This seems still to be a bug.
If you can afford to export again,
try exporting and importing with the same user.
or
Use user DIMENSION to do the import.
What are you trying to do here?
It seems, all the above schema are 'empty'?

PS:
Please respond here. Private Messaging is for 'whispering'. Not a for technical discussion. What if i gabbled a wrong/incorrect response? (as i did in the previous posting). If the posting are in public, anyone can jump in and correct us. Private messaging breaks usage of a forum.
Re: Import error "ORA-01925: maximum of 148 enabled roles exceeded" [message #178950 is a reply to message #178947] Fri, 23 June 2006 09:40 Go to previous messageGo to next message
n_rajasekhar
Messages: 2
Registered: June 2006
Junior Member
Thanks for your reply.
Infact, i have pasted only few messages, so it looks like, empty.
I also have tried to import as DIMENSION, but still problem persists.
Is there any way i can filter the roles either from export or while importing?
OR Is there any way i can edit the export dump file, delete the roles?

Thanks and Regards,
N Raja Sekhar.
Re: Import error "ORA-01925: maximum of 148 enabled roles exceeded" [message #178967 is a reply to message #178950] Fri, 23 June 2006 11:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Whatever you do, never ever edit the dmp file. You may corrupt it.
Seems there are many circular references in the schema.
The only way i can reproduce your case by Exporting as SYS. Else the export will error about the same (max enabled roles exceded).
Try this.
Export only the schema you want (logged in as sys).
Import to the target database using fromuser/touser option (logged in as sys).
I can successfully import the schema.
So try exporting and import the schemas one-at-a-time.
-- here TEST the schema having around 300 roles granted to it.
oracle@mutation#exp  scott/tiger owner=test

Export: Release 9.2.0.4.0 - Production on Fri Jun 23 12:21:09 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


EXP-00056: ORACLE error 1925 encountered
ORA-01925: maximum of 148 enabled roles exceeded
EXP-00000: Export terminated unsuccessfully


--- export only the required user logged in as SYSDBA
oracle@mutation#exp '"sys/sys as sysdba"' owner=test

Export: Release 9.2.0.4.0 - Production on Fri Jun 23 12:22:02 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Conventional Path ...
. . exporting table                            EMP     458752 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

--import as sysdba

oracle@mutation#imp '"sys/xxxxx@lawd as sysdba"' fromuser=test touser=scott

Import: Release 9.2.0.4.0 - Production on Fri Jun 23 12:28:33 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing TEST's objects into SCOTT
. . importing table                          "EMP"     458752 rows imported
Import terminated successfully without warnings.



Re: Import error "ORA-01925: maximum of 148 enabled roles exceeded" [message #219446 is a reply to message #178967] Wed, 14 February 2007 08:07 Go to previous message
wahdany60
Messages: 17
Registered: April 2006
Junior Member
I ncreae number of max_enabled_roles
Previous Topic: SQL loader to import
Next Topic: need document on export / import transportable TS
Goto Forum:
  


Current Time: Sat Dec 10 09:01:05 CST 2016

Total time taken to generate the page: 0.21026 seconds