Monthly Archives: October 2014


Oracle Platinum Services helps you maximize the availability and performance of Oracle engineered systems with 24/7 remote fault monitoring, industry-leading response times, and patch deployment services—at no additional cost. Maximize Availability and Performance Oracle understands that disruptions in IT systems availability can seriously impact your business. When you choose the extreme performance of an Oracle […]

Oracle 12c Yeni Özellikler – In Database Row Archiving

Oracle 12c “In Database Row Archiving” adıyla anılan yeni bir özelliğe sahiptir. Eski kayıtları silmek yerine bu kayıtları arşiv verisi olarak işaretleyebiliriz. Arşiv verisi olarak işaretlenmiş kayıtlar uygulamalar tarafından görülemeyecek, fakat orijinal halleriyle tablolarda durmaya devam edeceklerdir. Gereklilik durumunda tekrar görülebilir duruma alınmaları da yedekleme-geri yükleme süreçleri olmaksızın daha kolay olacaktır. Ayrıca denetçiler açısından da […]

How can add SYSTEM user to Data Dictionary Realm

Open to Administrator page and click to Realms. Serach Oracle Data Dictonary and click to Edit button. Realm Authorizations in the bottom of the page in the section, click the Create button. Grantee : SYSTEM [USER] Authorization Type: Owner Authorization Rule Set : <Non Selected> When finished, it will look like the following.

How to register a new database with RMAN recovery catalog

Change SID to the database you want to register . oraenv ORACLE_SID Connect to RMAN catalog database rman target / catalog username/password@REG Register database RMAN> register database; example: [oracle@rac2 bin]$ . oraenv ORACLE_SID = [anar] ? anar The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 is /u01/app/oracle [oracle@rac2 bin]$ rman target / catalog test/test@REG; Recovery Manager: Release […]

Connecting to the Oracle Database Using Windows Authentication

Make sure that the sqlnet.ora file on both the client and the server, available under ORACLE_BASE\ORACLE_HOME\network\admin\sqlnet.ora, has the following entry: SQLNET.AUTHENTICATION_SERVICES= (NTS) Connect to the Oracle database as SYSDBA. Create the Windows user as an external user in the Oracle database. Note that the user name must be in upper case. CREATE USER “OPS$<DOMAIN_NAME>\<USER_NAME>” IDENTIFIED […]

How to Force Oracle database shutdown and startup with Unix shell script

Veritabaninin shutdow ve start edilmesi uchun shell script

# #!/bin/ksh # Veritabanin Acilmasi # log file ORACLE_HOME=/data1/oracle/product/ ; export ORACLE_HOME ORACLE_SID=ORCL export ORACLE_SID LOGFILE=/data1/oracle/admin/ORCL/log/operation.log echo echo “” echo “veritabanin Acilmasi…” echo “” $ORACLE_HOME/bin/sqlplus -SILENT /nolog <<EOFrestrict WHENEVER SQLERROR EXIT -2 WHENEVER OSERROR EXIT -2 connect internal startup exit 0 EOFrestrict exit_code=$? if [ $exit_code -eq 0 ]; then echo “” echo “`date`\t$LOGNAME\tVeritabani […]

How to protect your sensitive data using oracle database vault

Delete all data from schema

WITH const AS (SELECT rconst.table_name, rconst.constraint_name FROM user_constraints rconst, user_constraints pconst WHERE rconst.constraint_type = ‘R’ AND rconst.r_constraint_name = pconst.constraint_name AND pconst.constraint_type = ‘P’ ) SELECT ‘ALTER TABLE ‘||const.table_name||’ DISABLE CONSTRAINT ‘||const.constraint_name||’;’ rnme FROM const UNION ALL SELECT ‘TRUNCATE TABLE ‘||ut.table_name||’;’ FROM user_tables ut UNION ALL SELECT ‘ALTER TABLE ‘ ||const.table_name ||’ ENABLE CONSTRAINT ‘ ||const.constraint_name […]

Dropping a Database Using the RMAN clinet in 12c

We are planing to drop a database and want to make sure you drop all the data files, online logs, and control files pertaining to the database. Of course, you can drop a database from SQL*Plus using the drop database 12c command. Solution: use the drop database command to drop a database from the Rman prompt. […]

ORA-38760: This database instance failed to turn on flashback database

Sql> altere database open; alter database open * ERROR at line 1: ORA-38760: This database instance failed to turn on flashback database Solution1: Delete Unneeded files Rman> delete obsolete; Solution2: Increase Space Sql>alter system set db_recovery_file_dest_size=30G; Solution3: Remove Restore Points Sql>select name,storage_size from v$restore_point; NAME Storage_Size —————– ————————– GRP1 0 GRP2 52428800 GRP3 52428800 RP1 […]

Runing SQL commands from within Rman

New in Oracle Database 12c , you can run many SQL commands directly from the Rman command line. Prior to Oracle Dtabase 12c you would have to specify that commnad as shown: In Oracle 11g: bash-3.2$ rman Recovery Manager: Release – Production on Fri Oct 10 14:44:38 2014 Copyright (c) 1982, 2011, Oracle and/or […]

ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML

Cause: DDL operations like creation tables, views etc. and transaction control statements such as commit/rollback cannot be performed inside a query or a DML statement. Action: Ensure that the offending operation is not performed or use autonomous transactions to perform the operation within the query/DML operation.

Oracle OpenWorld 2014

For me it was very interesting and exciting OOW2014