Problem solve

Get help with specific problems with your technologies, process and projects.

Oracle error messages

  • Recovering .dbf files without .dmp files

    I have a problem to recover .dbf files from one server (which already crashed) to another server. We don't have any .dmp files. We only have the .dbf and .ctl plus all files in the /oracle/admin folder. Continue Reading

  • Import failing

    I have tried importing five times using Telnet, and I have received the below message every time, even though I have exported succesfully again using the same Telnet login to the database server. Then importing resulted in the same message. The DB ... Continue Reading

  • Packet writer failure

    I am getting this error: "ORA-12571: TNS:Packet writer failure." The problem does not happen all the time. The sqlnet.ora file only says "sqlnet.expire_time = 5." Continue Reading

  • Files are in use by another application

    I have the same problem as already reported earlier on your Web site: "I am trying to install Oracle patch to Oracle I keep getting error messages that say some files that need to be changed are in use by another application. I ... Continue Reading

  • No errors in tnsnames.ora file

    While connecting to the database through Toad or SQL*Plus, the "TNS name could not be resolved" error is appearing. After checking the TNSNames.ora file, I confirmed that there is no error in it. What could be other possibilities for this error ... Continue Reading

  • Error when trying to connect through SQL*Plus or Oracle Net Manager

    I installed Oracle client on a Win2K computer. I want to connect to Oracle Database in another computer. I get this error when I connect using SQL*Plus: "ORA-12535: TNS:operation timed out." I tried to use Oracle Net Manager to connect to the ...Continue Reading

  • Java Run Time error when installing Oracle8i on Windows 2003

    When installing Oracle8i EE on Windows 2003 Server, I got the message "Java Run Time Environment not found at %/jre/win32/bin/jrenw.exe." Hence I installed JRE1.1.8 but it didn't solve the problem.Continue Reading

  • Not able to connect with Covus

    We are using a third-party tool (Covus -- used for document labeling). Covus will work with Oracle Client 8.1.7. So I installed Oracle Client 8.1.7 and then Oracle Forms 6i. I am able to connect to Forms and Toad. But when I try to connect to Covus...Continue Reading

  • Need higher JRE version?

    I am trying to run the Oracle Universal Installer (version 10) on a Solaris 10 box and get the following error: "The Java RunTime Environment was not found at bin/java. Hence, the Oracle Universal Installer cannot be run. Please visit http://...Continue Reading

  • OIP-00005 error

    We are migrating our client from Oracle 8.5 to Oracle 9.2. On executing one of the procedures, we receive the following error: "OIP-00005 (Variable is not a)."Continue Reading

  • SQL*Forms30 not recognized

    We have recently installed Oracle on Red Hat 7.3. I want to develop a small Forms3 application and have SQL*Forms30 on Solaris, which I've moved across to the machine. However, when I try and run SQL*Forms30 it gives "/home/oracle/bin/...Continue Reading

  • Character set name is not recognized

    Would you please guide me on why I am getting these errors when I try to run the below script? ORA-06550: line 1, column 29: PLS-00553: character set name is not recognized, ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated.Continue Reading

  • One client PC of many won't connect to database

    I have already installed Oracle on many client PCs and I didn't encounter any problems. But there is one client PC that is giving me problems. I cannot connect to the database. It is always giving ORA-12560. The tnsnames.ora is correct. I can also ...Continue Reading

  • ORA-1002 when trying to copy file

    When I was trying to copy a file from a data server to the main server, the following error in a select statement occured: "ORA-1002: Message -1002 not found."Continue Reading

  • Error when dblink connects to database

    I am trying to create a dblink of name "tt" to connect to another database of name "TEST" on the same server. It is giving me the error "ORA-02085: database link tt connects to test."Continue Reading