Standby Database not automatically startup issue

What is the value of REMOTE_LOGIN_PASSWORDFILE parameter?

Please change the owner of the Oracle process
Start->Settings->Control Panel->Services
Locate and highlight the "OracleServiceSID"
Click on the "Startup" button
In the "Log On As", choose "This Account"
Use the "..." button to browse to the "OracleAdmin" or Administrator user
Choose in "List Names From" your host
Provide the password of this user and confirm it
Repeat for the "OracleStartSID", "OracleTNSListener" and any
other Oracleservice you are using.
Be sure that the service startup is "Automatic"


ORA_<SID>_AUTOSTART =
ORA_<SID>_PFILE =
ORA_<SID>_SHUTDOWN =
ORA_<SID>_SHUTDOWNTYPE =
ORA_<SID>_SHUTDOWN_TIMEOUT =



Research:
=========
WIN: Automatic Startup of the Database when Using O/S Authentication ( Note 116979.1 )
How to configure Database Control to Start Automatically on Server Reboot / Shutdown Note 1282530.1
Windows Service Not Starting Automatically At Server reboot ( Doc ID 1264404.1 )

tns-04414 DBCA 12c

check entry of tnsnames.ora

already exist in creating DB

remove all

LD Login Error Table Definitions have undergone a change

select table_name from dba_tables where owner='LDBO' and temporary = 'Y' and table_name='TBLTEMPOPERATIONSTATISTICS';

DRop TABLE "LDBO"."TBLTEMPOPERATIONSTATISTICS" ;

  CREATE GLOBAL TEMPORARY TABLE "LDBO"."TBLTEMPOPERATIONSTATISTICS"
   ( "NOPERCODE" NUMBER(3,0),
"NSUBCODE" NUMBER(3,0),
"COPERATIONNAME" VARCHAR2(100 BYTE),
"CSTARTTIME" DATE,
"CENDTIME" DATE,
"NTOTALROWS" NUMBER(12,0),
"NINITIALROWS" NUMBER(12,0),
"NFETCHROWS" NUMBER(12,0)
   ) ON COMMIT PRESERVE ROWS ;

ORA-00322 ORA-00312

ORA-00322 ORA-00312
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_ora_10232.trc:
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1: 'E:\RKDATABASE\REDO03.LOG'


recover database using backup controlfile;
E:\RKDATABASE\REDO03.LOG
ALTER DATABASE OPEN RESETLOGS;

EXPDP Privileges ORA-31631 ORA-39161

create user expdpuser identified by expdpuser default tablespace usr temporary tablespace temporary;
grant connect, resource, exp_full_database,IMP_FULL_DATABASE to expdpuser;

grant all on directory to expdpuser;

grant connect, resource, exp_full_database to ldbo; 

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
;