Tags » 11g

Oracle Database 11g Essentials

1Z0-514 – Oracle Database 11g Essentials

試験番号: 1Z0-514
関連資格: Oracle Database 11g Certified Implementation Specialist (英語のみ) , OPN 認定スペシャリスト(FAQ)
バージョン: Oracle Database 11g
試験時間: 120 minutes… 56 more words

Citrix

Oracle Database Listener.log Analize

Hello,

We are creating a new listener log file from listener.log file.

ErmanTESTDB:/oracle/grid/diag/tnslsnr/ErmanTESTDB/listener/trace#cp listener.log a_listener.log
1. create a new directory for listener.log file.

create directory erman_log_dir as '/oracle/grid/diag/tnslsnr/alioth/listener/trace';

2. 244 more words
Oracle

11g Feature: Fine Grained Dependency Tracking (FGDT)

Hi All!
I was reviewing some features in Oracle and, basically, every single time I review them I find something new. Seems Oracle Databases’ features are near to infinite and we frequently find some that can really add value to our solutions. 125 more words

Database

error creating dbms_rcvcat package body


Problem:

error creating dbms_rcvcat package body


When:

Trying to register 12c database on 11.2 catalog

Solution:

--run on catalog db
grant execute on UTL_HTTP to catalog_user;
grant execute on DBMS_LOB to catalog_user;
grant execute on DBMS_SQL to catalog_user;
alter PACKAGE catalog_user.DBMS_RCVCAT compile body;
ORACLE

Brute forcing the Oracle Password file

If you want to remotely connect to your Oracle instance as sysdba, by default (ie. remote_login_passwordfile=EXCLUSIVE), you will probably use the password file (located in $ORACLE_HOME/dbs) to identify the SYS user. 1,691 more words

Oracle

11g Feature: Fine-Grained Access Control (FGAC) on Network Services

Hi All!
I was reviewing some features in Oracle and, basically, every single time I review them I find something new. Seems Oracle Databases’ features are near to infinite and we frequently find some that can really add value to our solutions. 260 more words

Database

Getting in control with PL/Scope

I’m currently working on a project that involves a system that is basically unknown to me. We also have to make changes (additions) to the system as part of our project. 1,157 more words

Oracle