ORA-00980: synonym translation is no longer valid

select * from dba_synonyms s
where table_owner not in('SYSTEM','SYS')
and db_link is null
and not exists
(select 1
from dba_objects o
where s.table_owner=o.owner
and s.table_name=o.object_name);

ORA-01172 ORA-01151

ORA-01172: recovery of thread 1 stuck at block 45 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed

shut immediate
startup mount
recover database;
alter database open;

Please Check Connection Or Data is huge

There is some issue in one of the services so browse all services one by one

1) some one restart IIS at time of report generation
2) Less memory at server

if there is occur only particular machine then check the same another browser like firefox

LD ..Addon..API....Login Issue..... Unable to fetch IP Address

$-------------------------------------- Begin ---------------------------------------------$
Client code :
Title       : INIT CONNECTION
Message     :
StackTrace  : 01~Unable to Fetch IP Address.
Computer    : ANIL-PC
Processor   : 4
OS Version  : Microsoft Windows NT 6.1.7600.0
Memory      : 168865792
Shut down   : N
Username    : DefaultAppPool
Date/Time   : 11/9/2015 3:09:40 PM
Connection  : Closed
===========================================================================================

New Splogin

SELECT UTL_INADDR.get_host_address from dual;

host file

SELECT TERMINAL FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID')  AND  AUDSID != 0 AND  ROWNUM = 1;  

SELECT PROGRAM,MODULE FROM SYS.V_$SESSION

      WHERE  AUDSID = USERENV('SESSIONID')

    AND  AUDSID != 0  

    AND  ROWNUM = 1

 SELECT TBLTEMPOPERATIONSTATISTICS.COPERATIONNAME LCIPADDRESS FROM TBLTEMPOPERATIONSTATISTICS TBLTEMPOPERATIONSTATISTICS WHERE TBLTEMPOPERATIONSTATISTICS.NOPERCODE=-1 ;

LDADDON users are not visible in Menu Level Security

select d.user_id , d.username , d.password , d.profile , d.account_status , d.account_status  from dba_users d where  d.default_tablespace='USR' order by d.user_id  ;


alter user <username> default tablespace USR;

ORA-06502 PLSQL numeric or value error character to number conversion error ORA-06512 at LDBO.SP_SERSEQ

SELECT voucher FROM LEDGER WHERE FIRMNUMBER='APXC-00001' and voucher like '%JV%' and Regexp_Like((SUBSTR(VOUCHER,-7,7)), '[[:alpha:]]');

SELECT MAX(SUBSTR(VOUCHER,-7,7)) FROM LEDGER WHERE FIRMNUMBER='APXC-00001' and voucher like '%JV%' and Regexp_Like((SUBSTR(VOUCHER,-7,7)), '[[:alpha:]]');
result should be numeric

import table all space vanish impdp insert into

remove storage parameter when create table

ora-14450 ora-14452 global temporary table attempt to access a transactional temp table already in use

SELECT
distinct
ss.program "SOFTWARE",
SS.TERMINAL,
       ss.username "USER",
'alter system disconnect session ''' || ss.sid || ',' || ss.serial# || ',@' || ss.inst_id || ''' immediate;'
  fROM gv$process pr, gv$session ss, gv$sqlarea sqa,
(select  sid
  from  gv$lock
  where id1 = (
               select  object_id
                 from  dba_objects
                 where owner = 'LDBO'
                   and object_name = 'TBLTEMPTRADESTATUS'))tbllock
 WHERE pr.addr = ss.paddr
   AND ss.username is not null
   AND ss.sql_address = sqa.address(+)
   AND ss.sql_hash_value = sqa.hash_value(+)
and ss.inst_id=pr.inst_id
and ss.sid = tbllock.sid
;

ACCESS_VIOLATION, UNABLE_TO_READ

Increase SGA_MAX_SIZE and SGA_TARGET

ORA-00904 invalid identifier

column is missing

but column is there

query is run

but in procedure it gives error


Solution
some one add column from plsql
may be case issue

so drop and recreate column

ORA-29913 ORA-29400 KUP-04080

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

KUP-04080: directory object XMLDIR not found



cllvl@
select * from ldbo.TBLFTXTERNTEMP_DEALER

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

KUP-04080: directory object XMLDIR not found



grant read, write on directory xmldir to cllvl;

Error while trying to retrieve text for error ORA-01019

Error while trying to retrieve text for error ORA-01019

VFP connection issue


check oracle path in Env Var

remove 11g path keep 10g path in starting

tns-03505 failed to resolve name

remove entry from sqlnet.ora


#SQLNET.AUTHENTICATION_SERVICES= (NONE)

#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

HTTP Error 404.3 - Not Found

enter "cd c:\windows\Microsoft.Net\Framework\v3.0\Windows Communication Foundation\" and press Enter.

Enter "ServiceModelReg -i" and press Enter.

WCF will now be installed:

ORA-02022 remote statement has unoptimized view with remote object sqlserver merge command issue

This kind of statement is not supported by the Database Gateway.
Please review the Gateway documentation (http://docs.oracle.com/database/121/GMSWN/ch3.htm#GMSWN200) :
----------------------------------------------------------------------------------------------------------------
Callback Support
SQL statements that require the gateway to callback to Oracle database would not be supported.

The following categories of SQL statements will result in a callback:

Any DML with a sub-select, which refers to a table in Oracle database. For example:
INSERT INTO emp@non_oracle SELECT * FROM oracle_emp;



ORA-02022 remote statement has unoptimized view with remote object

following is not supported in oracle
insert into tblDematDetails@Lnk_Datum (Oowncode) select Clientocode from demat where vallan=2015062 and compcode=17140
;

oracle sql server datetime overflow

use to_char

    select to_char(Markethistory.Dtoftran,'DD-MM-YYYY') from Markethistory;

LD Addon Institutional Contract Document does not exist error

change work process to 7 to 1

ORA-02070 error insert data into SQL Server

insert into vc@odbc ("c1") values (current_timestamp);
ORA-02070: database ODBC does not support operator 293 in this context


insert into vc@odbc ("c1") values (sysdate);
ORA-02070: database ODBC does not support special functions in this context


We worked around this issue in the following way:

We created this SQL Server table:
create table vc ( c0 int IDENTITY(1,1) NOT NULL, c1 datetime, primary key (c0))


Next, we tried to run one of the INSERT statements shown above but got the ORA-02070 error. To work around this, we passed the contents of the function into a data store and then passed the data store to the INSERT statement. For example:

DECLARE
d1 date;
BEGIN
select sysdate into d1 from dual;
INSERT INTO vc@odbc ("c1") values (d1);
END;/

PL/SQL procedure successfully completed.

SQL> select * from vc@odbc;

        c0 c1
---------- ---------
         1 03-MAR-14

ORA-06508 PLSQL could not find program unit being called

select object_name from user_objects where object_type='PACKAGE'
MINUS
select object_name from user_objects where object_type='PACKAGE BODY';

ora-01502 index unusable state

SELECT 'ALTER INDEX '||OWNER||'.'||INDEX_NAME||' REBUILD;'
FROM DBA_INDEXES
WHERE STATUS = 'UNUSABLE';