oracle 12c how to check with db you’re ?

select
decode(sys_context(‘USERENV’, ‘CON_NAME’),’CDB$ROOT’,sys_context(‘USERENV’, ‘DB_NAME’),sys_context(‘USERENV’, ‘CON_NAME’)) DB_NAME, decode(sys_context(‘USERENV’,’CON_ID’),1,’CDB’,’PDB’) TYPE from DUAL;

Advertisements

Oracle Identity and Access Management 12c Released

Oracle has released it latest OIM,OAM,OID and OUD Stacks.

Oracle Access Manager Access SDK 12c (12.2.1.3.0)
Oracle Identity and Access Management 12c (12.2.1.3.0)
Oracle Internet Directory 12c (12.2.1.3.0)
Oracle WebLogic Server 12c (12.2.1.3.0)
Oracle Unified Directory 12c (12.2.1.3.0)
Oracle Fusion Middleware Infrastructure 12c (12.2.1.3.0)
Oracle Fusion Middleware WebLogic Server Plug-In 12c (12.2.1.3.0)

How to download 12c Softwares, you need to have access to oracle support site :

http://docs.oracle.com/cd/E23104_01/download_readme_12213/download_readme_12213.htm#CHDJGDIB

OID – Sample LDIF

$ cat firstrun.ldif
dn:dc=com
objectclass: top
objectclass: domain
dc:com

dn:dc=oracle,dc=com
objectclass: top
objectclass: domain
dc:oracle

dn:dc=us,dc=oracle,dc=com
objectclass: top
objectclass: domain
dc:us

dn:cn=Users,dc=us,dc=oracle,dc=com
objectclass: top
objectclass: orclContainer
cn:Users

dn: cn=oiduser1,cn=users,dc=us,dc=oracle,dc=com
description: test user
sn: snoiduser1
uid: uidoiduser1
objectclass: top
objectclass: inetorgperson
objectclass: orcluser
objectclass: orcluserv2
cn: oiduser1
userpassword: welcome1

dn: cn=oiduser2,cn=users,dc=us,dc=oracle,dc=com
description: test user
sn: snoiduser2
uid: uidoiduser2
objectclass: top
objectclass: inetorgperson
objectclass: orcluser
objectclass: orcluserv2
cn: oiduser2

Enabling Database 12c in write mode

SQL> select name, open_mode from v$pdbs;

NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
PDBORCL MOUNTED

SQL> alter pluggable database PDBORCL open;

Pluggable database altered.

SQL> select name, open_mode from v$pdbs;

NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
PDBORCL READ WRITE

#.

> alter system set session_cached_cursors=100 scope=spfile;
> alter system set processes=500 scope=spfile;
> shutdown immediate;
> startup;
> alter system set aq_tm_processes=1 scope=both;
> alter system set open_cursors=800 scope=both;

RCU OID Silent Creation

# RCU Silent for creating OID Schema

# Pre-requisite:

SQL> GRANT EXECUTE ON sys.dbms_job TO PUBLIC;
SQL> GRANT EXECUTE ON dbms_reputil TO PUBLIC;

$ /scratch/binaries/rcu/rcu_11.1.2.1.0/rcuHome/bin/rcu -silent -createRepository -databaseType ORACLE -connectString localhost:1521:orcl1 -dbUser SYS -dbRole SYSDBA -component OID -f < ~/passwordfile.txt

$ cat passwordfile.txt
Welcome1
Welcome1

$ /scratch/binaries/rcu/rcu_11.1.2.1.0/rcuHome/bin/rcu -silent -dropRepository -databaseType ORACLE -connectString localhost:1521:orcl1 -dbUser SYS -dbRole SYSDBA -component OID -f < ~/passwordfile.txt