Here are the steps that were taken to create a full backup of the Oracle Identity Manager 10g (9.0.1.2) database.
Tablespace Name
To determine the name of the tablespace, try executing the following select command:
select TABLESPACE_NAME, STATUS, CONTENTS from dba_tablespaces order by TABLESPACE_NAME;
[oracle@localhost /]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 30 14:10:13 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select TABLESPACE_NAME, STATUS, CONTENTS from dba_tablespaces order by TABLESPACE_NAME;
TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
DEV1_IAS_OPSS ONLINE PERMANENT
DEV1_IAS_ORASDPM ONLINE PERMANENT
DEV1_IAS_TEMP ONLINE TEMPORARY
DEV1_MDS ONLINE PERMANENT
DEV1_OIM ONLINE PERMANENT
DEV1_OIM_LOB ONLINE PERMANENT
DEV1_OIM_TEMP ONLINE TEMPORARY
DEV1_SOAINFRA ONLINE PERMANENT
DEV_APM ONLINE PERMANENT
DEV_APM_TEMP ONLINE TEMPORARY
DEV_IAS_TEMP ONLINE TEMPORARY
TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
DEV_IAS_WIKI ONLINE PERMANENT
DEV_OCSERVER ONLINE PERMANENT
DEV_OCSERVER_TEMP ONLINE TEMPORARY
DEV_ORAESS ONLINE PERMANENT
EXAMPLE ONLINE PERMANENT
IAS_TEMP ONLINE TEMPORARY
OIMTS01 ONLINE PERMANENT
OLTS_SVRMGSTORE ONLINE PERMANENT
RBACX ONLINE PERMANENT
SYSAUX ONLINE PERMANENT
SYSTEM ONLINE PERMANENT
TEMP ONLINE TEMPORARY
UNDOTBS1 ONLINE UNDO
USERS ONLINE PERMANENT
25 rows selected.
EXP Command
I am using the system administrator for OIM to execute the 'exp' command, which is an Oracle DB functionality to retrieve exports (imp is similar, though does imports). Replace the user credentials, the tablespace name and the paths for the DB dump and log files and you're ready to go!
exp xelsysadm/Password1 tablespaces=OIMTS01 file=/expTEST1.dmp log=tbsTEST1.log
[oracle@localhost /]$ exp xelsysadm/Password1 tablespaces=OIMTS01 file=/Vanilla9.1.0.2db.dmp log=Vanilla9.1.0.2db.log
Export: Release 11.2.0.1.0 - Production on Thu Aug 30 14:22:39 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
EXP-00023: must be a DBA to do Full Database or Tablespace export
(2)U(sers), or (3)T(ables): (2)U >
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export selected tablespaces ...
. exporting referential integrity constraints
. exporting triggers
Export terminated successfully with warnings.
[oracle@localhost /]$ ls -la Vani*
-rw-r--r-- 1 oracle dba 2269184 Aug 30 13:51 Vanilla9.1.0.2db.dmp
-rw-r--r-- 1 oracle dba 15900 Aug 30 13:51 Vanilla9.1.0.2db.log
About the author
Daniel is a Technical Manager with over 10 years of consulting expertise in the Identity and Access Management space.Daniel has built from scratch this blog as well as technicalconfessions.com
Follow Daniel on twitter @nervouswiggles
Comments
Other Posts
AS I was migrating my environment into an S3 environment, I wanted to leverage off the SES services that AWS provide, more specifically, to leverage the off the SMTP functionality by sending an email via PHP
Read More...
The WeMos D1 is a ESP8266 WiFi based board is an extension to the current out-of-the-box library that comes with the Arduino installation. Because of this, you need to import in the libraries as well as acknowledging the specific board. This process is highly confusion with a number of different individuals talking about a number of different ways to integrate.
Read More...
NameID element must be present as part of the Subject in the Response message, please enable it in the IDP configuration.
Read More...
For what I see, there's not too many supportive documentations out there that will demonstrate how provision AD group membership with the ICF connector using OpenIDM. The use of the special ldapGroups attribute is not explained anywhere in the Integrators guides to to the date of this blog. This quick blog identifies the tasks required to provision AD group membership from OpenIDM to AD using the LDAP ICF connector. However this doesn't really explain what ldapGroups actually does and there's no real worked example of how to go from an Assignment to ldapGroups to an assigned group in AD. I wrote up a wiki article for my own reference: AD group memberships automatically to users This is just my view, others may disagree, but I think the implementation experience could be improved with some more documentation and a more detailed example here.
Read More...
In the past, the similar error occurred though for the Oracle Identity Management solution. invalidcredentialexception remote framework key is invalid Because they all share the ICF connector framework, the error/solution would be the same.
Read More...
org.forgerock.script.exception.ScriptCompilationException: missing ; before statement
Read More...
ForgeRock IDM - org.forgerock.script.exception.ScriptCompilationException: missing ; before statement
Read More...
When performing the attempt of a reconciliation from ForgeRock IDM to Active Directory, I would get the following error
Read More...
In the past, the similar error occurred though for the Oracle Identity Management solution. invalidcredentialexception remote framework key is invalid Because they all share the ICF connector framework, the error/solution would be the same.
Read More...
During the reconcilation from OpenIDM to the ICF google apps connector, the following error response would occur. ERROR Caused by com.google.api.client.auth.oauth2.TokenResponseException 400 Bad Request - invalid_grant
Read More...
Tags
Recent Posts
Monthly Activity
Group by date