Search

Top 60 Oracle Blogs

Recent comments

October 2013

OpenLDAP – phpldapadmin – Install and Configure

This is part 5 of a multi-part blog post on using OpenLDAP for Net Service Name Resolution.  Part 1 can be found here.

Day to Day Management

The tns2ldif program is great for converting a large number of Net Service Names into the LDIF format, for subsequent bulk loading into the LDAP server.  But, for day to day operation, where you may want to add or delete individual Net Service Names or modify an existing Net Service Name, hand editing LDIF files is probably not an optimal solution.  So, is there a GUI solution that may help with this type of day to day work?  There are a few free LDAP GUIs available.  The one I have chosen is phpldapadmin.

phpldapadmin

View Data Volume Estimates

When the optimizer has to estimate the data volume (the BYTES column in the plan output), it usually bases this information on the column statistics, if applicable and available (think of complex expressions).However, whenever there is a VIEW operator in an execution plan, that represents an unmerged view, the optimizer obviously "loses" this information and starts applying defaults that are based on the column definition.Depending on the actual content of the columns this can lead to dramatic differences in data volume estimates.Both, under- and overestimates are possible, because for character based columns these defaults seem to be based on an assumed 50% fill grade, so a VARCHAR2(100 BYTE) column counts as 50 bytes data volume.For multi-byte character sets the same rule applies based on the maximum width of a column using the "char" semantics, so a VARCHAR2(1000 CHAR) column counts as 2000 byte

largest SGA

I am curious and wanted to know how many memory allocation SGA config largest ever in the world, ITB, 2TB, 4TB and so on ... kind regards, Iwan

Read the answer...

OpenLDAP – Care and Feeding of Your LDAP Server

This is part 4 of a multi-part blog post on using OpenLDAP for Net Service Name Resolution.  Part 1 can be found here.

Congratulations!

You should now have a correctly installed and fully configured LDAP server, that’s up to the task of doing Net Service Name resolution.  So, now you’ve come this far, you probably have a whole list of Net Service Names that you want to load into your LDAP server.  We’ve reviewed the LDIF format for Net Service Names, but, unless you have a very small number of Net Service Names, converting them from tnsnames.ora format to LDIF format could prove to be a very tedious task, indeed.  In my case, I had approximately 250 Net Service Names, that I needed to load.  So, I wrote a small C program, that I called tns2ldif, for this task.

Largest SGA Ever

I am curious and wanted to know how many memory allocation SGA config largest ever in the world, ITB, 2TB, 4TB and so on ... kind regards, Iwan (iwank21@gmail.com)

Read the answer...

Write cache with open file handles?

I have a doubt about RAC.

I was trying recovery of OCR and voting disk. This is what I did:

-- created a diskgroup OCRVD with external redundancy and 5 disks
-- Moved OCR and voting file to the diskgroup OCRVD
-- Corrupted all the disks in the diskgroup using dd command. I was expecting c/ware to come down as all the voting disks are inaccessible. But the c/ware continued as earlier. C/ware alert log, OCSSD log and ASm alert log did not display anything relevant.
-- I even deleted all the partitions on which ASM disks were configured but c/ware still continued.
-- As soon as I stopped ISCSI service, the alert log revealed that Voting disk was inaccessible and node rebooted .

How can these results be explained in view of the fact that for c/ware to continue, more than half the number of voting disks should be accessible.

Thanks and regards
Anju Garg

Read the answer...

Can you Apply redo to import?

i am new to the world of dba, so i wanted to ask that is it possible to apply redo logs after a import for recovery as we do apply redo logs after restoring from backup files. i know import is kind of a logical thing and backup files are physical copy. so redo logs cant be applied on after import. what i want to know is, is there any way we can do it, if not whynot?(another reason apart from the above : ) )

Read the answer...

& in create table

Can we use functions in CREATE statement ? if yes. Please rectify this Create table &TABLENAME ( ....); Here I want to use CHR and ASCII function in place of "&" substitution variable.

Read the answer...

See your post on OTN

Hi all, I get this error when trying to register a database in RMAN RMAN> register database; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of register command on default channel at 02/25/2013 13:31:05 RMAN-10015: error compiling PL/SQL program RMAN-10014: PL/SQL error 0 on line 13 column 5: Statement ignored RMAN-10014: PL/SQL error 201 on line 13 column 5: identifier 'DBMS_RCVCAT.REGISTERDATABASE' must be declared Any help would be greatly appreciated. You can view the thread on OTN Discussion forums here: https://forums.oracle.com/forums/thread.jspa?threadID=2503670&start=15&t...

Read the answer...

I responded to your thread on OTN.

Hi all, I get this error when trying to register a database in RMAN RMAN> register database; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of register command on default channel at 02/25/2013 13:31:05 RMAN-10015: error compiling PL/SQL program RMAN-10014: PL/SQL error 0 on line 13 column 5: Statement ignored RMAN-10014: PL/SQL error 201 on line 13 column 5: identifier 'DBMS_RCVCAT.REGISTERDATABASE' must be declared Any help would be greatly appreciated. You can view the OTN discussion thread here: https://forums.oracle.com/forums/thread.jspa?threadID=2503670&start=0&ts...

Read the answer...