451 reputation
417
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.


Oct
25
comment Oracle Enterprise Manager font problem, some text is displayed in Chinese and with squares
thank you for you response, but I think I have the different situation: all other tabs are in English just Policies tab is in Chinese. If there was chosen Chinese during the installation then the whole OEM would have been in Chinese, right? But in my case just one section is in Chinese and others are in English.
Jul
26
comment Oracle big datafile restore fails using Netbackup (ORA-19511, ORA-27190)
Thank you @Phil I've already told my network administrator to increase socket idle timeout on firewall , waiting his response :) Thank you very much . Because of your answer I am completely sure that this is a network problem. Appreciate your help!
Jun
28
comment Incremental level 1 backup with no Incremental level 0?
one more question: Do I need to indicate recovery windows in RMAN?
Jun
28
comment Incremental level 1 backup with no Incremental level 0?
thank you for you responce. But the following sentence confuses me: "copies all blocks that have been changed since the file was created" Which file is mentioned? which file was created? Thank you
Jun
27
comment Incremental level 1 backup with no Incremental level 0?
@LeighRiffel I have already tested and after crosscheck it made inc 0 backup first and then inc 1. (without crosschek it makes inc 1 just) I just wonder to know how you do when using Netbackup as backup server. Do you use crosscheck in backup script? I was not using crosscheck but after founding that inc 1 may be done with no errors even u don't have inc 0 which means that you are not able to restore database because u don't have all backups AND you don't know about this! :(
Jun
14
comment Change Oracle IP
thank you for your response. In these files there are written IPs, not domain names.
May
30
comment How to troubleshoot enq: TX - row lock contention?
@Phil I have sql_id for both but still don't know the exact blocking statement because is contains bind variables. That are not captured in v$sql_bind_capture.I have added some info in "Additional Info" section in my post above, please see.
May
11
comment My database dramatically increased in size. Why?
@ipip Haven't yet. Now I am analyzing archived log files using Log Miner.
May
7
comment How to schedule function in Oracle?
that was what I wanted to read thank you...
May
7
comment How to schedule function in Oracle?
I have added some lines in my post, please see and help me. Thank you a lot.
May
7
comment How to schedule function in Oracle?
Current user........
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?
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...
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
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)
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("
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...