Hello (again),
trying to make it easier to figure out what's going since my previous post so her eit is.
I am trying to export users, roles, grants and profiles from a 11.2.0.4 database and I can't figure out what is going wrong. The export errors out. Any idea what I am doing wrong?
My parameter file looks like this:
DIRECTORY=ORAEXP_DIR
DUMPFILE=qkmxpf_metadata_atael.dmp
LOGFILE=qkmxpf_metadata_atael.log
INCLUDE=USER,ROLE,ROLE_GRANT,PROFILE
CONTENT=METADATA_ONLY
SCHEMAS=MAXIMO
The log file has this content:
Export: Release 11.2.0.4.0 - Production on Tue Mar 7 09:07:52 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_SCHEMA_01": "/******** AS SYSDBA" parfile=qkmxpf_metadata.par.atael
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39168: Object path ROLE was not found.
ORA-39168: Object path PROFILE was not found.
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/oraexp/qkmxpf_metadata_atael.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" completed with 2 error(s) at Tue Mar 7 09:07:58 2017 elapsed 0 00:00:04
The DB has profiles:
SQL> select profile,resource_name from dba_profiles;
PROFILE RESOURCE_NAME
------------------------------ --------------------------------
PROFILE_ADMIN PASSWORD_REUSE_MAX
MAXIMO_PROFILE IDLE_TIME
PROFILE_SECURE_NOPASSLIFE PASSWORD_VERIFY_FUNCTION
PROFILE_SECURE PASSWORD_VERIFY_FUNCTION
PROFILE_ADMIN PASSWORD_VERIFY_FUNCTION
PROFILE_SECURE_NOPASSLIFE FAILED_LOGIN_ATTEMPTS
PROFILE_SECURE_NOPASSLIFE PASSWORD_LIFE_TIME
PROFILE_SECURE_NOPASSLIFE PASSWORD_REUSE_TIME
PROFILE_SECURE_NOPASSLIFE PASSWORD_REUSE_MAX
PROFILE_SECURE_NOPASSLIFE PASSWORD_LOCK_TIME
PROFILE_SECURE_NOPASSLIFE PASSWORD_GRACE_TIME
PROFILE_SECURE FAILED_LOGIN_ATTEMPTS
PROFILE_SECURE PASSWORD_LIFE_TIME
PROFILE_SECURE PASSWORD_REUSE_TIME
PROFILE_SECURE PASSWORD_REUSE_MAX
PROFILE_SECURE PASSWORD_LOCK_TIME
PROFILE_SECURE PASSWORD_GRACE_TIME
PROFILE_ADMIN FAILED_LOGIN_ATTEMPTS
PROFILE_ADMIN PASSWORD_LIFE_TIME
PROFILE_ADMIN PASSWORD_REUSE_TIME
PROFILE_ADMIN PASSWORD_LOCK_TIME
MAXIMO_PROFILE COMPOSITE_LIMIT
MAXIMO_PROFILE SESSIONS_PER_USER
MAXIMO_PROFILE CPU_PER_SESSION
MAXIMO_PROFILE CPU_PER_CALL
MAXIMO_PROFILE LOGICAL_READS_PER_SESSION
MAXIMO_PROFILE LOGICAL_READS_PER_CALL
MAXIMO_PROFILE CONNECT_TIME
MAXIMO_PROFILE PRIVATE_SGA
MAXIMO_PROFILE FAILED_LOGIN_ATTEMPTS
MAXIMO_PROFILE PASSWORD_LIFE_TIME
MAXIMO_PROFILE PASSWORD_REUSE_TIME
MAXIMO_PROFILE PASSWORD_REUSE_MAX
MAXIMO_PROFILE PASSWORD_VERIFY_FUNCTION
MAXIMO_PROFILE PASSWORD_LOCK_TIME
MAXIMO_PROFILE PASSWORD_GRACE_TIME
DEFAULT COMPOSITE_LIMIT
DEFAULT SESSIONS_PER_USER
DEFAULT CPU_PER_SESSION
DEFAULT CPU_PER_CALL
DEFAULT LOGICAL_READS_PER_SESSION
DEFAULT LOGICAL_READS_PER_CALL
DEFAULT IDLE_TIME
DEFAULT CONNECT_TIME
DEFAULT PRIVATE_SGA
DEFAULT FAILED_LOGIN_ATTEMPTS
DEFAULT PASSWORD_LIFE_TIME
DEFAULT PASSWORD_REUSE_TIME
DEFAULT PASSWORD_REUSE_MAX
DEFAULT PASSWORD_VERIFY_FUNCTION
DEFAULT PASSWORD_LOCK_TIME
DEFAULT PASSWORD_GRACE_TIME
PROFILE_SECURE_NOPASSLIFE COMPOSITE_LIMIT
PROFILE_SECURE_NOPASSLIFE SESSIONS_PER_USER
PROFILE_SECURE_NOPASSLIFE CPU_PER_SESSION
PROFILE_SECURE_NOPASSLIFE CPU_PER_CALL
PROFILE_SECURE_NOPASSLIFE LOGICAL_READS_PER_SESSION
PROFILE_SECURE_NOPASSLIFE LOGICAL_READS_PER_CALL
PROFILE_SECURE_NOPASSLIFE IDLE_TIME
PROFILE_SECURE_NOPASSLIFE CONNECT_TIME
PROFILE_SECURE_NOPASSLIFE PRIVATE_SGA
PROFILE_SECURE COMPOSITE_LIMIT
PROFILE_SECURE SESSIONS_PER_USER
PROFILE_SECURE CPU_PER_SESSION
PROFILE_SECURE CPU_PER_CALL
PROFILE_SECURE LOGICAL_READS_PER_SESSION
PROFILE_SECURE LOGICAL_READS_PER_CALL
PROFILE_SECURE IDLE_TIME
PROFILE_SECURE CONNECT_TIME
PROFILE_SECURE PRIVATE_SGA
PROFILE_ADMIN COMPOSITE_LIMIT
PROFILE_ADMIN SESSIONS_PER_USER
PROFILE_ADMIN CPU_PER_SESSION
PROFILE_ADMIN CPU_PER_CALL
PROFILE_ADMIN LOGICAL_READS_PER_SESSION
PROFILE_ADMIN LOGICAL_READS_PER_CALL
PROFILE_ADMIN IDLE_TIME
PROFILE_ADMIN CONNECT_TIME
PROFILE_ADMIN PRIVATE_SGA
PROFILE_ADMIN PASSWORD_GRACE_TIME
80 rows selected.
And of course it has roles:
SQL> select role from dba_roles;
ROLE
------------------------------
CONNECT
RESOURCE
DBA
SELECT_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
EXP_FULL_DATABASE
IMP_FULL_DATABASE
RECOVERY_CATALOG_OWNER
GATHER_SYSTEM_STATISTICS
LOGSTDBY_ADMINISTRATOR
AQ_ADMINISTRATOR_ROLE
AQ_USER_ROLE
GLOBAL_AQ_USER_ROLE
SCHEDULER_ADMIN
HS_ADMIN_ROLE
OEM_ADVISOR
OEM_MONITOR
EJBCLIENT
CTXAPP
MONITORER
APPLDEV_ROLE
APPLUSR_ROLE
APPLOWN_ROLE
JAVAUSERPRIV
JAVAIDPRIV
JAVASYSPRIV
JAVADEBUGPRIV
JAVA_ADMIN
JAVA_DEPLOY
BTSINQ_ROLE
BTSUSR_ROLE
DPAINQ_ROLE
DPAUSR_ROLE
MAXIMOINQ_ROLE
MAXIMOUSR_ROLE
XDB_SET_INVOKER
AUTHENTICATEDUSER
XDB_WEBSERVICES
XDB_WEBSERVICES_WITH_PUBLIC
XDB_WEBSERVICES_OVER_HTTP
XDBADMIN
MXINTBTUSR_ROLE
MXINTCAMPINQ_ROLE
MXINTSSISUSR_ROLE
DBFS_ROLE
DATAPUMP_EXP_FULL_DATABASE
DATAPUMP_IMP_FULL_DATABASE
ADM_PARALLEL_EXECUTE_TASK
HS_ADMIN_SELECT_ROLE
HS_ADMIN_EXECUTE_ROLE
MAXINQRY_ROLE
SC_BT_ACCTMGMT_ROLE
MAXCOEUPD_NONPROD_ROLE
54 rows selected.
Thanks
Andy
1* select profile,resource_name from dba_profilesSQL> /
PROFILE RESOURCE_NAME------------------------------ --------------------------------PROFILE_ADMIN PASSWORD_REUSE_MAXMAXIMO_PROFILE IDLE_TIMEPROFILE_SECURE_NOPASSLIFE PASSWORD_VERIFY_FUNCTIONPROFILE_SECURE PASSWORD_VERIFY_FUNCTIONPROFILE_ADMIN PASSWORD_VERIFY_FUNCTIONPROFILE_SECURE_NOPASSLIFE FAILED_LOGIN_ATTEMPTSPROFILE_SECURE_NOPASSLIFE PASSWORD_LIFE_TIMEPROFILE_SECURE_NOPASSLIFE PASSWORD_REUSE_TIMEPROFILE_SECURE_NOPASSLIFE PASSWORD_REUSE_MAXPROFILE_SECURE_NOPASSLIFE PASSWORD_LOCK_TIMEPROFILE_SECURE_NOPASSLIFE PASSWORD_GRACE_TIME
PROFILE RESOURCE_NAME------------------------------ --------------------------------PROFILE_SECURE FAILED_LOGIN_ATTEMPTSPROFILE_SECURE PASSWORD_LIFE_TIMEPROFILE_SECURE PASSWORD_REUSE_TIMEPROFILE_SECURE PASSWORD_REUSE_MAXPROFILE_SECURE PASSWORD_LOCK_TIMEPROFILE_SECURE PASSWORD_GRACE_TIMEPROFILE_ADMIN FAILED_LOGIN_ATTEMPTSPROFILE_ADMIN PASSWORD_LIFE_TIMEPROFILE_ADMIN PASSWORD_REUSE_TIMEPROFILE_ADMIN PASSWORD_LOCK_TIMEMAXIMO_PROFILE COMPOSITE_LIMIT
PROFILE RESOURCE_NAME------------------------------ --------------------------------MAXIMO_PROFILE SESSIONS_PER_USERMAXIMO_PROFILE CPU_PER_SESSIONMAXIMO_PROFILE CPU_PER_CALLMAXIMO_PROFILE LOGICAL_READS_PER_SESSIONMAXIMO_PROFILE LOGICAL_READS_PER_CALLMAXIMO_PROFILE CONNECT_TIMEMAXIMO_PROFILE PRIVATE_SGAMAXIMO_PROFILE FAILED_LOGIN_ATTEMPTSMAXIMO_PROFILE PASSWORD_LIFE_TIMEMAXIMO_PROFILE PASSWORD_REUSE_TIMEMAXIMO_PROFILE PASSWORD_REUSE_MAX
PROFILE RESOURCE_NAME------------------------------ --------------------------------MAXIMO_PROFILE PASSWORD_VERIFY_FUNCTIONMAXIMO_PROFILE PASSWORD_LOCK_TIMEMAXIMO_PROFILE PASSWORD_GRACE_TIMEDEFAULT COMPOSITE_LIMITDEFAULT SESSIONS_PER_USERDEFAULT CPU_PER_SESSIONDEFAULT CPU_PER_CALLDEFAULT LOGICAL_READS_PER_SESSIONDEFAULT LOGICAL_READS_PER_CALLDEFAULT IDLE_TIMEDEFAULT CONNECT_TIME
PROFILE RESOURCE_NAME------------------------------ --------------------------------DEFAULT PRIVATE_SGADEFAULT FAILED_LOGIN_ATTEMPTSDEFAULT PASSWORD_LIFE_TIMEDEFAULT PASSWORD_REUSE_TIMEDEFAULT PASSWORD_REUSE_MAXDEFAULT PASSWORD_VERIFY_FUNCTIONDEFAULT PASSWORD_LOCK_TIMEDEFAULT PASSWORD_GRACE_TIMEPROFILE_SECURE_NOPASSLIFE COMPOSITE_LIMITPROFILE_SECURE_NOPASSLIFE SESSIONS_PER_USERPROFILE_SECURE_NOPASSLIFE CPU_PER_SESSION
PROFILE RESOURCE_NAME------------------------------ --------------------------------PROFILE_SECURE_NOPASSLIFE CPU_PER_CALLPROFILE_SECURE_NOPASSLIFE LOGICAL_READS_PER_SESSIONPROFILE_SECURE_NOPASSLIFE LOGICAL_READS_PER_CALLPROFILE_SECURE_NOPASSLIFE IDLE_TIMEPROFILE_SECURE_NOPASSLIFE CONNECT_TIMEPROFILE_SECURE_NOPASSLIFE PRIVATE_SGAPROFILE_SECURE COMPOSITE_LIMITPROFILE_SECURE SESSIONS_PER_USERPROFILE_SECURE CPU_PER_SESSIONPROFILE_SECURE CPU_PER_CALLPROFILE_SECURE LOGICAL_READS_PER_SESSION
PROFILE RESOURCE_NAME------------------------------ --------------------------------PROFILE_SECURE LOGICAL_READS_PER_CALLPROFILE_SECURE IDLE_TIMEPROFILE_SECURE CONNECT_TIMEPROFILE_SECURE PRIVATE_SGAPROFILE_ADMIN COMPOSITE_LIMITPROFILE_ADMIN SESSIONS_PER_USERPROFILE_ADMIN CPU_PER_SESSIONPROFILE_ADMIN CPU_PER_CALLPROFILE_ADMIN LOGICAL_READS_PER_SESSIONPROFILE_ADMIN LOGICAL_READS_PER_CALLPROFILE_ADMIN IDLE_TIME
PROFILE RESOURCE_NAME------------------------------ --------------------------------PROFILE_ADMIN CONNECT_TIMEPROFILE_ADMIN PRIVATE_SGAPROFILE_ADMIN PASSWORD_GRACE_TIME