4,294 reputation
722
bio website ronr.blogspot.com
location Netherlands
age 50
visits member for 3 years, 7 months
seen yesterday

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


1d
awarded  Explainer
Aug
26
answered Reinstall Oracle 11G2
Aug
14
revised Restoring a tablespace to a different database
added 138 characters in body
Aug
14
answered Restoring a tablespace to a different database
Aug
13
comment Exporting scheduled jobs in Oracle
hey, nice trick, I did not know that.
Aug
13
comment Exporting scheduled jobs in Oracle
even now, dbms_metadata does not support dbms_scheduler jobs. The JOBs mentioned in the list are the dbms_job type of jobs.
Aug
6
answered Licensing of Oracle Standard One multiple homes
Aug
4
comment ora-03113 end-of-file on communication channel on creation of database
Did you check the certification matrix? 9i is very old and if you are installing on a recent windows version, that could be the problem. Also check docs.oracle.com/html/B10163_01/toc.htm
Aug
4
comment ora-03113 end-of-file on communication channel on creation of database
platform? 9i is very old .... What is in the alertlog file?
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.