Ask the Experts

Ask the Experts

  • Using OS Authentication

    I believe that we have a configuration somewhere (Oracle?) that allows Unix user account "ORAsid" to connect to the database as "OPS$ORAsid" without requiring a password. Is this true? Could this be changed (to requiring a password to get into the ...  Continue Reading

  • Converting from CHAR to DATE datatype

    As a time value, I used the CHAR datatype and need to convert to a DATE value while manipulating/computing. How do I use the DATE datatype instead?  Continue Reading

  • Input/output errors

    I have the following error:

    ERROR at line 1:
    ORA-01115: IO error reading block from file 2 (block # 2772)
    ORA-01110: data file 2: '/home5/oracle/oradata/lrec_ts_files/lrec.dbf'
    ORA-27091: skgfqio: unable to queue I/O
    ORA-27072: skgfdisp: I...
    				 Continue Reading

  • Migrating from Solaris to Linux

    We need to migrate our Oracle 9.2 database from Sun Solaris to Red Hat Linux. Our datafiles are stored on EMC's SAN. Do we have to use export and import even though we use a centralized storage?  Continue Reading

  • Fatal NI connect error

    I have the following error in my Oracle server: "Fatal NI connect error 12638." I don't understood why because it was working so well before, but today it sent that error.  Continue Reading

  • Database crash during hot backup

    Our Oracle 8.0.4 database crashed while doing a hot backup with CA BrightStor. Now one of our databases will not start. Event viewer shows it starting and then shutting down again. Our dbaora7.log shows that all tables and control files ...  Continue Reading

  • Installing 32-bit and 64-bit Oracle on same machine

    I have an application that does not support 64-bit Oracle. It needs to run on 32-bit Oracle. Can I install two Oracle engines (32-bit and 64-bit) on the same machine? If so, how can it be done?  Continue Reading

  • Three consecutive months in fiscal year

    I have a conveyance_claim table with claim date and type, one record per month. I have to check in financial year (April to March) if three continuous months have claims of the same type. How can I find it?  Continue Reading

  • Multiple instances on a single database

    Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)?  Continue Reading


    What is the correct circumstance to store a numeric string as VARCHAR2 vs. NUMBER? The response I have received before is to store all numeric strings as VARCHAR2 unless the intention is to manipulate the field mathematically; but no reason has ...  Continue Reading

  • Concatenating XML fragments

    Using XMLElement and XMLForest I have created several XML "strings." In a final XMLElement select statement with XMLForest I want to concat the earlier strings within the output of the final statement. Can concat be used within XMLElement or ...  Continue Reading