451 reputation
416
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 22
visits member for 1 year, 10 months
seen Apr 5 at 12:57
stats profile views 78

I am OCA and I work as a DBA at JSC Bank of Georgia.


May
7
comment How to schedule function in Oracle?
It says: ORA-06550: line 1, column 729: PLS-00221: 'AUD_CLEAR_FUN' is not a procedure or is undefined ORA-06550: line 1, column 729: PL/SQL: Statement ignored ORA-06512: at "SYS.DBMS_ISCHED", line 185 ORA-06512: at "SYS.DBMS_SCHEDULER", line 486 ORA-06512: at line 2 View program sources of error stack?
May
7
comment How to schedule function in Oracle?
it means that I cannot schedule function, right? I have opportunity to call procedure but not function?
May
7
asked How to schedule function in Oracle?
Apr
4
accepted Oracle: Read from CLOB column line by line and insert to the table
Apr
4
accepted RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?
Apr
4
accepted ORA-01555: snapshot too old: rollback segment number with name “” too small
Apr
4
accepted Oracle RAC on Virtual machine
Apr
2
comment Oracle RAC on Virtual machine
@Phil it is production , can be said that it is not highly loaded.
Apr
2
comment Oracle RAC on Virtual machine
@Phil I just want your opinion about RAC on virtual machine. I think it is not good idea. One guy told me that Oracle do not give support for RAC on virtual machine...
Apr
2
asked Oracle RAC on Virtual machine
Mar
28
comment ORA-01017: invalid username/password; logon denied
@LeighRiffel I also think that this is PL/SQL Developer issue.. Now I created user with password expire and after connecting , there appeared as usual password changer window.. after trying to set new password(pressing OK) the same error happened.
Mar
28
comment How to free up disk space? which logs/directories to clean? [ORACLE 11g]
@LeighRiffel I just wanted to free up the space and thought that these files were junks. I've already deleted files from /u01/app/11.2.0/grid/cv/log. These files are generating every 5 minutes. To stop generation of them you should write SRVM_TRACE="false" at the top of the script $ORA_CRS_HOME/bin/cluvfy for me it is /u01/app/11.2.0/grid/bin/cluvfy(line 25) The solution of this was found on metalink.
Mar
28
revised How to free up disk space? which logs/directories to clean? [ORACLE 11g]
added 69 characters in body
Mar
28
asked How to free up disk space? which logs/directories to clean? [ORACLE 11g]
Mar
28
comment ORA-01017: invalid username/password; logon denied
@Phil thank you for your response. I will explain by example. I copied the password, pasted and tried to logon-> appeared error. Tried the next time by the same way -> again error, tried again by the same way(I mean pasted password) and logged on successfully. (Strange)
Mar
28
asked ORA-01017: invalid username/password; logon denied
Feb
18
awarded  Popular Question
Jan
20
comment Oracle: Read from CLOB column line by line and insert to the table
I got the following error: ORA-32033: unsupported column aliasing on "with w("
Jan
18
asked Oracle: Read from CLOB column line by line and insert to the table
Nov
10
comment ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
I am sys user, and synonym is mine. Is there any possibility that I don't have create permission on it. As I said I have granted CREATE ANY SYNONYM to SYS schema...