Saturday, November 9, 2013

Flat File Connector: Creating IT Resource Type

This guide demonstrates how to create an IT resource type. The flat file connector provided by Oracle is used as an example.

IT resource types are templates for the IT resource definitions that reference them. After defining an IT resource type, you will be able to create an instance of an IT resource of the new type.

Wednesday, November 6, 2013

ls Command: List Contents of Directory

Summary
The ls command list all files in a directory. This command is used often when navigating through your file system through the terminal.

SYNOPSIS
ls [OPTION] [FILE]

When you invoke the command with no arguments, the files in the current directory is listed.

Options
Given here are common options used often. You can combine options together.
-a    List all entries. For example, files that begin with a period (.) are listed.

-l    List in long format.
      1st column: File Type and file permissions for users, group, and others.
      2nd column: Number of links
      3rd column: File owner
      4th column: Group owner
      5th column: File size
      6th column: Last modification date
      7th column: Name of file
      Example: -rw-rw-r--  1  oracle  oracle  6880  Oct 21 23:10  README

-h   Print file sizes in human readable format (e.g. 8.3M, 1.1K, etc)

-R   Recursively list sub-directories encountered.

-F   Appends a character  revealing the nature of a file.
      Regular files have no suffix. 
      *   executable file
      @  symbolic link
      /   directory
      =  sockets

-t   Sort by time modified. Latest first.

-i   Print the i-number

-u   Use time of last access instead of last modification.

-1   Force one-entry-per-line output format.

Sunday, November 3, 2013

Oracle DB: Get All the Foriegn Keys References on a Specific Column

At times it is useful to know all the foreign keys of a specific table column. The query provided here will give you the table name that has the foreign key, the name of the foreign key constraint, the table and column the foreign key reference to. Change the value for ucc.column_name to the column name you want all the foreign key references of.

SELECT
   uc.table_name as foreign_table,
   uc.constraint_name as foreign_constaint_name,
   ucc.table_name,
   uc.r_constraint_name,
   ucc.column_name
FROM
   user_constraints uc,
   user_cons_columns ucc
WHERE
   uc.r_constraint_name = ucc.constraint_name AND
   uc.constraint_type = 'R' AND
   ucc.column_name = 'USR_KEY';

Thursday, October 17, 2013

Enable OpenLDAP Logs

Summary: This posts demonstrates how to enable logging for OpenLDAP. Click here for more information about the log levels. The example here sets the log level to 256, which log connections, operations, and results.

Thursday, October 10, 2013

How Give a User sudo Power?

This post demonstrates how to add a user to the sudoers list on a Linux Operating System.

1. Open a terminal and login as the root user.
su root

2.Open  the "/etc/sudoers" file or execute "visudo".
vi /etc/sudoers
visudo #The same as the command above

3. Add a new line below the root user.
Format: <username> ALL=(ALL)       ALL
## Next comes the main part: which users can run what software on
## which machines (the sudoers file can be shared between multiple
## systems).
## Syntax:
##
##      user    MACHINE=COMMANDS
##
## The COMMANDS section may have other options added to it.
##
## Allow root to run any commands anywhere
root    ALL=(ALL)       ALL
oracle ALL=(ALL) ALL

4. Save the file. Now your user should have root privileges.
sudo [command]

Tuesday, September 10, 2013

Set a Process Task to Trigger off Another

Version: Oracle Identity Manager 11g
Description: This post provides an example to trigger a process task off another process task. All changes are done through OIM Design Console. For a process task, you are able to assign dependent tasks and preceding tasks. Preceding tasks must have a completed status before the current process is triggered. Dependent tasks are triggered when the current process has a completed status.

Tuesday, August 6, 2013

Installing and Configuring a Java Connector Server

Original Instructions: https://wikis.oracle.com/display/IdentityConnectors/Connector+Servers#ConnectorServers-
Description: A connector server is required when a connector bundle is not directly executed within your application. By using one or more connector servers, the connector architecture permits your application to communicate with externally deployed bundles.