4,099 reputation
721
bio website ronr.blogspot.com
location Netherlands
age 50
visits member for 3 years, 5 months
seen Jul 26 at 12:57

I am just an oracle - ACE - dba OCM that likes to play with large unix based warehouses. In between I have written a book that is hopefully a useful addition to what is written about Oracle Scheduler, called Mastering Oracle Scheduler In my list of certifications is - Oracle 10g Certified Master - Oracle 11g Tuning Specialist - Oracle Certified Professional 7, 8, 8i, 9i,10g,11g


Follow me in twitter


Jul
18
comment Oracle RAC concept
In that case, normally we build local standby's with sync replication and one - or more - remote standby's that get their data in a more efficient way, so it does not hurt the transactions, but still very close to sync. Still a single point of truth.
Jul
17
comment Oracle RAC concept
Depends on what you want. If you want M's of users that mostly browse and 5% make transactions, you can make them read the standby databases and perform the updates in the primary database. With Active Data Guard, the TX will be copied to all standby's (with real time apply). That certainly scales better than RAC. That would be my choice. As with many technologies, you need to know how to handle it.
Jul
17
answered Oracle RAC concept
Jul
15
comment Remove ORA-01100:DATABASE ALREADY MOUNTED
No problems at all, start with 2 day dba at <docs.oracle.com/cd/E11882_01/server.112/e10897/toc.htm>; for 11gR2 or <docs.oracle.com/cd/E16655_01/server.121/e17643/toc.htm>; for 12c. Very instructive to start with.
Jul
15
answered Remove ORA-01100:DATABASE ALREADY MOUNTED
Jul
9
comment Cannot remotely connect to oracle express
are you sure your listener is on 192.168.33.1 and did you use port 1521? Normally a fw causes: no reaction at all.
Jul
9
answered Cannot remotely connect to oracle express
Jul
9
comment Use LDAP for name look up with Oracle Instant Client
yes, that is what I suggested.
Jul
7
comment Use LDAP for name look up with Oracle Instant Client
could be a domain issue. Did you also try with FQ name? (dbname_or_whatever.domainname)
Jul
5
comment ORA-00227: corrupt block detected in control file
what caused this to happen? Having windows repair your oracle controlfile is not the smartest to do. Do you have anything like backup in place? Since you have only 1 ctl file, a restore from a previous version looks like best option but not knowing what happened makes it a bit hard. For the same case, other files are also corrupted.
Jul
5
comment Find status of shutdown immediate
It's one of my reasons to use shutdown abort. The instance recovery that is required - and done - during startup can be done in parallel, makig the rollback a lot quicker.
Jul
4
comment Oracle: Replace corrupted first datafile
datafiles are adminstered in the controlfile, not in the [s]pfile. Is the db running archivelog mode and do you have a backup?
Jun
29
comment Restore an oracle dmp file
show the logfile of the export or expdp session that created the dmp file.
Jun
27
comment ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64
@greengold read the alertlog file and see if the database is opened at the end. In the alertlog you also find a dump of the actual parameters with their values. I am not sure where the alertlog will be but start searching in C:\oraclexe\app\oracle\diag\rdbms\xe\xe\trace\alertxe.log
Jun
27
comment ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64
is your database open? what is the value of the processes parameter?
Jun
25
answered Can I get some rationale from the Optimzer why it chose a certain explain plan?
Jun
25
comment Why does second instance of database not open?
Are you trying to create a second database running independently from an already existing database, or are you trying to create a cluster database that is serviced by two instances (all using the same files)?
Jun
19
comment How to dump data from Oracle to MySql
do you mean that you get your data by means of oracle .dmp files, created by exp? In that case: bad luck.
Jun
11
revised Oracle database startup fails several times. Giving ksvcreate
added url to Bulk Processing with BULK COLLECT and FORALL
Jun
11
comment Oracle database startup fails several times. Giving ksvcreate
your application could be using bulk updates on large collections. See <oracle.com/technetwork/issue-archive/2012/12-sep/…; for a nice example and explanation.