Menu
I have installed Oracle 11g Express Edition from http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index-083047.html and also installed SQL Developer, but when I try connect to Oracle Database from Developer (I try create new connection) next error appears:
Ora00604 error occurred at recursive level 1 ORA - 12705.
What should I enter at: Hostname, port and SID
TNSNAMES provided below:
XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DYedilkhan-ПК)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
871
To find the most relevant triggers, filter the triggering_event column. Find the trigger that is causing the problem and disable it or drop it to resolve the issue. Usually, this error occurs in the Oracle database by the system level triggers on DDL or SYSTEM events.
Resolving the problemFind and stop the session that is preventing the exclusive lock. In Oracle 11g you can set ddl_lock_timeout, for example, allow DDL to wait for the object to become available, simply specify how long you would like it to wait: SQL> alter session set ddl_lock_timeout = 600; Session altered.
Resolving The ProblemDelete the entries inside BATCH_ID and re-run. Notice that there is a column called 'BATCH_ID'. If the rows beneath this column name are filled in (for example with '35') then it means that a BATCH_ID number has already been assigned. Test by re-running the script.
Windows - The NLS_LANG must be unset in the Windows registry (re-named is best). Look for the NLS_LANG subkey in the registry at \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, and rename it. Linux/UNIX - Here you simply issue the Linux command "unset NLS_LANG"
Add this rows into ..\sqldeveloper\ide\bin\ide.conf file
AddVMOption -Duser.language=en
AddVMOption -Duser.region=us
It's working for me.
161
if you don't know what language and region to use, you can add AddVMOption -Duser.region=
(nothing after =)
It worked in my case as macloving solution did too
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
