.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
problems after installing 10g R2 on win2000

problems after installing 10g R2 on win2000

2005-10-17       - By t_adolph@(protected)
Reply:     1     2  

Hi all,

I recently installed 10g rel 2 on my win 2000 box.  Since the have had a battle
to run any 9i stuff, eg dbca and pl/sql Developer.

I've fixed the dbca problem thanks for posts on this forum (thanks), but my pl
/sql Developer is not very happy:

Almost all queries cause the following error : "ORA-01460 (See ORA-01460.ora-code.com): unimplemented or
unreasonable conversion requested"  From the sql window this is only annoying,
but the GUI functionallity no longer works, e.g. to view/edit a table fails, to
describe an table fails.... etc

So far I've tried:

1)  The same fix as for the dbca, i.e. I've created a bat file that sets the
environment before starting the GUI:

-- ---- ---- ----- bat file -- ---- ---- ---- ---
set PATH=<removed all 10g components, only 9i components plus origonal PATH
from before 10g>
set ORACLE_BASE=D:\oracle
set ORACLE_HOME=D:\oracle\ora92
set NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
set LD_LIBRARY_PATH=%ORACLE_HOME%\lib
d:
cd "D:\PLSQL Developer"
"D:\PLSQL Developer\PLSQLDev.exe"
-- ---- -- end of  bat file -- ---- ---- ---- ---


2) I've explicitly set the OCI library from within PL/SQL Developer :
   Tools->Preferences OCI Library = D:\oracle\ora92\bin\oci.dll
and set the ORACLE_HOME as apposed to letting it be auto-detected.

But still no good.  PL/SQL Dev still doesn't want to play the game.  

Any ideas would be appreciated.

Cheers
Tony


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1515" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>I recently installed 10g rel 2 on my win 2000
box.&nbsp; Since the have had a battle to run any 9i stuff, eg dbca and pl/sql
Developer.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>I've fixed the dbca problem thanks for posts on
this forum (thanks), but my pl/sql Developer is not very happy:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Almost all queries cause the following error :
"ORA-01460 (See ORA-01460.ora-code.com): unimplemented or unreasonable conversion requested"&nbsp;