tag:blogger.com,1999:blog-56110591761055740262024-02-08T09:29:11.797+04:00Teymur Hajiyev's Oracle blogProblems are there to be solved!Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.comBlogger34125tag:blogger.com,1999:blog-5611059176105574026.post-16335460837073596202014-04-25T22:33:00.001+05:002014-04-25T22:54:29.939+05:00Patching Oracle Exadata (Quarterly Full Stack Jan 2014 - 11.2.0.3.0): 17816100Patching Exadata is divided into 3 categories:
Storage Server Patch
Database Server Patch
Infiniband Switches Patch
I will write all the steps and explain why and how.
Critical NOTE: Before starting [patching, it is highly recommended to restart all Storage Servers and DB Nodes. Why? Because, during patching they will automatically restarted and if the restart is not successful, then you will Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0tag:blogger.com,1999:blog-5611059176105574026.post-48824954248301228552014-04-23T22:25:00.000+05:002014-04-23T22:34:50.493+05:00Never hurry up for telling "It is a BUG in Oracle"!Today I was upgrading(software of all of components, except DB and GI) Exadata X2 to new version. First I did standby site, so we had to simulate some tests to be sure everything is OK as expected.
One of them was to create a new tablespace at primary site (which is in older version) and check if media recovery adds a new datafile at standby site. We are using Oracle Managed Files.
Statement Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0tag:blogger.com,1999:blog-5611059176105574026.post-1672298882750214942014-02-10T16:28:00.000+04:002014-02-10T16:32:15.435+04:00Oracle Database 12c: What happens during CDB startup if one the PDB has a media problem?During Oracle Day 2014, which held in Baku/Azerbaijan, my friend Mahir Quluzade told me that, according his test if there is media problem in one of the PDB and if we want to startup CDB, CDB will not start and it is completely NOT possible to start!
Interesting, although I did not tested, I was sure it is by design and there should be workaround.
Ok, I got free time today and tested:
SQL> Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com3tag:blogger.com,1999:blog-5611059176105574026.post-70070364758275708922013-07-24T13:30:00.002+05:002013-07-24T13:30:45.901+05:00Oracle 12 High Availability New Features Series: 1 - Partial Global/Local IndexesSince its first introduction in Oracle 8.0 in 1997, Oracle has enhanced the functionality of Oracle
Partitioning with every release, by either adding new partitioning techniques, enhancing the scalability,
or extending the manageability and maintenance capabilities. Oracle Database 12c is no different by
offering enhanced composite partitioning strategies and vastly enhanced partition maintenanceTeymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0tag:blogger.com,1999:blog-5611059176105574026.post-55296660890444396692013-01-18T12:19:00.002+04:002013-01-18T12:22:05.623+04:00EXADATA Certified Implementation Specialist...
Today, I have passed 1Z0-536 Oracle Exadata 11g Essentials.It means, I I have one more Oracle Certification Program status – Oracle Exadata 11g Certified Implementation Specialist!
My passing score was 86%.
Tips about exam:
Total 69 questions, passing score is 67%
I would say, exam is highly based on official preparation course – Exadata and Database Machine Administration WorkshopTeymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com3tag:blogger.com,1999:blog-5611059176105574026.post-88261880277632383812012-06-01T11:55:00.001+05:002012-06-01T11:55:07.040+05:00Oracle 11g: SecureFiles
Starting from Oracle 11g, there is a new feature which is called SecureFiles. Although it is very useful feature, less people is aware about it or implemented it. I don't know why ;)
SecureFiles is a completely new architecture inside the Oracle Database 11g for handling file or unstructured data – word, pdf, image, video and etc. Traditionally, we stored unstructured Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com1tag:blogger.com,1999:blog-5611059176105574026.post-71192480440355381142011-05-05T13:51:00.004+05:002011-05-17T15:16:25.120+05:00ORACLE Database Firewall Oracle Database Firewall provides a Next Generation technology for securing and protecting data in databases. Database Firewall uses a very different approach, which offers greater levels of automation, simplicity and security than traditionally data security software vendors. The core technology interprets the grammar of SQL and works by analyzing the meaning of the Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com1tag:blogger.com,1999:blog-5611059176105574026.post-85228248229572949182011-02-02T10:10:00.002+04:002011-02-02T10:15:36.072+04:00Oracle 11g: Easy way getting current session's trace file nameAs you know, sometimes we need to trace session, in order to troubleshoot application performance and etc. Tracing session generates server side file with name as: InstanceName_ora_SessionProcessID.trc.
To get these values and location of trace file, especially Process_ID, we had to join v$process with v$session.
However, in Oracle 11g, now it is possible to get current session's trace file Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0tag:blogger.com,1999:blog-5611059176105574026.post-56501616717552559832010-12-10T16:47:00.001+04:002010-12-10T16:53:23.803+04:00Oracle 11g new feature: new data dictionary view for listing users with default password - DBA_USERS_WITH_DEFPWDAs you know, after creation of new database, there will be some DB users whose password should be changed because of security issues.
Before 11g, we had to read documentation and check which users are in this list.
However, starting from 11g, we can easily find out that user - using DBA_USERS_WITH_DEFPWD
SQL> desc DBA_USERS_WITH_DEFPWD
Name Null? Type
Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0tag:blogger.com,1999:blog-5611059176105574026.post-28712573475308831982010-12-03T20:17:00.005+04:002010-12-03T20:27:38.949+04:00Oracle 11g new feature: PRIMARY_DB_UNIQUE_NAME column in V$DATABASEYou can now find the DB_UNIQUE_NAME of the primary database from the standby database by querying the new PRIMARY_DB_UNIQUE_NAME column in the V$DATABASE view.
Also, Oracle Data Guard release 11g ensures each database's DB_UNIQUE_NAME is different.
It means, after upgrading to 11g, any databases with the same DB_UNIQUE_NAME will not be able to communicate with each other.
SQL> desc v$Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0tag:blogger.com,1999:blog-5611059176105574026.post-43842873916216109652010-11-25T12:51:00.004+04:002010-11-25T13:01:02.816+04:00Oracle 11g new feature in DataPump Export: Overwrite existing dump fileAs you know, until 11g, normally, Data Pump Export will return an error if you specify a dump file name that already exists. Starting with 11g, the REUSE_DUMPFILES parameter allows you to override that behavior and reuse a dump file name.
Example:
SQL> create table myt1 as select * from all_objects where rownum<11;
Table created.
SQL> create directory mydir1 as 'c:\oradump';
Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0tag:blogger.com,1999:blog-5611059176105574026.post-63887113000307403152010-11-02T17:01:00.003+04:002010-11-03T14:10:34.986+04:00Video Tutorial: Oracle 11g Active Standby Database Automatic Block Corruption RepairTeymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com2tag:blogger.com,1999:blog-5611059176105574026.post-67854917101803728982010-08-26T17:46:00.000+05:002010-08-26T17:46:10.951+05:00Video tutorial: Oracle 11g and RMAN substitution variablesTeymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0tag:blogger.com,1999:blog-5611059176105574026.post-88881493541817594102010-08-25T14:37:00.000+05:002010-08-25T14:37:01.196+05:00Video tutorial: Oracle 11g Streams: Two-Database Replication Environment with Synchronous CapturesTeymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com4tag:blogger.com,1999:blog-5611059176105574026.post-53119309657976895822010-08-19T12:10:00.001+05:002010-08-19T12:11:21.847+05:00Video tutorial: Oracle 11g Replay Workload using Enterprise ManagerTeymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com3tag:blogger.com,1999:blog-5611059176105574026.post-55040138363183020362010-08-16T16:53:00.005+05:002010-08-16T16:58:49.353+05:00Video tutorial: Oracle 11g Enterprise Manager and LogMiner InterfaceTeymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com3tag:blogger.com,1999:blog-5611059176105574026.post-50228889996695992872010-07-29T16:57:00.002+05:002010-07-29T17:21:06.059+05:00A new thing I learned today: Truncating a table makes an unusable index valid Today I was rereading 11gR2 new Features regarding unusable indexes. I met with following in that document: 11GR2 doc
Unusable indexes
An unusable index is ignored by the optimizer and is not maintained by DML. One reason to make an index unusable is if you want to improve the performance of bulk loads. (Bulk loads go more quickly if the database does not need to maintain indexes when Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0tag:blogger.com,1999:blog-5611059176105574026.post-30997026840701937702010-07-13T14:47:00.003+05:002010-07-13T14:56:07.984+05:00ORA-15063: ASM discovered an insufficient number of disks for diskgroupAfter sudden restart of DB Server, interesting issue happened with ASM instance today.
OS: Win2003 32 bit
Oracle: 10.2.0.1
SQL> startup
ASM instance started
...
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "RECO"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
Error description from doc:
Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com2tag:blogger.com,1999:blog-5611059176105574026.post-76675171278570428392010-06-22T12:03:00.001+05:002010-06-22T12:05:19.737+05:00ORA-08106: cannot create journal table ... and ORA-00600Environment:
OS: Win2003 32 bit
Oracle: 10.2.0.1
Problem description: My colleague told me that he can not rebuild index online. Index partition datafile was lost. Trying to rebuild index in online mode, Oracle raised error ORA-08106: cannot create journal table XXX.SYS_JOURNAL_123473.
Solution:
bash-2.05$ oerr ora 08106
08106, 00000, "can not create journal table %s.%s"
// *CauseTeymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com1tag:blogger.com,1999:blog-5611059176105574026.post-21207074948269115582010-06-03T12:32:00.004+05:002010-06-03T20:38:30.853+05:00Standby database: ORA-00600: internal error code, arguments: [3020]Today I received error in Standby database after adding new datafile into UNDO tablespace at primary site.
This is Oracle SE 9.2.0.5 on Sun box which is used by Vendor Application:
Media Recovery Log /oracle/arch/dbint_0000002811.log.ora
Thu Jun 3 08:58:39 2010
Errors in file /oracle/home92/admin/dump/dbint_ora_27204.trc:
ORA-00600: internal error code, arguments: [3020], [20971527], [1]Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com2tag:blogger.com,1999:blog-5611059176105574026.post-13930222524650977982010-05-17T12:19:00.003+05:002010-05-17T14:26:07.356+05:00Real world example what it can cause using hidden parameters without Oracle Support’s direct controlAs we know, there are many undocumented initialization parameters in Oracle Database and sometimes it is called "hidden parameters". These parameters is critical tool for Oracle Support Engineers in case of emergency problems relating customers At the same time, Oracle strongly recommends using these parameters only and only under Oracle Support’s direct control and confirmation. Otherwise, Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com5tag:blogger.com,1999:blog-5611059176105574026.post-41374553937171332332010-05-12T17:44:00.004+05:002010-05-12T20:16:31.440+05:00How to get list of hidden parameters in ORACLE?Hidden parameters should be used only and only under Oracle Support control. Otherwise you can be left with your corrupted database. In the near future I will post real world example what it caused using it without Oracle Support's confirmation.
However, I was interested in how many and which hidden parameters available in Oracle. Below is script:
SELECT
a.ksppinm "Parameter",
b.ksppstvl "Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com5tag:blogger.com,1999:blog-5611059176105574026.post-81140821481185258592010-05-07T11:54:00.002+05:002010-05-07T12:18:30.811+05:00How to become an Oracle Certified Master (OCM)I became an Oracle 10g OCM, everybody else wanted to know how to become one. Let me show you the way to become an Oracle Certified Master (OCM).
1) You have to get OCP (Oracle Certified Professional)
2) Following that, you will need to attend 2 advanced trainings from Oracle University. You should
attend RAC and Backup/Recovery. Refresh your knowledge with Oracle backup and recovery Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com9tag:blogger.com,1999:blog-5611059176105574026.post-21735704589026945812010-05-07T11:52:00.005+05:002010-05-07T17:00:59.064+05:00Relation between Oracle Direct Path Insert, NOLOGGING, Unusable IndexesSometimes lots of us confused as mistakenly thinking DIRECT PATH INSERT (using APPEND hint) will not generate or generate LESS redo.
In reality, it is true, but there are other conditions which must be true:
I - Database is in archivelog mode:
Case 1 - Table is in logging mode, conventional insert and no index:
SQL> set autotrace traceonly statistics
SQL> create table myt1 as select *Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com1tag:blogger.com,1999:blog-5611059176105574026.post-83821568565709344092010-05-07T11:50:00.002+05:002010-05-07T17:03:18.121+05:00DBA_FREE_SPACE - Misunderstanding how Oracle populates itOne of my colleagues asked why some tablespaces are missing from DBA_FREE_SPACE.
You have to be sure that, below cases is not true for your tablespace, if it does not appear in DBA_FREE_SPACE:
1) The tablespace is a temporary tablespace.
2) The tablespace is offline.
3) The tablespace contains no free space. The minimum space required for the tablespace to be reported in the DBA_FREE_SPACE is Teymur Hajiyevhttp://www.blogger.com/profile/16802232106048354670noreply@blogger.com0