1,149 reputation
28
bio website
location
age
visits member for 2 years, 8 months
seen 20 hours ago

Jul
17
comment Oracle installation fails due to ORA-00443
Please login on the same user as you tried install (it was oracle, wasn't it?) and update the question with ulimit -a.
Jul
16
comment Dynamic permissions
I trust you based on your reputation, so I retract my answer/comments.
Jul
16
comment Dynamic permissions
If DDL fails, the trigger is not executed. If the DDL succeeds, it is implicitly committed and then the trigger fires in the next transaction.
Jul
14
comment Oracle 11g R2 - same query sometimes fast, sometimes slow
trace it and tkprof
Jul
6
comment ORA-00227: corrupt block detected in control file
Please add to the question the result of show parameter control
Jul
4
comment Oracle: Replace corrupted first datafile
Of course not...
Jul
1
comment Sync/Replication of 2 Oracle Databases with NetApp storage
Please edit your question to add if your RAC under Oracle EE license or under SE license.
Jun
30
comment Restore an oracle dmp file
Use your imagination :)
Jun
30
comment How to recreate or restore Corrupted Data Files in Oracle 11g
"The data in UNDO are only recent changes not yet committed" - no. The data in UNDO are the ORIGINAL data, that were overwritten (doesn't matter if overwriting transactions were committed or not). Just a nitpick. Or not.
Jun
17
comment Oracle patching
It's the same. 10.2.0.1.0 was the base version (call it "patch set 0" if you want), so 10.2.0.5.0 means patch set 4. Weird, isn't it? And PSU isn't reflected in this scheme at all in opatch.
May
2
comment Oracle 12c in-memory option
If there is no undo for in-memory "index", long-running queries cannot benefit from it, can they?
Feb
3
comment Oracle 11g database server password rollbacks
"Rolls back" or "not at all working"? Which is it?
Jan
24
comment Oracle: REGEXP functions hang with “DIRECT PATH READ”
Judging from "Seesion even KILLED not went away" I would say that it was in fact in RUNNING state, and not in WAITING state. If the session is RUNNING, the wait event is irrelevant as it simply shows the past (historical) wait event.
Jan
24
comment Sometimes getting quotes in Oracle spool sometimes not
+1 for the neat SQLdeveloper functionality
Jan
9
comment Finding why an Oracle listener got automatically restarted
Please provide the output of crs_stat -t. The command can be run as root and usually resides in CRS_HOME/bin or GI_HOME/bin.
Dec
6
comment Oracle 11g database structural change doesn't autobackup controlfile/spfile
@Ivan Both NBU and TSM work when executed from RMAN script. In fact, you cannot execute them in any other way, which kind-of sucks.
Oct
4
comment Recover oracle 10g database from old data files
If you, at some point in the past, have had copied all the relevant files while the database was shutdown, it surely wouldn't complain about resetlogs. Since it does complain, either you didn't restore all the relevant files, or the files are corrupted. My first guess is that the files were copied while modified, hence they are inconsistent, hence you have no backup to restore.
Sep
30
comment recover oracle db from datafile
What about redo files?
Sep
29
comment How can I execute a PL/SQL procedure for Oracle via JDBC?
EXEC (EXECUTE) is a SQL*Plus native command (just like SHUTDOWN, HELP, SET, etc.), and not a part of SQL itself.
Sep
24
comment Installing Oracle 11gR2 on Oracle Linux 6 - error possibly related to database (unique) name
What is the result of ping "$ORACLE_HOSTNAME" command?