2019-02-11 08:37
Yesterday Peter from the Master of Disaster Blog sent me an email to ask if I had seen the issue in his post before and whether it was a new exploit. I looked at the post and immediately r… Read More
Blog Directory > Software Blogs > Programming Blogs > Ali YaÄŸmur - Oracle programming Blog >
Ali YaÄŸmur - Oracle Blog
aliyagmur.blogspot.com.tr
Tags:
database
primary database
faststart failover
sys adm
restore point
edit configuration set
tuser adm
disk
nodes
set property
Oracle Dataguard GoldenGate SQLite Java OCP OCA 12c 11g 10g
Oracle Error Messages Installation rsp files Postgresql
2019-02-11 08:11
If you enabled valut on the system and if you want to grant select on privilege to dba, it is enough to write this command :conn hr/hr;grant select on emp to dba;conn yoursys/yourpasswd as s… Read More
2016-11-09 06:43
courtesy by http://dbaharrison.blogspot.com.tr/2015/02/tuning-untunable.html As part of an application migration we have to run a script that moves the schema from version x to version… Read More
2016-04-11 10:31
You can find the original post here :http://dba.stackexchange.com/questions/34892/why-cant-rdbms-cluster-the-way-nosql-doesOr, Distributed Databases - what the FK does 'web scale' actually m… Read More
2016-03-15 11:06
CauseIt is caused by the Flashback logs required are not available, as for example FLB logs was deleted using OS commands. It applied to standby databases as well as RAC. One of the RAC Ins… Read More
2015-11-03 12:10
Introduction: During an Oracle software install for a new RAC environment once again I was surprised by Oracle . I had installed the Grid infrastructure (GI) 11.2.0.3 on RedHat… Read More
2015-10-16 07:28
ASM was first time introduced in Oracle Database 10g. Since then lot of improvement has been done. Here I am presenting changes and new feature whe… Read More
2015-10-16 07:27
Introduction The concept of the Preferred Read is not a new idea, but is now implemented in Oracle’s ASM volume management in Oracle 11g.The concept is to read from the storage t… Read More
2015-08-05 08:26
All About Statistics In Oracle In this post I'll try to summarize all sorts of statistics in Oracle, I strongly recommend reading the full article, as it contains information you may find… Read More
2015-08-05 08:23
FAST-START FAILOVER (FSF) The following conditions must be met before you can use the broker:■ Primary and standby DB’s must be on same version■ You must use a SPFILE to e… Read More
2015-05-22 06:15
RAC ArchitectureOracle Real Application clusters allows multiple instances to access a single database, the instances will be running on multiple nodes. In an standard Oracle configuration… Read More
2015-04-22 10:47
ORA-27102: out of memory *Cause: Out of memory *Action: Consult the trace file for detailsSolution is simple :Increase the swap or decrease the memory parameters you gave.To decrea… Read More
2015-04-08 11:38
i tried to kill the session using the below command.General syntax of command :c:\> orakill sid spidi tried to execute the command as given below.C:\>orakill 1540 1942Could not attach… Read More
2015-04-03 07:27
ORA-00257: archiver error. Connect internal only, until freed.Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the… Read More
2015-04-01 07:54
Solution IDORA-16857Type Oracle Argumentsstandby disconnected from redo source for longer than specified thresholdCauseThe amount of time the standby was disconnect… Read More
2015-03-25 19:19
A simple but intricating error.Please check quotation sign. I mean you may need replace " with '.Another causes may be related with wrong usage of parameter. Check parameters Read More
2015-02-26 11:15
export ORACLE_SID=TEST2echo 'starting TEST2 in MOUNT mode'echosqlplus /nolog <<EOFconnect rman/rman_oracledba as sysdbastartup mountalter database datafile '/data/oracle/TEST2/dataTEST… Read More
2015-02-26 11:15
export ORACLE_SID=TEST2sqlplus /nolog <<EOFconnect rman/rman_oracledba as sysdbastartup nomountexitEOFecho 'Restoring Controlfile using RMAN' rman <<EOFconnect… Read More
2015-02-05 08:35
Cause: Listener address has syntax error or cannot be resolved.Action: If a network name is specified, check that it corresponds to an entry in TNSNAMES.ORA or other address repository as c… Read More
2015-02-05 08:30
The ORA-12537 is an information message and means that the connection has been closed. This can be caused by a number of reasons:1. Database is shut down (maybe for nightly backup), but conn… Read More
2015-02-05 07:50
This situation is valid for Oracle 12c Multitenant architecture, Pluggable databases and OMF. Please read the blog item in detail to understand the cause.We prepared a template database :&nb&hell…Read More
2015-02-05 07:50
OGG-01223 TCP/IP error 10061 (No connection could be made because the target machine actively refused it)Solution is too simple : Are you sure that target and source manager pro… Read More
2015-02-05 07:47
While Replicating Oracle 12c Pluggable Databases with GoldenGate, you may encounter with this error : OGG-02022 Logmining server does not exist on this Oracle database. This shows that… Read More
2015-02-05 07:45
Data cannot be inserted if there is no quota on tablespace.Solution 1:SQL-> Alter user <user> quota unlimited on <tablespace_name>;Solution 2SQL-> Alter user <user… Read More
2015-02-05 07:43
I tested oracle TLS support with cipher suite "TLS_RSA_WITH_AES_256_CBC_SHA"Java (Client - Jdk 1.7.0.5) - JDBC – Oracle (Server VM Options : -Djavax.net.debug=all main, REA… Read More
2014-12-10 08:55
Original document is here : https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_bidirectional.htm#i1036715In short, Goal is to identify which process causes to replicate, and if t… Read More
2014-12-04 07:15
OGG-01950 No Privileges on tablespace tablespace_xxx.Cause: User does not have privileges to allocate an extent in the specified tablespace.Action: Grant the user the appropriate system priv… Read More
2014-10-10 11:05
After Test-Failover, make NEW Primary Standby againMaybe we want to test Failover, although the Primary is working fine. After the failover succeeded, we have an OLD Primary then and… Read More
2014-10-10 08:09
Connect Time Failover & Transparent Application Failover for Data GuardI was giving a 10g Data Guard course this week in Düsseldorf, demonstrating amongst others the possibilit… Read More
2014-10-10 08:09
Connect Time Failover & Transparent Application Failover for Data GuardI was giving a 10g Data Guard course this week in Düsseldorf, demonstrating amongst others the possibilit… Read More
2014-10-09 10:08
SQL> select open_mode from v$database;OPEN_MODE--------------------MOUNTEDSQL>SQL> alter database open;Database altered.SQL> select open_mode from v$database;OPEN_MODE… Read More
Subscribe to Ali YaÄŸmur - Oracle
Get updates delivered right to your inbox!