• November 29, 2005 29 Nov'05

    Archive log files generating quickly

    Yesterday users complained that performance was going down; after than I checked in the database and I found that archive log files are generating very quickly, nearly two archive log files in a minute with a size of 100 MB each. But normally it ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Configuring TAF parameters in RAC

    I have a question regarding Oracle 9i RAC database. We have two nodes that are concurrently accessing the same database in a RAC environment on Sun boxes, and we have a total of 300 users. We want to use the RAC feature to call Transparent ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Operation hanging during installation

    I am trying to install on Windows 2003. It succesfully installed Oracle and performed the Net Configuration. When it creates the database through DBCA and goes to option COMPLETING DATABASE CREATE and tries to "clone the database," the ...  Continue Reading

  • November 29, 2005 29 Nov'05

    ORA-12537 error when trying to connect

    I installed Oracle 8.1.7 on Windows 2000 and got this message when I tried to connect to my database from the client's PC: "ORA-12537 TNS:connection closed."  Continue Reading

  • November 29, 2005 29 Nov'05

    Copying a database with Arabic fonts

    I need to make a copy of a DB in 9i on Windows 2003 Server but I have Arabic fonts. I tried to do this with exp and imp, but all fonts in Arabic were lost. I tried to adjust the character set for the new database with no success.  Continue Reading

  • November 29, 2005 29 Nov'05

    Creating a query to hit an index

    I have a few doubts about index creations. I have a table called PLANTEST. Now I have created two non-unique indexes, for both the columns separately. But when I execute the below query, the system is not hitting the index. Can you please tell me ...  Continue Reading

  • November 29, 2005 29 Nov'05

    How is the bitmap index stored?

    Can you tell me how the bitmap index is stored? Basically I want to know the way it is stored inside the database and, during retrieval, how it is used to retrieve rows based on that.  Continue Reading

  • November 29, 2005 29 Nov'05

    Dumping data from 10g to 9i

    How to dump data from Oracle 10g to Oracle 9i? Or, how to move the dump from a 10g database to a 9i database?  Continue Reading

  • November 29, 2005 29 Nov'05

    Problems installing 8i Enterprise Edition on XP

    I am trying to install Oracle8i Enterprise Edition on Windows XP, SP2, and for some reason, when I either click on setup.exe or try to run from the command line, the Universal Installer does not start. In fact, I don't even see it start up and run ...  Continue Reading

  • November 29, 2005 29 Nov'05

    DIM error during 10g installation

    While installing Oracle 10g on Windows 2003 Server (standard edition) I am getting an error, "DIM 00019." What could be the solution for that?  Continue Reading