Tags » Oracle

Grid Infrastructure 12.2.0.1 CRS_SWONLY Silent Install

Configuring Software Binaries for Oracle Grid Infrastructure for a Standalone Server

CREATE DIRECTORIES:

# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),994(vboxsf)

# mkdir /u01
# chmod 775 /u01/
# chown oracle:oinstall /u01/

# vi /etc/oraInst.loc
# chown oracle:oinstall /etc/oraInst.loc

# cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall

# ll /etc/oraInst.loc
-rw-r--r-- 1 oracle oinstall 56 Sep 23 17:11 /etc/oraInst.loc
# exit

$ mkdir -p /u01/app/12.2.0.1/grid
$ mkdir -p /u01/app/grid
$ mkdir -p /u01/app/oraInventory
…
1,799 more words
Oracle

Masking Data according to User roles in Oracle Database with Data Redaction

At this note I will show to you how you can mask data according to the role of users by using Data Redaction. Actually I will not explain Data Redaction in detail , I assume that you already know about Data Redaction. 283 more words

Oracle

Bad Practice from Oracle - datapatch

Not too long ago, I discovered:
dbca does hard coding

Now it gets even worse.

Create TEST environment.

SOURCE ORACLE_HOME:/u01/app/oracle/product/12.1.0/db_1
TARGET ORACLE_HOME:/u01/app/oracle/product/12.1.0/db

DB was cloned from Source to Target. 128 more words

Oracle

Call for papers Jfokus open until September 30th 2017

Propose presentation

Here you can propose a presentation for Jfokus. Please read these instructions before posting a proposal.

University day, Monday 5 February
University consists of half day sessions (3,5 hours incl breaks) … 258 more words

Opn

Troubleshoot Oracle database

Problem:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Solve:
Enter user-name: sys as sysdba… 74 more words

Database

My Personal Reading and Shadow Work

Not all is fun and games in women’s retreats and oracle readings. In this video, I discuss why self-shadow work is necessary for relationships to work. 106 more words

Oracle