10g
Our database is hanging with the above error.
I already freed everything in the flash_recovery_area . all archive logs and backupset. But still the error persist :(
I even alter system set recovery desc to 100G. still error.
From alert log,
<msg time='2010-09-03T11:37:46.548+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='24310'>
<txt>Error 12160 received logging on to the standby
[code]...
From trace file,
[oracle@DC-DB-01 ~]$ less /u01/app/oracle/diag/rdbms/bddipdc/bddipdc1/trace/bddipdc1_arcq_24310.trc
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12160 and errmsg is 'ORA-12160: TNS:internal error:
\
[code]...
Problem is one form that i have to migrate from version 6 throu 6i I got very difficult (for me) error FRM-40734. Happens In WHEN-NEW-FORM-INSTANCE trigger when i try do go_block('NAVI');NAVI block is NOT database block (property set NO)
Database Oracle Database 10g Release 10.2.0.4.0
Forms 11.1.2.0.0,
Below i post some code
When-New-Form-Instance trigger
....some other code
navi_pck.link_activated();
... some other code
navi_pck.Init();
... some other code
Navi_pck is a package added to program modules
PACKAGE BODY navi_pck IS
type t_navi_data is record
( name varchar2(64),
primary_item varchar2(64),
[code]...
When When-New-Instance-Form fires on line navi_pck.link_activated(); we go to init(); in navi_pck packageeverything is ok - that mean it is executed without any errorthen when we hit navi_pck.Init();we got error at Bold line => go_block(g_block); that is error not exception (because adding begin... exception when others ... end; does not catch it)
Of course its needed to be done -> mean that go_block, because after it we clear block and work on it.I got 5 triggers on that block NAVE - but tried already to NULL theirs code but didnt solve the problem (didnt try to remove them...)
I am using forms 6i. In my program..i am using win_api_dialog.select_printer.I am getting this error frm-40734.
View 5 Replies View RelatedIf i try to execute the below code i go the ora:00600 error. what is wrong in the query.
select FCT.* from (SELECT
NVL(DD.DATE_KEY,1855) AS DATE_KEY,
DP.PRODUCT_KEY AS PRODUCT_KEY,
DP.VENDOR_KEY AS VENDOR_KEY,
DP.VENDOR_CODE AS VENDOR_CODE,
COUNT(DISTINCT FPL.PO_NO) AS PO_ASSIGNED,
SUM(FPL.PO_TOT_QTY) AS UNIT_ASSIGNED,
COUNT(DISTINCT FVL.PO_NO) AS PO_RECEIVED,
SUM(VO_TOT_RECD_QTY) AS UNIT_SHIPPED,
[code]....
I'm trying to call an help file with the following
BEGIN
Win_API_Shell.WinHelp
('C:eindwerkorainfo.hlp' ,
null ,
WIN_API.HELP_INDEX ,
TRUE );
END;
DK2KWUTIL.pll is attached to the form, info.hlp is an existing file in the path C:eindwerkora.
But it keeps giving me the following error:
FRM-40734: Internal error: PL/SQL error occurred.
Recently i have faced the error ora-600[kcbgtcr_12]. oracle suggested in the note (5523799.8) to flush the buffer cache by executing below command. My database version 9.2.0.8
1) to flush the buffer cache: alter session set events 'immediate trace name flush_cache level 1'
is this command for flushing the buffer cache ? if so what will be the impact if we flush the buffer cache ?
==> linux advance server 2
==> Oracle 9.2.0.1
I received this error in my alert logfile.
ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []
TRC file out:
====================================
Oracle program name: oracle@ABCxxx
*** 2006-02-07 09:08:01.340
ksedmp: internal or fatal error
[code]...
i am receiving ora-00600: internal error code, arguments :[729], [163624], [space leak], [],[], [], about this error and what can damage it can cause .we have one issue that is our application is slow for some time and then get normalk
View 3 Replies View RelatedI have a merge statement in one procedure , this job runs on daily . It is running successfully since Jan-19-2010 and giving the below error now.
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcbgcur_9], [4224596], [1],
[4294967250], [2], [], [], []
It is giving error in the beginning of the MERGE statement.
I have a tabular form, when salve at data, works fine. But when update at data following error occurs: Error in mru internal routine: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum.
View 4 Replies View Relatedi have oracle database 10g with RAC. Before this, we upgrade our storage and completed the process. After bring up our database and it's ok.
But the problem is, when i try connect our database using ODI then database hang and i got error closed connection. When i checked details in alert.log, i got error - ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [].
I'm facing this error: FRM-91120: Internal Error: Unable to load NLS character set
when I try to run command runform50.
I've set my NLS_LANG to American_America.WE8ISO8859P1 (which the the same as my DB),
I've set the ORA_NLS33, ORA_NLS32 and ORA_NLS vars to /usr/oracle/OraHOme1/ocommon/nls/admin/data
I've set the NLSPATH to /usr/lib/nls/msg/%L/%N
If I run runform50 command without any options, it shows me the help file, so I think it is correctly installed..
I guess the same thing as you're probably thinking .. that I'm missing some charset ... but where ? they should be in ocommon/nls dir ? if so, I've already installed pretty much everything of the developer2000 cd
Using the Bulk collect for insert into table,it's raising the below error.
ORA-00600: internal error code, arguments: [25027], [130], [1], [], [], [], [], [], [], [], [], []
After googling a lot, I really don't know what may have caused this problem when I'm shutting the DB,I'm running oracle on version 10.2.0.3.0 on Win Server 2003 Enterprise SP2.
Part of the alert.log:
Mon Sep 26 07:00:49 2011
Starting background process EMN0
EMN0 started with pid=27, OS id=5192
Mon Sep 26 07:00:49 2011
[code]...
Part of the file teste_ora_5000.trc:
FREELIST CHUNK COUNT:3192 OBJECT SIZE:36
LATCH:1 TOTAL SPACE: 114912
FREELIST CHUNK COUNT:3190 OBJECT SIZE:36
LATCH:2 TOTAL SPACE: 119016
[code]...
Version of Oracle: 9.2.0.8.0 Enterprise edition
Running on Windows 2003 Server
No catalog
Backup controlfile and database work great.
Cannot run backup archivelog all command. I did check metalink but was not able to find this error / bugggh.
RMAN-03002 failure of backup command at 07/24/2012
Rman-00600 internal error, arguments [9018] [7] [] [] []
I work with Developer 2000/Report Builder Oracle 8i...When I try to save a report in any format whether RTF or HTML it says:PDE-PER001 Internal error (REP3335: Unhandled Internal CA Error depep 2) ...Some reports can be saved,some not,especially those reports that have a PARAMETER FORM
View 3 Replies View RelatedWhen i am compiling the form11g this error came "ORA-01041: internal error hostdef extension doesn't exist "
View 6 Replies View Related i want to mount the database through sql> startup mount exclusive; for flashback the database, then sqlplus shows 2 errors---
"ORA-24324: service handle not initialized" and
"ORA-01041: internal error. hostdef extension doesn't exist"
how to sort out these errors.i am using 11.2.0.1.0 on widows server2008.
Error is occurred during the transaction...i.e.
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [89], [83], [], [], [], [], []
I have configured data guard in the windows XP same server .It is not able to apply log to the Standby database.when I queried the following, I go the following erros..
sql>select message from v$dataguard_status where dest_id=2;
FAL[server, ARC0]: Error 12514 creating remote archivelog file 'STNDBY'
PING[ARCk]: Heartbeat failed to connect to standby 'STNDBY'. Error is 12528.
LGWR: I/O error 1089 archiving log 1 to 'STNDBY'
"ARCk: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)
"
"ARCk: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
"
PING[ARCk]: Error 3113 when pinging standby STNDBY.
"LNS: Closing remote archive destination LOG_ARCHIVE_DEST_2: 'STNDBY' (error 1089)
"
LGWR: Error 1041 closing archivelog file 'STNDBY'
************************************************
Also if
SQL> select sequence#,applied from v$archived_log;
query gives the following message----
SEQUENCE# APP
---------- ---
7 YES
5 NO
8 NO
9 NO
6 NO
10 NO
10 NO
11 NO
11 NO
12 NO
12 NO
i've been trying to connect to the Oracle DB with Oracle SQL Developer.I get a message
State: Test Failed - IO Exception "The network adapter could not establish the connection"
When i go try tnsping 1521 It detects a connection by Oracle Database.And finally i get TNS-03505: Failed to resolve name
When i went into the "services.msc" and tryed to run the "OracleOraDb10g_home1TNSListener"
Got a message: "Error 3: The sytem could not find the specified path"
Below error getting in alert log file every day,but database is working fine.
What are the reason for this error?
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 28-MAY-2012 19:20:02
Tracing not turned on.
Tns error struct:
ns main err 12535
[code]....
We have a query which uses start by and connect with method. this query works fine in our earlier version 10. But when we migrated to 11g, we are facing problem with the query.
Scenario 1:
------------
There is a table in Schema 1 and created a view for the same.
Table : create table alias_test1 ( A varchar2(10),B varchar(10),C varchar2(20),D varchar2(40), E varchar2(10),F number(1));
View: create or replace view alias_vw1
as select A, B,C,D, E,F from alias_test1
Values :
Insert into A.ALIAS_TEST1 (A, B, C, D, E, F)
Values ('Block1', '136', 'TOTBANK', 'Total Bank', ' ', 1);
Insert into A.ALIAS_TEST1 (A, B, C, D, E, F)
Values ('Block2', '136', 'PPRSEGHKB', 'HKB', 'TOTBANK', 2);
Now in the schema B, created a synonym for the view to access. create synonym alias_vw1 for alias_vw1@link.world
Query :
select srl_no,cde,pdesc,lvl,is_leaf,hcy
from( select srl_no,
cde, pdesc, level lvl,
connect_by_isleaf is_leaf,
Ltrim(replace(sys_connect_by_path (rpad(Trim(cde),19,' '),'~'),'~',' ')) hcy
[code]...
I have written a trigger as below:
CREATE OR REPLACE TRIGGER LOGONTRIG
AFTER LOGON ON DATABASE
DECLARE
v_temp NUMBER;
V_bypass_trg_flag VARCHAR2(1);
[code],...
This trigger got successfully compiled. and when am trying to connect to the db with other user its giving me error "ora-06512 : at dbms_session".When i grant dba privillage to that user am successfully able to login to db.
We installed Oracle 10g on one of our servers and configured the listener to host=localhost. Here's our listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
[code]...
After restarting the listener, we could connect using the connect identifier from the local server. However, when trying to connect from a remote client we received the error of "no listener". In the remote client the identifier is defined with host=ip_address. TNSping from the client to the host was successful.
When we changed listener.ora to host=up_address we could connect ONLY from the remote computer. Only after changing the host in tnsnames.ora file to the IP as well - we could connect from both the local server and the remote client.
I usually use host=localhost in the listener file (and the local tnsnames file) and never had this problem before.
I have a problem with my Oracle istance and so far I couldn't fix it, I have and Oracle 11g XE istance running on windows server 2003.A couple of days ago I received the error message "ORA-00257: archiver error".I found tips in this forum and wanted to apply but sqlplus doesn't recognize my SYS user/password. I type the correct password but no chance to log in.
If I try to connect using a client like Toad, I receive the message ORA-12170: TNS:Connect timeout occurred. I checked the firewall rules, but it's ok, moreover I was logging in in the past and any change has been performed on it. I learned it's possible to change SYS password.
If I connect as "/ as sysdba" on sqlplus I read "Connected to an idle istance".In order to connect as "/" I had to update sqlnet.ora and restart the service. The parameter SQLNET.AUTHENTICATION_SERVICES
was set as NONE ad I set as NTS. I should probably have to set it as ALL? I found out the orapwd utility to change SYS password throught password file for remote login as sysdba.
I tried to create that file, and when I ran the command it asked me the SYS password, I typed it and it created the file, so I guess the password I type is correct (I had the question to type it wrong). I didn't go to the next step as I wasn't sure to make the right thing and I don't want to make this issue bigger.
As long as I can't log in as sysdba I can't perform the actions mentioned in tips to fix the error 257, but I'm also wondering if the archive error can have a side effect and deny the action of update the SYS password.
I am seeing this in my alert log at the rate of once in a month.
View 1 Replies View RelatedI am getting bellow error message when trying to connect Sybase through Sql developer: status:failure-test failed:IO Error:The network adapter
View 1 Replies View RelatedI'm getting this information in sqlnet.log file lying at D:oracleoradatadatabase
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclemaninder)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')) (CONNECT_DATA=(SID=maninder)(CID=(PROGRAM=d:oracleora92inORACLE.EXE)(HOST=SAI-E6C10175EE4)(USER=OraUser))))
[code]...