Reputation
735
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
7 23 43
Impact
~248k people reached

  • 0 posts edited
  • 0 helpful flags
  • 35 votes cast
Mar
4
comment SCAN listener redirects connection to another port
@BalazsPapp thank you for your help.
Mar
4
comment SCAN listener redirects connection to another port
@BalazsPapp I have researched to lot and found the answer I think. I am posting my research in an answer.
Mar
3
comment SCAN listener redirects connection to another port
@BalazsPapp how can I upload file output? There is a limit on number of characters. Also there is an icon by which you can upload just image and not text file.
Mar
2
comment SCAN listener redirects connection to another port
dispatchers=(ADDRESS=(PRO=TCP)(HOST=lbdb01-vip-hq))(DISP=200)(POOL=off)(CONN=50)‌​(SESS=50)
Feb
16
comment date type implicit conversion
Thank you @JSapkota!
Sep
18
comment Oracle remote OS authentication, security risks with domain users
I renamed my laptop computer to KA, so computer name is KA. Created local user MARIK. Switched off my network cable from my work computer, which is in domain and plugged it into my laptop. Set the same ip as it had my work compuer. Logged on to the computer by MARIK user. When I run whoami, it shows me KA\MARIK. Created user "OPS$MARIK" in my database and tried to connect from laptop without password and username. ORA-01017 happend. So by some way oracle check if user is a domain user or local user. One more thing to note. If you create user "OPS$MARIK" you can logon but not "OPS$LB\MARIK"
Mar
23
comment Can I have Oracle primary 11.2.0.1 and standby 11.2.0.3?
@Phil what about a logical standby?
Feb
25
comment ORA-15081: failed to submit an I/O operation to a disk
I am using UDEV rules not asmlib, as I remember /etc/init.d/oracleasm exists when using asmlib,isn't it?
Feb
25
comment ORA-15081: failed to submit an I/O operation to a disk
-bash: /etc/init.d/oracleasm: No such file or directory
Feb
25
comment ORA-15081: failed to submit an I/O operation to a disk
It returns DATA01_0000 | /dev/oracleasm/asm_disk1
Feb
25
comment ORA-15081: failed to submit an I/O operation to a disk
It is not using multi-path. How to check what you said? ("O.S. does not point to the file system instead of the disk groups")
Feb
25
comment ORA-15081: failed to submit an I/O operation to a disk
@Colin'tHart I have changed permissions but still not working. Maybe there is the problem with virtual disk, but don't know how to check.
Feb
13
comment Oracle installation requires old rpm versions, what to do?
Ok, I will ignore it. I am trying to install old version and then upgrade it to 11.2.0.3
Feb
12
comment Check only prerequisites when running runInstaller in silent mode
-silentvalidate doesn't work for 11gR2
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
my spfile contains the following: crimesys1.undo_tablespace='UNDOTBS1' *.undo_tablespace='UNDOTBS' UNDOTBS is newly created undo tablespace, which I want to leave and delete other undo tablespaces.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@MindaugasRiauba dba_2pc_pending is empty now but, there is sometimes a record in gv$transaction referring to some of these segments.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@Phil Why do you think that shutdown abort may resolve the issue?
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@Phil I changed UNDOTBS2 to any available undo tablespace name and still returns 0 rows. Maybe, it is now that no one uses, but will be used after a while.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@Phil Thank you. Your query returns nothing.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
I found that segments with PARTLY AVAILABLE statuses contains an active dead transactions.