104 reputation
4
bio website
location
age
visits member for 8 months
seen yesterday
stats profile views 6

May
12
comment Mistake during Oracle 11g PITR
Just wondering, when using the syntax set until time "to_date('05/09/2013 06:10', 'MM/DD/YYYY HH:MI')"; Isn't he missing the AM/PM indicator? :). Other option would be HH24:MI
May
7
comment Duplicating a Database with RMAN
I cannot at this time. The link I provided should suffice to give you enough information. When using the duplicate from active database you won't need the backup files. It will start from the datafiles present on the source and recover using the archives. There might be something else you'll need to pay attention for, that is if the file structure is not the same. You'll have to make the proper adjustments in the duplicate block or in the spfile/pfile. I assume you have a test setup? Play a bit with it. Report the failures.
May
6
answered Duplicating a Database with RMAN
Feb
20
comment What's a free client for Oracle 8 on Linux / Ubuntu?
I use sqltools. It's awesome. sqltools.net
Feb
14
comment Creating new database and insert values in Oracle 10g xe hr account?
Just quick: the xe is a database with hr/hr schema and several others pre installed. You can start creating tables in the hr schema.
Nov
8
comment How do I generate a tnsnames.ora file to connect to an Oracle Database?
Honestly it is the default on a linux system... If you don't touch a thing it will be put there... thus being the default. But $ORACLE_HOME if not tampered with is indeed a better solution.
Nov
7
awarded  Editor
Nov
7
revised How do I generate a tnsnames.ora file to connect to an Oracle Database?
added 11 characters in body
Nov
7
comment How do I generate a tnsnames.ora file to connect to an Oracle Database?
the netca is started as the first step. The dbca won't allow you to continue without having created a listener. This is the case for 11g anyway.
Nov
7
answered How do I generate a tnsnames.ora file to connect to an Oracle Database?
Sep
27
comment Which oracle (10g) template files (DBCA) can be be copied to different server for cloning?
Just get the pfile from the other database, edit proper paths. Create a spfile from the pfile ( dba-oracle.com/concepts/pfile_spfile.htm )
Sep
20
awarded  Analytical
Sep
20
awarded  Supporter
Sep
18
awarded  Teacher
Sep
18
answered Do I have to pay a license fee for Berkeley DB?