4,514 reputation
722
bio website ronr.blogspot.com
location Netherlands
age 50
visits member for 3 years, 11 months
seen 3 hours ago

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
comment What are the Oracle Dataguard Implications of Migrating to a PDB?
yes, linking notes .... fixed it. The procedure should be tested any way but the ASM/FS should be transparent in this situation.
1d
revised What are the Oracle Dataguard Implications of Migrating to a PDB?
fixed link to note
1d
comment Oracle 11g connect overhead
I have seen this happen on a windows system. Maybe this is better on Unix. On Windows the app came close to a standstill when the listener.log reached 2GB. Connection times went up to minutes.
1d
revised Oracle 11g connect overhead
added a little about the locking and added RWPT video link about connection pooling
1d
answered Oracle 11g connect overhead
1d
answered What are the Oracle Dataguard Implications of Migrating to a PDB?
Jan
24
comment Oracle StartUp Issue
I see the database reports a clear error. I see no question. What is your question?
Jan
23
comment What are the Oracle Dataguard Implications of Migrating to a PDB?
You mean you have a 12c non PDB database and want to plug that into a container database? Or: you are asking about upgrading an 11g configuration to 12c with plugin? With 12c the container has the DG config so a database that plugs in is protected by that right away.
Jan
21
comment Not receiving archivelogs from production to remote side
ok, but can you also reach the remote listener port? 'telnet remotehost listenerport' Is the remote listener running? How is the alias remotedr defined?
Jan
21
comment Not receiving archivelogs from production to remote side
can you telnet from the primary site to the remote listener port? I don't think so:ORA-12170: TNS:Connect timeout occurred PING[ARC3]: Heartbeat failed to connect to standby 'remotedr'. Error is 12170. My guess: a firewall is blocking you.
Jan
20
comment Not receiving archivelogs from production to remote side
Well, without alertlog errors I need a magic bowl. Get the alertlog, read and weap. Verly likely it has a pointer to the problem.
Jan
20
comment Not receiving archivelogs from production to remote side
What is written in the primary alertlog for the remote archive destinations? How do you ship (logwriter or arch) sync/async, what configuration (max performance/ max protection)? async with arch, 1500KM is no problem with even worse connections.
Jan
6
comment Oracle nologging impact for REDO Generation
yes, good comment, thanks but append has a way of working which makes this only usable in a for all pl/sql construction. Don't do this with single row inserts; it is intended for bulk operations.
Jan
6
answered Oracle nologging impact for REDO Generation
Nov
21
answered Allowing users to compile / run PLSQL and SQL
Oct
15
answered Backup policy for Oracle 11g database in non-archive mode
Oct
13
answered Oracle 11g r2: Cannot create partition on timestamp field
Oct
9
comment Oracle 11g user created with Create session but able to update the table?
yes, this seems to be your problem.
Oct
9
comment Oracle 11g user created with Create session but able to update the table?
A user has privileges on a table, or not, independent from the tablespace where the table is located. Are privs on the table granted to the user 'PUBLIC'?
Oct
8
answered Oracle 11g user created with Create session but able to update the table?