Symptom
Receiving POP email error on send and receive - POP mailbox is locked. Cannot receive new messages.
Cause
A mail client is attempting to access a locked POP account.
Solution
Close the mail client and reboot. Wait at least 10 minutes before opening the mail client again. (The reboot may not be needed but ensures that the application thoroughly quits.) If this does not resolve the issue please contact the Technology Support Center.
Additional Info
When a mail client connects to the POP server it locks the POP account. When the mail client has completed its tasks it issues a QUIT command to the POP server which unlocks the account. If no QUIT signal is issued and the connection remains idle for 10 minutes, the account is unlocked automatically. If mutliple computers are trying to access the POP account at the same time, this could cause the mailbox to be locked and inaccessible. Also, if the refresh rate for send/receive is more frequent than 10 minutes and a message hangs for some reason, then the server will remain locked for 10 minutes. Likewise if a client accesses the mailbox and the receive is cancelled prior to completion, the server may remain locked. The server will unlock the account automatically after 10 minutes and at that time the mail client should be able to reconnect.
Wednesday, January 27, 2016
ORA-00204 ORA-00202 ORA-27070 OSD-04006
recreate pfile
remove corrupted controlfile
and startup using pfile
Getting Error Running Sql ID ORA-01722 Invalid Number
SYMPTOMS
In Oracle Balance & Control, you get the following error when running a SQL ID:
ORA-01722: invalid number
As a result, the expected data is not updated by the SQL ID.
CAUSE
Null values exist in columns accessed by the code in the SQL ID.
SOLUTION
Review all columns accessed by the code in the SQL ID for null values. Update NULL values to zero or another appropriate number value.
Example:
select count(*) from mortgages where origination_fee is NULL;
update mortgages set origination_fee=0 where origination_fee is NULL;
1. We should try to avoid implicit conversion.
2. We should compare with same datatypes.
3. While comparing different datatypes, we should first do explicit conversion.
4. We should not store numbers in varchar2 fields.
5. We should convert the expression to number before comparing it with number.
In Oracle Balance & Control, you get the following error when running a SQL ID:
ORA-01722: invalid number
As a result, the expected data is not updated by the SQL ID.
CAUSE
Null values exist in columns accessed by the code in the SQL ID.
SOLUTION
Review all columns accessed by the code in the SQL ID for null values. Update NULL values to zero or another appropriate number value.
Example:
select count(*) from mortgages where origination_fee is NULL;
update mortgages set origination_fee=0 where origination_fee is NULL;
1. We should try to avoid implicit conversion.
2. We should compare with same datatypes.
3. While comparing different datatypes, we should first do explicit conversion.
4. We should not store numbers in varchar2 fields.
5. We should convert the expression to number before comparing it with number.
ORA-02055 ORA-20014 ORA-06502
declare
lncount number;
begin
-- Call the procedure
sp_impcodweb(oresult => :oresult,
imuact => :imuact,
infirmnumber => :infirmnumber,
icfilename => :icfilename,
icfiledirectory => :icfiledirectory,
icsrcfile => :icsrcfile,
icfiletime => :icfiletime,
icoutfile => :icoutfile);
dbms_output.put_line(:oresult);
Select Count(*)
into lncount
From Tbltempcoddetails
Where Nfirmnumber = :infirmnumber
And Ninstructiontype = 904
And Ntransactiontype = -99;
dbms_output.put_line(lncount);
Merge Into Tbl904offmarket T1
Using (Select Nfirmnumber,
Cclientboid,
Dtransactiondate,
Nnsdldpmtransactionno,
Cisincode,
Ctranstatus
From Tbltempcoddetails
Where Nfirmnumber = :infirmnumber
And Ninstructiontype = 904
And Ntransactiontype = -99) t
On (T1.Nfirmnumber = t.Nfirmnumber And T1.Cclientboid = t.Cclientboid And T1.Dexecutiondate = t.Dtransactiondate
And T1.Cisincode = t.Cisincode And To_Number(Trim(T1.Cinstructionreferenceno)) = t.Nnsdldpmtransactionno)
When Matched Then
Update Set T1.Ctranstatus = t.Ctranstatus;
Dbms_Output.Put_Line(To_Char(Sql%Rowcount) || ' rows merged. Sudi');
end;
/
Error invalid number at line -- Merge Into Tbl904offmarket T1
1) solution
select t1.Cinstructionreferenceno from Tbl904offmarket t1 WHERE REGEXP_LIKE(t1.Cinstructionreferenceno, '[[:alpha:]]')
select to_number(t1.Cinstructionreferenceno0 from Tbl904offmarket t1 WHERE REGEXP_LIKE(t1.Cinstructionreferenceno, '[[:alpha:]]')
2)
CREATE OR REPLACE FUNCTION IS_NUMBER (p_input IN VARCHAR2) RETURN NUMBER
AS
BEGIN
RETURN TO_NUMBER (p_input);
EXCEPTION
WHEN OTHERS THEN RETURN NULL;
END IS_NUMBER;
/
CREATE OR REPLACE FUNCTION IS_NUMBER (p_input IN VARCHAR2) RETURN NUMBER
AS
BEGIN
RETURN TO_NUMBER (p_input);
EXCEPTION
WHEN OTHERS THEN RETURN 0;
END IS_NUMBER;
/
lncount number;
begin
-- Call the procedure
sp_impcodweb(oresult => :oresult,
imuact => :imuact,
infirmnumber => :infirmnumber,
icfilename => :icfilename,
icfiledirectory => :icfiledirectory,
icsrcfile => :icsrcfile,
icfiletime => :icfiletime,
icoutfile => :icoutfile);
dbms_output.put_line(:oresult);
Select Count(*)
into lncount
From Tbltempcoddetails
Where Nfirmnumber = :infirmnumber
And Ninstructiontype = 904
And Ntransactiontype = -99;
dbms_output.put_line(lncount);
Merge Into Tbl904offmarket T1
Using (Select Nfirmnumber,
Cclientboid,
Dtransactiondate,
Nnsdldpmtransactionno,
Cisincode,
Ctranstatus
From Tbltempcoddetails
Where Nfirmnumber = :infirmnumber
And Ninstructiontype = 904
And Ntransactiontype = -99) t
On (T1.Nfirmnumber = t.Nfirmnumber And T1.Cclientboid = t.Cclientboid And T1.Dexecutiondate = t.Dtransactiondate
And T1.Cisincode = t.Cisincode And To_Number(Trim(T1.Cinstructionreferenceno)) = t.Nnsdldpmtransactionno)
When Matched Then
Update Set T1.Ctranstatus = t.Ctranstatus;
Dbms_Output.Put_Line(To_Char(Sql%Rowcount) || ' rows merged. Sudi');
end;
/
Error invalid number at line -- Merge Into Tbl904offmarket T1
1) solution
select t1.Cinstructionreferenceno from Tbl904offmarket t1 WHERE REGEXP_LIKE(t1.Cinstructionreferenceno, '[[:alpha:]]')
select to_number(t1.Cinstructionreferenceno0 from Tbl904offmarket t1 WHERE REGEXP_LIKE(t1.Cinstructionreferenceno, '[[:alpha:]]')
2)
CREATE OR REPLACE FUNCTION IS_NUMBER (p_input IN VARCHAR2) RETURN NUMBER
AS
BEGIN
RETURN TO_NUMBER (p_input);
EXCEPTION
WHEN OTHERS THEN RETURN NULL;
END IS_NUMBER;
/
CREATE OR REPLACE FUNCTION IS_NUMBER (p_input IN VARCHAR2) RETURN NUMBER
AS
BEGIN
RETURN TO_NUMBER (p_input);
EXCEPTION
WHEN OTHERS THEN RETURN 0;
END IS_NUMBER;
/
procedure must be declared
in application ldbo. is missing before procedure
role is missing for that procedure
Alternative: if you create public synonym for that it will work
Windows 7 Disk is not accessible. Access is denied.
Resolution
In order to resolve this issue, go to the Windows Explorer and follow the below mentioned steps.
Right-click on the inaccessible hard drive.
Click Properties.
Go to the Security tab, and then click Advanced.
Click ‘Edit’ by going to the Owner tab.
Modify the ownership of the desired account.
Alternatively, you can also try the following option, if you are not able to access any file or folder on a Windows 7 drive.
Right-click on the inaccessible file or folder.
Click Properties.
Select the Security tab.
Click your name Under Group or user name. This would show you the permissions you have to access the file and folder.
You can also try the following method
Change the drive letter for inaccessible hard drive.
Run the following command: chkdsk /r I:
Try to boot into the safe mode and access the HDD.
Try accessing the HDD in Windows 7 Ultimate and Home Premium.
You will be able to access the drive, as chkdsk command would have deleted the files that were causing the problem.
In order to resolve this issue, go to the Windows Explorer and follow the below mentioned steps.
Right-click on the inaccessible hard drive.
Click Properties.
Go to the Security tab, and then click Advanced.
Click ‘Edit’ by going to the Owner tab.
Modify the ownership of the desired account.
Alternatively, you can also try the following option, if you are not able to access any file or folder on a Windows 7 drive.
Right-click on the inaccessible file or folder.
Click Properties.
Select the Security tab.
Click your name Under Group or user name. This would show you the permissions you have to access the file and folder.
You can also try the following method
Change the drive letter for inaccessible hard drive.
Run the following command: chkdsk /r I:
Try to boot into the safe mode and access the HDD.
Try accessing the HDD in Windows 7 Ultimate and Home Premium.
You will be able to access the drive, as chkdsk command would have deleted the files that were causing the problem.
ORA-29264 unknown or unsupported URL scheme
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-29264: unknown or unsupported URL scheme
Error: ORA-29264 (ORA-29264)
Text: unknown or unsupported URL scheme
---------------------------------------------------------------------------
Cause: The URL scheme was unknown or unsupported.
Action: Check the URL to make sure that the scheme is valid and
supported.
Please remove any leading or trailing characters (space, enter etc) in the profile's value.
The code works fine when
i use
http://www.***.com/image?imageid=1234 worked
but when i use
http://www.finance.***.com/image?imageid=1234
I fails with the specified error.
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-29264: unknown or unsupported URL scheme
Error: ORA-29264 (ORA-29264)
Text: unknown or unsupported URL scheme
---------------------------------------------------------------------------
Cause: The URL scheme was unknown or unsupported.
Action: Check the URL to make sure that the scheme is valid and
supported.
Please remove any leading or trailing characters (space, enter etc) in the profile's value.
The code works fine when
i use
http://www.***.com/image?imageid=1234 worked
but when i use
http://www.finance.***.com/image?imageid=1234
I fails with the specified error.
ORA-29273 ORA-06512 ORA-29259
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-29259: end-of-input reached
ORA-06512: at line 1
Error: ORA-29259 (ORA-29259)
Text: end-of-input reached
---------------------------------------------------------------------------
Cause: The end of the input was reached.
Action: If the end of the input is reached prematurely, check if the
input source terminates prematurely. Otherwise, close the
connection to the input.
Please remove any leading or trailing characters (space, enter etc) in the value.
The issue was with proxy setting.
Once the UTL_HTTP.SET_PROXY was set appropriately, I no longer get the end-of-input error.
URL is not properly set
CAUSE
The site that is accessed via utl_http requires mutual authentication.
SOLUTION
This is not possible in 10g . This was implemented in 11g only.
SELECT * FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME = 'LD_AD_IE_SPAN_NSEF_BPL-4' ORDER BY 2 DESC;
SELECT UTL_HTTP.REQUEST ('http://172.168.1.104') FROM DUAL;
SELECT * FROM TABLE(DBMS_NETWORK_ACL_UTILITY.domains('172.168.1.104'));
select utl_http.request('https://marc.charpentier.com/ws/services/Payment?wsdl',NULL,'file:E:\wallet','******') from dual;
recreate ACL privileges
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-29259: end-of-input reached
ORA-06512: at line 1
Error: ORA-29259 (ORA-29259)
Text: end-of-input reached
---------------------------------------------------------------------------
Cause: The end of the input was reached.
Action: If the end of the input is reached prematurely, check if the
input source terminates prematurely. Otherwise, close the
connection to the input.
Please remove any leading or trailing characters (space, enter etc) in the value.
The issue was with proxy setting.
Once the UTL_HTTP.SET_PROXY was set appropriately, I no longer get the end-of-input error.
URL is not properly set
CAUSE
The site that is accessed via utl_http requires mutual authentication.
SOLUTION
This is not possible in 10g . This was implemented in 11g only.
SELECT * FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME = 'LD_AD_IE_SPAN_NSEF_BPL-4' ORDER BY 2 DESC;
SELECT UTL_HTTP.REQUEST ('http://172.168.1.104') FROM DUAL;
SELECT * FROM TABLE(DBMS_NETWORK_ACL_UTILITY.domains('172.168.1.104'));
select utl_http.request('https://marc.charpentier.com/ws/services/Payment?wsdl',NULL,'file:E:\wallet','******') from dual;
recreate ACL privileges
TNSaddress already in use ora12542
1)
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Determines the time that must elapse before TCP can release a closed connection and reuse its resources. This interval between closure and release is known as the TIME_WAIT state or 2MSL state. During this time, the connection can be reopened at much less cost to the client and server than establishing a new connection.Value Name: MaxUserPort
Type: REG_DWORD
Value: 65534
2)
TcpTimedWaitDelay
Value Type: REG_DWORD
Value: 30
3)
netsh interface tcp show global
netsh int tcp set global autotuninglevel=disabled
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Determines the time that must elapse before TCP can release a closed connection and reuse its resources. This interval between closure and release is known as the TIME_WAIT state or 2MSL state. During this time, the connection can be reopened at much less cost to the client and server than establishing a new connection.Value Name: MaxUserPort
Type: REG_DWORD
Value: 65534
2)
TcpTimedWaitDelay
Value Type: REG_DWORD
Value: 30
3)
netsh interface tcp show global
netsh int tcp set global autotuninglevel=disabled
ORA-08104 this index object 4145783 is being online built or rebuilt
*
ERROR at line 1:
ORA-20000: this index object "LDBO"."IDXCONTRACTBILL" is being online built or
rebuilt
ORA-06512: at "SYS.DBMS_STATS", line 23829
ORA-06512: at "SYS.DBMS_STATS", line 23880
ORA-06512: at line 1
SQL>
SQL>
SQL>
SQL> E
this index object is being online built or rebuilt
Cause:
A session failure during an online index rebuild can leave the data dictionary in a state reflecting a rebuild is on going when in fact it is not.
Solution:
The dbms_repair.online_index_clean function has been created to cleanup online index rebuilds. More details about the function on metalink – Session Was Killed During The Rebuild Of Index ORA-08104 [ID 375856.1]
Run the following to resolve:
declare
isclean boolean;
begin
isclean :=false;
while isclean=false
loop
isclean := DBMS_REPAIR.ONLINE_INDEX_CLEAN(dbms_repair.all_index_id,dbms_repair.lock_wait);
dbms_lock.sleep(10);
end loop;
end;
/
select min(object_id) from dba_objects where object_name = 'IDXCONTRACTBILL'
392745
declare
ret boolean;
begin
ret:=dbms_repair.ONLINE_INDEX_CLEAN(392745);
end;
/
exit
drop index LDBO.IDXCONTRACTBILL;
CREATE INDEX LDBO.IDXCONTRACTBILL ON LDBO.CONTRACTDETAILS (FIRMNUMBER,NFINANCIALYEAR,CONTRACT);
ALTER INDEX LDBO.IDXCONTRACTBILL REBUILD ONLINE;
ALTER INDEX LDBO.IDXCONTRACTINDEX REBUILD ONLINE;
exec DBMS_STATS.GATHER_TABLE_STATS (ownname => 'LDBO' , tabname => 'CONTRACTDETAILS',cascade => true, estimate_percent => 100,method_opt=>'for all columns size 254', granularity => 'ALL', degree => DBMS_STATS.DEFAULT_DEGREE, no_invalidate => false, force=> TRUE );
ALTER INDEX LDBO.IDXCONTRACTBILL REBUILD ONLINE pctfree 20;
ERROR at line 1:
ORA-20000: this index object "LDBO"."IDXCONTRACTBILL" is being online built or
rebuilt
ORA-06512: at "SYS.DBMS_STATS", line 23829
ORA-06512: at "SYS.DBMS_STATS", line 23880
ORA-06512: at line 1
SQL>
SQL>
SQL>
SQL> E
this index object is being online built or rebuilt
Cause:
A session failure during an online index rebuild can leave the data dictionary in a state reflecting a rebuild is on going when in fact it is not.
Solution:
The dbms_repair.online_index_clean function has been created to cleanup online index rebuilds. More details about the function on metalink – Session Was Killed During The Rebuild Of Index ORA-08104 [ID 375856.1]
Run the following to resolve:
declare
isclean boolean;
begin
isclean :=false;
while isclean=false
loop
isclean := DBMS_REPAIR.ONLINE_INDEX_CLEAN(dbms_repair.all_index_id,dbms_repair.lock_wait);
dbms_lock.sleep(10);
end loop;
end;
/
select min(object_id) from dba_objects where object_name = 'IDXCONTRACTBILL'
392745
declare
ret boolean;
begin
ret:=dbms_repair.ONLINE_INDEX_CLEAN(392745);
end;
/
exit
drop index LDBO.IDXCONTRACTBILL;
CREATE INDEX LDBO.IDXCONTRACTBILL ON LDBO.CONTRACTDETAILS (FIRMNUMBER,NFINANCIALYEAR,CONTRACT);
ALTER INDEX LDBO.IDXCONTRACTBILL REBUILD ONLINE;
ALTER INDEX LDBO.IDXCONTRACTINDEX REBUILD ONLINE;
exec DBMS_STATS.GATHER_TABLE_STATS (ownname => 'LDBO' , tabname => 'CONTRACTDETAILS',cascade => true, estimate_percent => 100,method_opt=>'for all columns size 254', granularity => 'ALL', degree => DBMS_STATS.DEFAULT_DEGREE, no_invalidate => false, force=> TRUE );
ALTER INDEX LDBO.IDXCONTRACTBILL REBUILD ONLINE pctfree 20;
TNS-12560 TNS protocol adapter error opiodr aborting process unknown ospid
Fatal NI connect error 12560, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 31-JAN-2015 15:52:27
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (11852) as a result of ORA-609
The Solution
Change the user account that the listener is running as to the same as the one that the database service runs as, restart the listener and this should resolve the issue.
dim-00019 create service error
set ORACLE_SID=orcl
oradim -new -sid ORCL -startmode manual -spfile
Enter password for Oracle service user: <PASSWORD IS ENTERED>
DIM-00019: create service error
O/S-Error: (OS 87) The parameter is incorrect.
You said "Even after deleting the service"
How have you been deleting the service ?
Check out if your service still exists at the registry level
1. regedit
2. go towards HKEY_LOCAL_MACHINE > SYSTEM > CURRENT CONTROL SET > SERVICES > and check the Oracle services.
If your service is still present > delete your service at this level
As a last resort you might want to reboot your server (if possible)
C:\>oradim -delete -sid cs62
C:\>oradim -new -sid cs62
C:\>set oracle_sid=cs62
C:\>sqlplus /nolog
oradim -new -sid orcl -intpwd orcl -startmode manual -pfile 'F:\oracle10g\pr
oduct\10.2.0\db_1\database\initorcl.ora'
Instance created.
DIM-00019: create service error
O/S-Error: (OS 2) The system cannot find the file specified.
Solution of the Problem
On linux environment you don't need these things. But in windows environment you need to do a lot of things more than restoring files. Whenever a windows OS gets corrupted you loose the Oracle Universal Installer repository and the regedit entries along with oracle home structure. So to solve the problem it is better to install new oracle software in your windows machine without any database and then create oracle instance and service using oradim.
oradim -new -sid ORCL -startmode manual -spfile
Enter password for Oracle service user: <PASSWORD IS ENTERED>
DIM-00019: create service error
O/S-Error: (OS 87) The parameter is incorrect.
You said "Even after deleting the service"
How have you been deleting the service ?
Check out if your service still exists at the registry level
1. regedit
2. go towards HKEY_LOCAL_MACHINE > SYSTEM > CURRENT CONTROL SET > SERVICES > and check the Oracle services.
If your service is still present > delete your service at this level
As a last resort you might want to reboot your server (if possible)
C:\>oradim -delete -sid cs62
C:\>oradim -new -sid cs62
C:\>set oracle_sid=cs62
C:\>sqlplus /nolog
oradim -new -sid orcl -intpwd orcl -startmode manual -pfile 'F:\oracle10g\pr
oduct\10.2.0\db_1\database\initorcl.ora'
Instance created.
DIM-00019: create service error
O/S-Error: (OS 2) The system cannot find the file specified.
Solution of the Problem
On linux environment you don't need these things. But in windows environment you need to do a lot of things more than restoring files. Whenever a windows OS gets corrupted you loose the Oracle Universal Installer repository and the regedit entries along with oracle home structure. So to solve the problem it is better to install new oracle software in your windows machine without any database and then create oracle instance and service using oradim.
LD Error building key for index
Error building key for index "c:\users\suprim~1.moh\appdata\local\temp\00004ftl001q.cdx" tag "Clrisk".
cursor_sharing should be exact
cursor_sharing should be exact
ORA 01950 no privileges on tablespace
Saved
Record Not Saved to DataBase ORA-01950: no privileges on tablespace 'USR'
ORA-06512: at "LDBO.SP_SCHEDULERSETUP", line 735
sb17271112
E:\ldoutput
SYS@FWS1213> grant unlimited tablespace to ldbo;
Grant succeeded.
SYS@FWS1213> ALTER USER LDBO QUOTA UNLIMITED on USR;
User altered.
SYS@FWS1213>
SYS@FWS1213> ALTER USER LDBO QUOTA UNLIMITED on INDX;
ALTER USER LDBO QUOTA UNLIMITED on USR;
ALTER USER LDBO QUOTA UNLIMITED on INDX;
grant unlimited tablespace TO LDBO;
Select Tablespace_Name, Username, Bytes / 1024 / 1024/ 1024 "Used GB", Max_Bytes / 1024 / 1024/ 1024 As "Max GB" from dba_ts_quotas;
select file_name,tablespace_name,bytes/1024/1024 "Size MB",status,autoextensible,maxbytes/1024/1024 "MaxSize MB",Increment_By from dba_data_files;
Record Not Saved to DataBase ORA-01950: no privileges on tablespace 'USR'
ORA-06512: at "LDBO.SP_SCHEDULERSETUP", line 735
sb17271112
E:\ldoutput
SYS@FWS1213> grant unlimited tablespace to ldbo;
Grant succeeded.
SYS@FWS1213> ALTER USER LDBO QUOTA UNLIMITED on USR;
User altered.
SYS@FWS1213>
SYS@FWS1213> ALTER USER LDBO QUOTA UNLIMITED on INDX;
ALTER USER LDBO QUOTA UNLIMITED on USR;
ALTER USER LDBO QUOTA UNLIMITED on INDX;
grant unlimited tablespace TO LDBO;
Select Tablespace_Name, Username, Bytes / 1024 / 1024/ 1024 "Used GB", Max_Bytes / 1024 / 1024/ 1024 As "Max GB" from dba_ts_quotas;
select file_name,tablespace_name,bytes/1024/1024 "Size MB",status,autoextensible,maxbytes/1024/1024 "MaxSize MB",Increment_By from dba_data_files;
TROUBLESHOOTING ORA-03135 connection lost contact from ODP.NET connections with connection pooling enabled
SYMPTOMS
ODP.NET applications that have connection pooling enabled (which is the default) may intermittently experience the following error:
ORA-03135: connection lost contact
CAUSE
The nature of connection pooling is that there are frequently long lived idle connections, which may end up being disconnected by 3rd party software such as firewalls and load balancers.
Typically the exception occurs when trying to use a connection via a DataReader, DataAdapter, OracleCommand, etc, rather than during the OracleConnection::Open call.
For ease of troubleshooting, often the behavior can be reproduced from a SQLPlus session if left idle long enough.
SOLUTION
The ideal solution is to address the issue in the environment to prevent the disconnect from occurring, however several workarounds can be employed:
1) Simply catch the exception, and retry the operation.
2) Use the ODP.NET connection string parameter "validate connection=true" By default, it is set to false, which means that no checking of the connection is done when it is retrieved from the pool as a result of a OracleConnection::Open call. Setting it to true will cause ODP.NET to verify that the connection is still good by making a database round trip. If a problem with the connection is found, it is removed from the pool, and another connection is tried internally.
Note that while this typically alleviates ora-3135, it does have performance implications as every con.Open call will result in a round trip to the database. The overhead may or may not be significant depending upon application performance, so testing should be done in your environment.
3) Enable Dead Connection Detection on the database, which will result in a probe packet being sent from database to client periodically, which will usually prevent the firewall or load balancer from seeing the connection as idle.
Note 151972.1 Dead Connection Detection (DCD) Explained
4) Connection pooling can be disabled entirely, but this will likely have a much larger performance impact. To disable connection pooling, add "pooling=false" to the connection string.
ODP.NET applications that have connection pooling enabled (which is the default) may intermittently experience the following error:
ORA-03135: connection lost contact
CAUSE
The nature of connection pooling is that there are frequently long lived idle connections, which may end up being disconnected by 3rd party software such as firewalls and load balancers.
Typically the exception occurs when trying to use a connection via a DataReader, DataAdapter, OracleCommand, etc, rather than during the OracleConnection::Open call.
For ease of troubleshooting, often the behavior can be reproduced from a SQLPlus session if left idle long enough.
SOLUTION
The ideal solution is to address the issue in the environment to prevent the disconnect from occurring, however several workarounds can be employed:
1) Simply catch the exception, and retry the operation.
2) Use the ODP.NET connection string parameter "validate connection=true" By default, it is set to false, which means that no checking of the connection is done when it is retrieved from the pool as a result of a OracleConnection::Open call. Setting it to true will cause ODP.NET to verify that the connection is still good by making a database round trip. If a problem with the connection is found, it is removed from the pool, and another connection is tried internally.
Note that while this typically alleviates ora-3135, it does have performance implications as every con.Open call will result in a round trip to the database. The overhead may or may not be significant depending upon application performance, so testing should be done in your environment.
3) Enable Dead Connection Detection on the database, which will result in a probe packet being sent from database to client periodically, which will usually prevent the firewall or load balancer from seeing the connection as idle.
Note 151972.1 Dead Connection Detection (DCD) Explained
4) Connection pooling can be disabled entirely, but this will likely have a much larger performance impact. To disable connection pooling, add "pooling=false" to the connection string.
Table statistics being locked after import export
Table statistics get locked when exporting only the table structures with DataPump. This situation is identified as an issue that occurs with Oracle 10.2. Using DataPump data is not exported or imported if the option CONTENT = METADATA_ONLY is set.
To resolve this there are two options listed on My Oracle Support.
1. After the import unlock the statistics for tables using the command:
execute DBMS_STATS.UNLOCK_TABLE_STATS('owner','table_name');
NOTE the statistics can also be unlocked at the schema level.
2. Do not import table statistics using the option EXCLUDE=TABLE_STATISTICS.
To resolve this there are two options listed on My Oracle Support.
1. After the import unlock the statistics for tables using the command:
execute DBMS_STATS.UNLOCK_TABLE_STATS('owner','table_name');
NOTE the statistics can also be unlocked at the schema level.
2. Do not import table statistics using the option EXCLUDE=TABLE_STATISTICS.
ORA-08103 object no longer exists
check alert log
block corruption
analyze validate structure
Doc ID 8103.1
You can try to drop and rebuild the index(es) and see whether it solves the problem.
UNDO_RETENTION
ORA-08103 object no longer exists
Cause: The object has been deleted by another user since the operation began. Or a prior incomplete recovery restored the database to a point in time during the deletion of the object
Action: Remove references to the object or delete the object if this is the result of an incomplete recovery.
http://www.dba-oracle.com/t_ora_08103_object_no_longer_exists.htm
There are several likely reasons for this error, and you should always check your alert log for details. This error often requires opening a service request with MOSC:
0: A software bug (see list below).
1: You are not signed-on as the table owner.
2: Database corruption of a header block.
3: Accidental delete of the target table. (check the recyclebin)
4: Data file I/O error (check alert log)
5: corruption in UNDO log (drop and re-create)
6. An index is disabled or is offline.
Possible solution include:
1: Set db_file_multiblock_read_count to 1.
2: Run dbv on all data files.
3: Run catalog.sql, catproc.sql and utlrp.sql to ensure no data dictionary corruption.
4: Purge recyclebin & dba_recyclebin.
5: When the ORA-08103 is on an index operation, place the index online or make index usable
select index_name , status from user_indexes;
INDEX_NAME STATUS
------------------------------ --------
IDX_CUST UNUSABLE
alter index idx_cust rebuild online;
more than 32678 bytes clob DBMS_LOB.GETLENGTH return null
can not input into clob
solution
use utl_file, generate and input
Go to Tools => Preferences from the menu.
Then click 'Output' (on the left side, in the 'Oracle' menu), and see if the 'Enabled' checkbox is checked or not...
lncount:= CEIL(DBMS_LOB.GETLENGTH(icJournaldetail)/256);
declare this
lcStr clob := icJournaldetail;
one partition has very high number of rows then how i split partition. Error ORA-14080 partition cannot be split along the specified high bound
Metalink :
ORA-14080 when trying to Split a Partition. [ID 100299.1]
Split lower and not higher.
ORA-14080 when trying to Split a Partition. [ID 100299.1]
Split lower and not higher.
Data pump export to a network mapped drive fails with ORA-39002 ORA-39070
It is working fine when both Server is in 2008 and above
wrong
create or replace directory z as 'Z:\backupset';
right
create or replace directory z as '\\172.16.1.36\c$\DB_Backup\backupset';
C:\Users\Administrator>expdp schemas=idencraft userid=system/sys directory=z logfile=data_pump_dir:log.log
Cause of the Problem
The CREATE DIRECTORY command used the drive letter, not the UNC naming convention (\\<server>\<sharepoint>).
In this example: CREATE DIRECTORY dump_dir AS 'Z:\backupset';
The account running the command does not have the necessary privileges to access the mapped network disk.
The user LOCAL SYSTEM normally will not have file system permissions or network permissions.
Solution
Oracle service runs under local system account by default and this local system account cannot see what you have mapped as the mappings are unique to each user account. You can check Start --> Run --> Services.msc --> OracleServiceXXXX ---> Properties --> Logon
The quick solution would be to run the Oracle service under the user account you used to create the mapping but this creates a couple of additional problems e.g. user account password expires or the account is locked.
Check if the mapping granted rights to oradba group
wrong
create or replace directory z as 'Z:\backupset';
right
create or replace directory z as '\\172.16.1.36\c$\DB_Backup\backupset';
C:\Users\Administrator>expdp schemas=idencraft userid=system/sys directory=z logfile=data_pump_dir:log.log
Cause of the Problem
The CREATE DIRECTORY command used the drive letter, not the UNC naming convention (\\<server>\<sharepoint>).
In this example: CREATE DIRECTORY dump_dir AS 'Z:\backupset';
The account running the command does not have the necessary privileges to access the mapped network disk.
The user LOCAL SYSTEM normally will not have file system permissions or network permissions.
Solution
Oracle service runs under local system account by default and this local system account cannot see what you have mapped as the mappings are unique to each user account. You can check Start --> Run --> Services.msc --> OracleServiceXXXX ---> Properties --> Logon
The quick solution would be to run the Oracle service under the user account you used to create the mapping but this creates a couple of additional problems e.g. user account password expires or the account is locked.
Check if the mapping granted rights to oradba group
ORA-29283 Using UTL_FILE On Windows
SYMPTOMS
Using UTL_FILE and attempting to perform a read or write on a file stored on a network resource on Windows using UNC notation like
\\myserver\myshare
fails with the following error:
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at line 4
CAUSE
The reason for this error may be for various reasons such as permissions or the network resource is unavailable.
SOLUTION
1. Verify the user that the Oracle Database is started as and verify the permissions for this network resource to ensure that the correct permissions have been set on the share.
2. Login as the same user that the database is started as and test the resource availability and access to files on the share for both reading and writing.
3. Verify the UTL_FILE_DIR database parameter or the database directory object are setup correctly and referencing the correct network resource.
TIP: Using Mapped drives is not recommended as this resource is only available when the user that created it is logged into the server. For most Windows Servers hosting Databases, this is not the normal use case scenario.
SOLUTION
The error can be raised because of the following causes.
General causes and solutions of ORA-29283 error:
1. Check whether the schema where the PLSQL code is run has READ,WRITE permission on the database directory.
If SCOTT is the schema , then login as SYS grant required permission.
GRANT READ,WRITE ON DIRECTORY <DIR_NAME> TO SCOTT
2. Check whether the path used in database directory physically exists on the OS.
Eg :
CREATE OR REPLACE DIRECTORY DIRNAME as '/home/test';
/home/test should exist on the OS. When the database directory is created , oracle doesnt check the validity of the directory path used. The validation of the path is done at the runtime. Hence it is necessary to check the file path on OS before the program is executed.
3. Check whether the owner of oracle process has enough permission on the OS directory where the file is accessed.
]$ ls -l /u01/app/oracle/product/10.2/db_1/bin/oracle
-rwsr-s--x 1 oracle oinstall 96725778 Jul 7 2008 /u01/app/oracle/product/10.2/db_1/bin/oracle
"oracle" is the owner of the oracle executable. oracle - user should have enough permission on the directory.
]$ su oracle
Password:
]$ whoami
oracle
]$touch /home/test/abc.txt
You should be able to create a file using touch command login as the owner of the oracle process.
4. Make sure you have restarted the listener once you have done any OS level changes to the directories accessed by RDBMS.
Once you have done any changes in OS level permission, you should always restart the listener so that it inherits the recently changed permission.
Else oracle will sometime raise a ora-29283 error.
5. Even though oracle-user has enough permissions on the directory, it may raise ora-29283 if the owner of the file is not oracle.
If the file is created with the rw-r-- permission and owned by another user, RDBMS wont be able to read the file. In such case you will have to change the permissions of the file to rw-rw--
chmod 750 <filename>
6. Using remote directories :
UTL_FILE package can access only server side files where the database instance is running. You cannot access client side files. If you are using UNIX system, then create a NFS mount of the client folder on the server . If on Windows platform then go through
Note 45172.1 : Running UTL_FILE on Windows NT
Note 1034188.6: INVALID_OPERATION Exception from UTL_FILE when Writing to/from Network Drive
Solution:
Start the Oracle service as a user who has the same permissions as SYSTEM, and also who has access to the shared directory.
7. Check ORA_NLS on application server :
If the ORA_NLSXX where XX is 32, 33 or 10 is set, it must be set before starting the database and on the client side too.
Note 77442.1 : ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment Variables explained
Using UTL_FILE and attempting to perform a read or write on a file stored on a network resource on Windows using UNC notation like
\\myserver\myshare
fails with the following error:
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at line 4
CAUSE
The reason for this error may be for various reasons such as permissions or the network resource is unavailable.
SOLUTION
1. Verify the user that the Oracle Database is started as and verify the permissions for this network resource to ensure that the correct permissions have been set on the share.
2. Login as the same user that the database is started as and test the resource availability and access to files on the share for both reading and writing.
3. Verify the UTL_FILE_DIR database parameter or the database directory object are setup correctly and referencing the correct network resource.
TIP: Using Mapped drives is not recommended as this resource is only available when the user that created it is logged into the server. For most Windows Servers hosting Databases, this is not the normal use case scenario.
SOLUTION
The error can be raised because of the following causes.
General causes and solutions of ORA-29283 error:
1. Check whether the schema where the PLSQL code is run has READ,WRITE permission on the database directory.
If SCOTT is the schema , then login as SYS grant required permission.
GRANT READ,WRITE ON DIRECTORY <DIR_NAME> TO SCOTT
2. Check whether the path used in database directory physically exists on the OS.
Eg :
CREATE OR REPLACE DIRECTORY DIRNAME as '/home/test';
/home/test should exist on the OS. When the database directory is created , oracle doesnt check the validity of the directory path used. The validation of the path is done at the runtime. Hence it is necessary to check the file path on OS before the program is executed.
3. Check whether the owner of oracle process has enough permission on the OS directory where the file is accessed.
]$ ls -l /u01/app/oracle/product/10.2/db_1/bin/oracle
-rwsr-s--x 1 oracle oinstall 96725778 Jul 7 2008 /u01/app/oracle/product/10.2/db_1/bin/oracle
"oracle" is the owner of the oracle executable. oracle - user should have enough permission on the directory.
]$ su oracle
Password:
]$ whoami
oracle
]$touch /home/test/abc.txt
You should be able to create a file using touch command login as the owner of the oracle process.
4. Make sure you have restarted the listener once you have done any OS level changes to the directories accessed by RDBMS.
Once you have done any changes in OS level permission, you should always restart the listener so that it inherits the recently changed permission.
Else oracle will sometime raise a ora-29283 error.
5. Even though oracle-user has enough permissions on the directory, it may raise ora-29283 if the owner of the file is not oracle.
If the file is created with the rw-r-- permission and owned by another user, RDBMS wont be able to read the file. In such case you will have to change the permissions of the file to rw-rw--
chmod 750 <filename>
6. Using remote directories :
UTL_FILE package can access only server side files where the database instance is running. You cannot access client side files. If you are using UNIX system, then create a NFS mount of the client folder on the server . If on Windows platform then go through
Note 45172.1 : Running UTL_FILE on Windows NT
Note 1034188.6: INVALID_OPERATION Exception from UTL_FILE when Writing to/from Network Drive
Solution:
Start the Oracle service as a user who has the same permissions as SYSTEM, and also who has access to the shared directory.
7. Check ORA_NLS on application server :
If the ORA_NLSXX where XX is 32, 33 or 10 is set, it must be set before starting the database and on the client side too.
Note 77442.1 : ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment Variables explained
ORA-04091 table DPNSDL.TBLERRORLIST is mutating, trigger function may not see it ORA-04091 ORA-06512 ORA-04088
ORA-04091: table is mutating, trigger/function may not see it
ORA-04091 ORA-06512 ORA-04088
Reason:
Mutating trigger error occurs when you refer the same table in the trigger code, on which the trigger is defined..
And here, it is very clear that your Update will call the trigger, which will cause another updates, which will call the trigger....... Infinite loop..
SOLUTION
Modify your custom code to not interfere with the target table involved in the update process of the mapping.
Use procedure inspite of trigger
Use Statement level trigger inspite of rowlevel(for each row :old.testorstatus != :new.testorstatus )
Compound Trigger Solution
ORA-04091 ORA-06512 ORA-04088
Reason:
Mutating trigger error occurs when you refer the same table in the trigger code, on which the trigger is defined..
And here, it is very clear that your Update will call the trigger, which will cause another updates, which will call the trigger....... Infinite loop..
SOLUTION
Modify your custom code to not interfere with the target table involved in the update process of the mapping.
Use procedure inspite of trigger
Use Statement level trigger inspite of rowlevel(for each row :old.testorstatus != :new.testorstatus )
Compound Trigger Solution
Windows cannot be installed on this disk. The disk may fail soon
Run chkdsk command from Windows 7 installation media.
Press Shift + F10 to open a Command Prompt and reformat disk with Diskpart command while you see the first installer screen.
Reset the BIOS to defaults and make sure there is no setting in the BIOS that prevents writing to the boot sector. Also make sure the BIOS is actually detecting the hard drive correctly
hard drive manufacturer's diagnostic tool.
chkdsk /f /r
at time of windows installation media
Repair your computer
In command prompt type diskpart to enter the utility.
Type select disk # replacing "#" with the drive number of the one you wish to format. To see a list of disks, type list disk.
Type clean. This deletes all volumes from the drive.
Type convert mbr to convert the disk to mbr.
convert gpt to revert back to GPT. (Optional step)
Start DISKPART.
Type LIST DISK and identify your SSD disk number (from 0 to n disks).
Type SELECT DISK <n> where <n> is your SSD disk number.
Type CLEAN
Type CREATE PARTITION PRIMARY
Type ACTIVE
Type FORMAT FS=NTFS QUICK
Type ASSIGN
Type EXIT twice (one to get out of DiskPart, the other to exit the command line tool)
Press Shift + F10 to open a Command Prompt and reformat disk with Diskpart command while you see the first installer screen.
Reset the BIOS to defaults and make sure there is no setting in the BIOS that prevents writing to the boot sector. Also make sure the BIOS is actually detecting the hard drive correctly
hard drive manufacturer's diagnostic tool.
chkdsk /f /r
at time of windows installation media
Repair your computer
In command prompt type diskpart to enter the utility.
Type select disk # replacing "#" with the drive number of the one you wish to format. To see a list of disks, type list disk.
Type clean. This deletes all volumes from the drive.
Type convert mbr to convert the disk to mbr.
convert gpt to revert back to GPT. (Optional step)
Start DISKPART.
Type LIST DISK and identify your SSD disk number (from 0 to n disks).
Type SELECT DISK <n> where <n> is your SSD disk number.
Type CLEAN
Type CREATE PARTITION PRIMARY
Type ACTIVE
Type FORMAT FS=NTFS QUICK
Type ASSIGN
Type EXIT twice (one to get out of DiskPart, the other to exit the command line tool)
ORA-14759 SET INTERVAL is not legal on this table
SQL> alter table ldbo.TBLSNPRISKDETAILS set INTERVAL (NUMTOYMINTERVAL(1,'MONTH')
);
alter table ldbo.TBLSNPRISKDETAILS set INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
*
ERROR at line 1:
ORA-14759: SET INTERVAL is not legal on this table.
reason:
PARTITION SAUDA_MAX values LESS THAN (maxvalue) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M )
STORAGE(INITIAL 10000M NEXT 1000M)
TABLESPACE "USR"
PARTITION BY RANGE ("DSAUDADATE")
(
PARTITION SAUDA_APR values LESS THAN (TO_DATE('01-MAY-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAY values LESS THAN (TO_DATE('01-JUN-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUN values LESS THAN (TO_DATE('01-JUL-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUL values LESS THAN (TO_DATE('01-AUG-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_AUG values LESS THAN (TO_DATE('01-SEP-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_SEP values LESS THAN (TO_DATE('01-OCT-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_OCT values LESS THAN (TO_DATE('01-NOV-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_NOV values LESS THAN (TO_DATE('01-DEC-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_DEC values LESS THAN (TO_DATE('01-JAN-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JAN values LESS THAN (TO_DATE('01-FEB-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_FEB values LESS THAN (TO_DATE('01-MAR-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAR values LESS THAN (TO_DATE('01-APR-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAX values LESS THAN (maxvalue) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M )
);
);
alter table ldbo.TBLSNPRISKDETAILS set INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
*
ERROR at line 1:
ORA-14759: SET INTERVAL is not legal on this table.
reason:
PARTITION SAUDA_MAX values LESS THAN (maxvalue) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M )
STORAGE(INITIAL 10000M NEXT 1000M)
TABLESPACE "USR"
PARTITION BY RANGE ("DSAUDADATE")
(
PARTITION SAUDA_APR values LESS THAN (TO_DATE('01-MAY-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAY values LESS THAN (TO_DATE('01-JUN-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUN values LESS THAN (TO_DATE('01-JUL-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUL values LESS THAN (TO_DATE('01-AUG-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_AUG values LESS THAN (TO_DATE('01-SEP-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_SEP values LESS THAN (TO_DATE('01-OCT-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_OCT values LESS THAN (TO_DATE('01-NOV-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_NOV values LESS THAN (TO_DATE('01-DEC-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_DEC values LESS THAN (TO_DATE('01-JAN-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JAN values LESS THAN (TO_DATE('01-FEB-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_FEB values LESS THAN (TO_DATE('01-MAR-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAR values LESS THAN (TO_DATE('01-APR-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAX values LESS THAN (maxvalue) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M )
);
ORA-14400 inserted partition key does not map to any partition
ORA-14400: inserted partition key does not map to any partition
insert into ldbo.TBLSNPRISKDETAILS (CFIRMNUMBER, CCLIENTCODE, DSAUDADATE, NPRODUCTCODE, NSEGMENTTYPE, NFINANCEAMOUNT, NMARGINAMOUNT, NBILLAMOUNT, NCOLLATERAL, NCOLLATERALBHCUT, NDEMATSTOCK, NDEMATSTOCKBHCUT, NOVERALLPOSITION, NOVERALLPOSITIONBHCUT, NNETMARGIN, NNETMARGINBHCUT, NFOEXPOSURE, NDERIVATIVESNOTIONAL, NOSSALES, NMARGINPERCENTAGE, NMARPERBHCUT, NPOASTOCK, NPOASTOCKBHCUT, NUNREALIZEDAMOUNT, NBHLEVEL, NBHLEVELBHCUT, NMFDEMATSTOCK, NMFDEMATSTOCKBHCUT, NMFPOASTOCK, NMFPOASTOCKBHCUT, NTILLDATEFINANCE, NTILLDATEMARGIN, CSCHEMETYPE, CBRANCHCODE, CCTCLBRANCHCODE, NMFNOTIONAL, CCOMPANYNAME, CCLIENTCATEGORY, NPENDINGACCEPTED, NADHOCCHARGE, NACCRUEDINTEREST, CNEXTRADEDATE, CBDRCODE, NPISAMOUNT, NGLOBALMARGIN, NTOTALSTOCK, NDPCHARGES, NTOTALILLBENSTOCK)
values ('FOR-000001', 'N124349 ', to_date('31-05-2017', 'dd-mm-yyyy'), 0, 0, 267.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 58630.70, 64229.30, 58363.70, 63962.30, 0.00, 0.00, 0.00, 99.54, 99.58, 58630.70, 64229.30, 0.00, 0, 0, 0.00, 0.00, 0.00, 0.00, 267.00, 0.00, 'NORMAL ', '8002', 'HO ', 0.00, 'RSL_SELF_RACE_ONLINE', ' ', 0.00, 0.00, 0.00, '02/04/2014', ' ', 0.00, 51034.05, 64229.30, 0.00, 0);
ORA-14400: inserted partition key does not map to any partition
STORAGE(INITIAL 10000M NEXT 1000M)
TABLESPACE "USR"
PARTITION BY RANGE ("DSAUDADATE")
(
PARTITION SAUDA_APR values LESS THAN (TO_DATE('01-MAY-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAY values LESS THAN (TO_DATE('01-JUN-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUN values LESS THAN (TO_DATE('01-JUL-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUL values LESS THAN (TO_DATE('01-AUG-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_AUG values LESS THAN (TO_DATE('01-SEP-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_SEP values LESS THAN (TO_DATE('01-OCT-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_OCT values LESS THAN (TO_DATE('01-NOV-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_NOV values LESS THAN (TO_DATE('01-DEC-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_DEC values LESS THAN (TO_DATE('01-JAN-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JAN values LESS THAN (TO_DATE('01-FEB-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_FEB values LESS THAN (TO_DATE('01-MAR-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAR values LESS THAN (TO_DATE('01-APR-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
add following
PARTITION SAUDA_MAX values LESS THAN (maxvalue) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M )
insert into ldbo.TBLSNPRISKDETAILS (CFIRMNUMBER, CCLIENTCODE, DSAUDADATE, NPRODUCTCODE, NSEGMENTTYPE, NFINANCEAMOUNT, NMARGINAMOUNT, NBILLAMOUNT, NCOLLATERAL, NCOLLATERALBHCUT, NDEMATSTOCK, NDEMATSTOCKBHCUT, NOVERALLPOSITION, NOVERALLPOSITIONBHCUT, NNETMARGIN, NNETMARGINBHCUT, NFOEXPOSURE, NDERIVATIVESNOTIONAL, NOSSALES, NMARGINPERCENTAGE, NMARPERBHCUT, NPOASTOCK, NPOASTOCKBHCUT, NUNREALIZEDAMOUNT, NBHLEVEL, NBHLEVELBHCUT, NMFDEMATSTOCK, NMFDEMATSTOCKBHCUT, NMFPOASTOCK, NMFPOASTOCKBHCUT, NTILLDATEFINANCE, NTILLDATEMARGIN, CSCHEMETYPE, CBRANCHCODE, CCTCLBRANCHCODE, NMFNOTIONAL, CCOMPANYNAME, CCLIENTCATEGORY, NPENDINGACCEPTED, NADHOCCHARGE, NACCRUEDINTEREST, CNEXTRADEDATE, CBDRCODE, NPISAMOUNT, NGLOBALMARGIN, NTOTALSTOCK, NDPCHARGES, NTOTALILLBENSTOCK)
values ('FOR-000001', 'N124349 ', to_date('31-05-2017', 'dd-mm-yyyy'), 0, 0, 267.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 58630.70, 64229.30, 58363.70, 63962.30, 0.00, 0.00, 0.00, 99.54, 99.58, 58630.70, 64229.30, 0.00, 0, 0, 0.00, 0.00, 0.00, 0.00, 267.00, 0.00, 'NORMAL ', '8002', 'HO ', 0.00, 'RSL_SELF_RACE_ONLINE', ' ', 0.00, 0.00, 0.00, '02/04/2014', ' ', 0.00, 51034.05, 64229.30, 0.00, 0);
ORA-14400: inserted partition key does not map to any partition
STORAGE(INITIAL 10000M NEXT 1000M)
TABLESPACE "USR"
PARTITION BY RANGE ("DSAUDADATE")
(
PARTITION SAUDA_APR values LESS THAN (TO_DATE('01-MAY-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAY values LESS THAN (TO_DATE('01-JUN-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUN values LESS THAN (TO_DATE('01-JUL-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUL values LESS THAN (TO_DATE('01-AUG-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_AUG values LESS THAN (TO_DATE('01-SEP-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_SEP values LESS THAN (TO_DATE('01-OCT-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_OCT values LESS THAN (TO_DATE('01-NOV-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_NOV values LESS THAN (TO_DATE('01-DEC-2015','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_DEC values LESS THAN (TO_DATE('01-JAN-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JAN values LESS THAN (TO_DATE('01-FEB-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_FEB values LESS THAN (TO_DATE('01-MAR-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAR values LESS THAN (TO_DATE('01-APR-2016','DD-MON-YYYY')) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
add following
PARTITION SAUDA_MAX values LESS THAN (maxvalue) TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M )
tnsping no listener
tns-12541 no listener nslookup dns timeout
etc/hosts
network issue right
nslookup DB-serverIP
If timeout contact to IT Admin
ipconfig /registerdns
TNS-03505: Failed to resolve name
This shows that the configuration is incorrect and the SID/service name that you are attempting to connect to cannot be resolved. Check the TNSNames entry is there for your database you are attempting to connect to. If it is, check that the IP address/DNS entry are correct as previously mentioned above when regarding configuring the TNSNames.ora file. Then, check that you can ping the IP address from the server you are making the connection from. If you can’t, that is your problem. If you are using DNS you can try using NSLOOKUP to resolve the name. For example, NSLOOKUP TEST will attempt to look up and show you the IP address for the TEST name in your DNS. The problem will be in this area somewhere. - See more at: http://www.ora00600.com/wordpress/articles/listener-tnsnames-configuration/#sthash.lsuFuJ4S.dpuf
etc/hosts
network issue right
nslookup DB-serverIP
If timeout contact to IT Admin
ipconfig /registerdns
TNS-03505: Failed to resolve name
This shows that the configuration is incorrect and the SID/service name that you are attempting to connect to cannot be resolved. Check the TNSNames entry is there for your database you are attempting to connect to. If it is, check that the IP address/DNS entry are correct as previously mentioned above when regarding configuring the TNSNames.ora file. Then, check that you can ping the IP address from the server you are making the connection from. If you can’t, that is your problem. If you are using DNS you can try using NSLOOKUP to resolve the name. For example, NSLOOKUP TEST will attempt to look up and show you the IP address for the TEST name in your DNS. The problem will be in this area somewhere. - See more at: http://www.ora00600.com/wordpress/articles/listener-tnsnames-configuration/#sthash.lsuFuJ4S.dpuf
ora-31626 ora-31687 ora-31688
If your init parameter AQ_TM_PROCESSES parameter has a value of zero, remove it.
Ensure that your streams_pool_size is configured with a minimum value of 50MB and 128MB would be better then retry the job.
SQL> SHOW PARAMETER streams_pool_size
TO SET THE PARAMETER streams_pool_size
SQL> ALTER SYSTEM SET streams_pool_size=128M
SHUT DOWN & RESTART THE DATABASE
Ensure that your streams_pool_size is configured with a minimum value of 50MB and 128MB would be better then retry the job.
SQL> SHOW PARAMETER streams_pool_size
TO SET THE PARAMETER streams_pool_size
SQL> ALTER SYSTEM SET streams_pool_size=128M
SHUT DOWN & RESTART THE DATABASE
Friday, January 22, 2016
EXPDP ORA-31626 ORA-31633 ORA-06512 ORA-01950
ORA-31626 ORA-31633 ORA-06512 ORA-01950
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_FULL_09"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1020
ORA-01950: no privileges on tablespace 'SYSTEM'
ALTER USER SYSTEM QUOTA unlimited ON SYSTEM;
ALTER USER SYSTEM QUOTA unlimited ON USR;
ALTER USER SYSTEM QUOTA unlimited ON INDX;
GRANT UNLIMITED TABLESPACE TO SYSTEM;
ALTER USER LDBO QUOTA unlimited ON SYSTEM;
ALTER USER LDBO QUOTA unlimited ON USR;
ALTER USER LDBO QUOTA unlimited ON INDX;
GRANT UNLIMITED TABLESPACE TO LDBO ;
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_FULL_09"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1020
ORA-01950: no privileges on tablespace 'SYSTEM'
ALTER USER SYSTEM QUOTA unlimited ON SYSTEM;
ALTER USER SYSTEM QUOTA unlimited ON USR;
ALTER USER SYSTEM QUOTA unlimited ON INDX;
GRANT UNLIMITED TABLESPACE TO SYSTEM;
ALTER USER LDBO QUOTA unlimited ON SYSTEM;
ALTER USER LDBO QUOTA unlimited ON USR;
ALTER USER LDBO QUOTA unlimited ON INDX;
GRANT UNLIMITED TABLESPACE TO LDBO ;
Handler PageHandlerFactory-Integrated has a bad module ManagedPipelineHandler in its module list
HTTP Error 500.21 - Internal Server Error
Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i
Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list
%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i
ora-01536 space quota exceed
ALTER USER LDBO QUOTA UNLIMITED on USR;
ALTER USER LDBO QUOTA UNLIMITED on INDX;
grant unlimited tablespace TO LDBO;
Select Tablespace_Name, Username, Bytes / 1024 / 1024/ 1024 "Used GB", Max_Bytes / 1024 / 1024/ 1024 As "Max GB" from dba_ts_quotas;
select file_name,tablespace_name,bytes/1024/1024 "Size MB",status,autoextensible,maxbytes/1024/1024 "MaxSize MB",Increment_By from dba_data_files;
select username,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,profile from dba_users where username='LDBO';
impdp hang statement suspended, wait error to be cleared
space issue or add more datafiles
select file_name,tablespace_name,bytes/1024/1024 "Size MB",status,autoextensible,maxbytes/1024/1024 "MaxSize MB" from dba_data_files;
select file_name,tablespace_name,bytes/1024/1024 "Size MB",status,autoextensible,maxbytes/1024/1024 "MaxSize MB" from dba_temp_files
ORA-01652 unable to extend temp segment by 64 in tablespace TEMPORARY
ALTER TABLESPACE temporary ADD TEMPFILE 'E:\NBSD1314\TEMP02.ORA' SIZE 1000M AUTOEXTEND ON;
ALTER database TEMPFILE 'E:\NBSD1314\TEMP02.ORA' AUTOEXTEND ON NEXT 100M MAXSIZE unlimited;
change file location as per client DB folder
alter tablespace
temporary
add tempfile
'D:\APXD1516\TEMP02.ORA'
size
1000m
autoextend on
next
100m
maxsize
unlimited;
ALTER database TEMPFILE 'E:\NBSD1314\TEMP02.ORA' AUTOEXTEND ON NEXT 100M MAXSIZE unlimited;
change file location as per client DB folder
alter tablespace
temporary
add tempfile
'D:\APXD1516\TEMP02.ORA'
size
1000m
autoextend on
next
100m
maxsize
unlimited;
ORA-00600 internal error code, arguments [FILEjsks.c LINE2388 IDOCIKCallPush] ORA-28031 maximum of 148 enabled roles exceeded
ORA-00600: internal error code, arguments: [FILE:jsks.c LINE:2388 ID:OCIKCallPush] ORA-28031: maximum of 148 enabled roles exceeded
Error starting at line 1 in command:
begin
dbms_scheduler.run_job('JobImportClientMaster8');
end;
Error report:
ORA-00600: internal error code, arguments: [FILE:jsks.c LINE:2388 ID:OCIKCallPush], [], [], [], [], [], [], [], [], [], [], []
ORA-28031: maximum of 148 enabled roles exceeded
https://dbamohsin.wordpress.com/tag/ora-600/
SR 3-8664869401 : ORA 600-[FILE:jsks.c LINE:2388 FUNCTION:jsksStartOCICall() ID:OCIKCallPus]
Caused by Bug 8895202 : ITL HAS HIGHER COMMIT SCN THAN BLOCK SCN
The solution was to set the following dynamic parameter on both the primary and standby database:
ALTER SYSTEM SET "_ktb_debug_flags"=8 SCOPE=BOTH;
This parameter is designed to heal blocks having invalid dependent scn’s on switchover operations.
From the traces provided to oracle, I was told that the affected object for this issue was ID 12152331.
Running the following SQL determines the object:
select owner,object_name,object_type,subobject_name,object_id,data_object_id
from dba_objects
where object_id in (12152331)
or data_object_id in (12152331);
The affected blocks were on index SYS.I_SCHEDULER_JOB_RUN_DETAILS on table SCHEDULER$_JOB_RUN_DETAILS.
As well as the dynamic parameter, I also did the following:
ANALYZE TABLE SCHEDULER$_JOB_RUN_DETAILS VALIDATE STRUCTURE online;
ALTER INDEX SYS.I_SCHEDULER_JOB_RUN_DETAILS REBUILD online;
Error starting at line 1 in command:
begin
dbms_scheduler.run_job('JobImportClientMaster8');
end;
Error report:
ORA-00600: internal error code, arguments: [FILE:jsks.c LINE:2388 ID:OCIKCallPush], [], [], [], [], [], [], [], [], [], [], []
ORA-28031: maximum of 148 enabled roles exceeded
https://dbamohsin.wordpress.com/tag/ora-600/
SR 3-8664869401 : ORA 600-[FILE:jsks.c LINE:2388 FUNCTION:jsksStartOCICall() ID:OCIKCallPus]
Caused by Bug 8895202 : ITL HAS HIGHER COMMIT SCN THAN BLOCK SCN
The solution was to set the following dynamic parameter on both the primary and standby database:
ALTER SYSTEM SET "_ktb_debug_flags"=8 SCOPE=BOTH;
This parameter is designed to heal blocks having invalid dependent scn’s on switchover operations.
From the traces provided to oracle, I was told that the affected object for this issue was ID 12152331.
Running the following SQL determines the object:
select owner,object_name,object_type,subobject_name,object_id,data_object_id
from dba_objects
where object_id in (12152331)
or data_object_id in (12152331);
The affected blocks were on index SYS.I_SCHEDULER_JOB_RUN_DETAILS on table SCHEDULER$_JOB_RUN_DETAILS.
As well as the dynamic parameter, I also did the following:
ANALYZE TABLE SCHEDULER$_JOB_RUN_DETAILS VALIDATE STRUCTURE online;
ALTER INDEX SYS.I_SCHEDULER_JOB_RUN_DETAILS REBUILD online;
PLS-00565 STR_ARRAY must be completed as a potential REF target (object type)
create or replace TYPE "STR_ARRAY" is table of varchar2(3999);
/
ORA-06545: PL/SQL: compilation error - compilation aborted
ORA-06550: line 0, column 0:
PLS-00565: STR_ARRAY must be completed as a potential REF target (object type)
DROP TYPE "STR_ARRAY" ;
create or replace TYPE "STR_ARRAY" is table of varchar2(3999);
/
/
ORA-06545: PL/SQL: compilation error - compilation aborted
ORA-06550: line 0, column 0:
PLS-00565: STR_ARRAY must be completed as a potential REF target (object type)
DROP TYPE "STR_ARRAY" ;
create or replace TYPE "STR_ARRAY" is table of varchar2(3999);
/
ORA-01658
select a.file_id,b.file_name,b.autoextensible,b.bytes/1024/1024,sum(a.bytes)/1024/1024
from dba_extents a , dba_data_files b
where a.file_id=b.file_id
group by a.file_id,b.file_name,autoextensible,b.bytes/1024/1024;
select file_name,tablespace_name,bytes/1024/1024/1024 "Size GB",status,autoextensible,maxbytes/1024/1024/1024 "MaxSize GB",increment_by from dba_data_files;
select tablespace_name,bigfile from dba_tablespaces;
alter database default tablespace SYSTEM;
ALTER DATABASE DATAFILE 'E:\MCS0809\USERs01.ORA' AUTOEXTEND ON MAXSIZE UNLIMITED;
Hard disk space is not equal to the database space
tablespace is full, and then hang it a few more data files
Reply:
Hard disk space is sufficient enough table space does not mean
from dba_extents a , dba_data_files b
where a.file_id=b.file_id
group by a.file_id,b.file_name,autoextensible,b.bytes/1024/1024;
select file_name,tablespace_name,bytes/1024/1024/1024 "Size GB",status,autoextensible,maxbytes/1024/1024/1024 "MaxSize GB",increment_by from dba_data_files;
select tablespace_name,bigfile from dba_tablespaces;
alter database default tablespace SYSTEM;
ALTER DATABASE DATAFILE 'E:\MCS0809\USERs01.ORA' AUTOEXTEND ON MAXSIZE UNLIMITED;
Hard disk space is not equal to the database space
tablespace is full, and then hang it a few more data files
Reply:
Hard disk space is sufficient enough table space does not mean
ora-16038 ora-19502 ora-00312
ora-16038 ora-19502 ora-00312
ORA-16038: log 4 sequence# 10840 cannot be archived,ORA-19502: write error on file "", blockno (blocksize=,ORA-00312: online log 4 thread 1: '/ora01/oradata/pbm1/redo/redo04a',ORA-16014: log 4 seque
Just check the space in your archive log destination.
Make sure that it is not full.
shut immediate
startup mount
recover database until cancel;
alter database open resetlogs;
1. Increase the ARCHIVE DESTINATION size
2. Take backup of the archivelogs to different location.
3. Change archivelogs destination to some other mountpoint.
4. Delete archivelogs to make more space. ( should be the last option) and in case of standby database make sure those logs are already applied to standby.
ORA-16038: log 4 sequence# 10840 cannot be archived,ORA-19502: write error on file "", blockno (blocksize=,ORA-00312: online log 4 thread 1: '/ora01/oradata/pbm1/redo/redo04a',ORA-16014: log 4 seque
Just check the space in your archive log destination.
Make sure that it is not full.
shut immediate
startup mount
recover database until cancel;
alter database open resetlogs;
1. Increase the ARCHIVE DESTINATION size
2. Take backup of the archivelogs to different location.
3. Change archivelogs destination to some other mountpoint.
4. Delete archivelogs to make more space. ( should be the last option) and in case of standby database make sure those logs are already applied to standby.
ORA-00600 internal error code, arguments FILE jsks.c LINE 2388ID OCIKCallPush
SQL> exec DBMS_SCHEDULER.run_job ('ANALYZE_FULL');
BEGIN DBMS_SCHEDULER.run_job ('ANALYZE_FULL'); END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [FILE:jsks.c LINE:2388ID:OCIKCallPush], [], [], [], [], [], [], [], [], [], [], []
ORA-28031: maximum of 148 enabled roles exceeded
ORA-28031: maximum of 148 enabled roles exceeded
ORA-28031: maximum of 148 enabled roles exceeded
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 1
spool c:\revokeldbo.sql
select 'REVOKE ' || GRANTED_ROLE || ' from sys;' from dba_role_privs where grantee='SYS' and granted_role not in ('CONNECT','DBA');
spool off
@c:\revokeldbo.sql
BEGIN DBMS_SCHEDULER.run_job ('ANALYZE_FULL'); END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [FILE:jsks.c LINE:2388ID:OCIKCallPush], [], [], [], [], [], [], [], [], [], [], []
ORA-28031: maximum of 148 enabled roles exceeded
ORA-28031: maximum of 148 enabled roles exceeded
ORA-28031: maximum of 148 enabled roles exceeded
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 1
spool c:\revokeldbo.sql
select 'REVOKE ' || GRANTED_ROLE || ' from sys;' from dba_role_privs where grantee='SYS' and granted_role not in ('CONNECT','DBA');
spool off
@c:\revokeldbo.sql
utl_http.request ORA-12541 TNSno listener
select utl_http.request('http://172.168.1.7') from dual;
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-12541: TNS:no listener
ORA-06512: at line 1
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
Fix the error and retry the HTTP request.
select utl_http.request('http://172.168.1.7:91') from dual;
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-12541: TNS:no listener
ORA-06512: at line 1
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
Fix the error and retry the HTTP request.
select utl_http.request('http://172.168.1.7:91') from dual;
ORA-00600 [13011], [104], [4216981]
drop procedure ldbo.sp_mvmfrm;
drop materialized view ldbo.mv_rkmfrm;
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_ora_25880.trc (incident=2513464):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [13011], [104], [4216981], [185], [4216981], [17], [], [], [], [], [], []
Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\incident\incdir_2513464\rakshak_ora_25880_i2513464.trc
Tue Jun 16 13:07:24 2015
Dumping diagnostic data in directory=[cdmp_20150616130724], requested by (instance=1, osid=25880), summary=[incident=2513464].
opiodr aborting process unknown ospid (25880) as a result of ORA-603
Tue Jun 16 13:07:27 2015
Sweep [inc][2513464]: completed
Sweep [inc2][2513464]: completed
Tue Jun 16 13:07:28 2015
SMON: Parallel transaction recovery tried
Tue Jun 16 13:07:30 2015
ORA-00600 [13011], [104], [4216981], [239], [4216981], [17], [], [], [], [], [], []
Tue Jun 16 11:24:47 2015
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_j002_27844.trc:
ORA-00600: internal error code, arguments: [13011], [104], [4216981], [239], [4216981], [17], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745
ORA-06512: at "LDBO.SP_MVCLIENTFOLLOWUP", line 4
ORA-06512: at line 1
select object_name,object_type,owner from dba_objects where data_object_id=104;
analyze table DEPENDENCY$ validate structure cascade;
SELECT
ss.program "SOFTWARE",last_call_et,
substr(sqa.sql_text, 1, 50) "SQL"
,'alter system disconnect session ''' || ss.sid || ',' || ss.serial# || ''' immediate;'
fROM v$process pr, v$session ss, v$sqlarea sqa
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.status = 'ACTIVE'
ORDER BY last_call_et desc;
ANALYZE INDEX I_DEPENDENCY1 VALIDATE STRUCTURE;
ANALYZE INDEX I_DEPENDENCY2 VALIDATE STRUCTURE;
alter INDEX I_DEPENDENCY1 rebuild;
alter INDEX I_DEPENDENCY2 rebuild;
DROP INDEX "SYS"."I_DEPENDENCY1";
DROP INDEX "SYS"."I_DEPENDENCY2";
CREATE UNIQUE INDEX "SYS"."I_DEPENDENCY1" ON "SYS"."DEPENDENCY$" ("D_OBJ#", "D_TIMESTAMP", "ORDER#")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 32768 NEXT 114688 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
CREATE INDEX "SYS"."I_DEPENDENCY2" ON "SYS"."DEPENDENCY$" ("P_OBJ#", "P_TIMESTAMP")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 32768 NEXT 114688 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
SQL> DROP INDEX "SYS"."I_DEPENDENCY1";
DROP INDEX "SYS"."I_DEPENDENCY1"
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkdlGetCkyName1], [106], [], [],
[], [], [], [], [], [], [], []
SQL>
SQL> analyze table DEPENDENCY$ validate structure cascade;
analyze table DEPENDENCY$ validate structure cascade
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL>
drop materialized view ldbo.mv_rkmfrm;
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_ora_25880.trc (incident=2513464):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [13011], [104], [4216981], [185], [4216981], [17], [], [], [], [], [], []
Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\incident\incdir_2513464\rakshak_ora_25880_i2513464.trc
Tue Jun 16 13:07:24 2015
Dumping diagnostic data in directory=[cdmp_20150616130724], requested by (instance=1, osid=25880), summary=[incident=2513464].
opiodr aborting process unknown ospid (25880) as a result of ORA-603
Tue Jun 16 13:07:27 2015
Sweep [inc][2513464]: completed
Sweep [inc2][2513464]: completed
Tue Jun 16 13:07:28 2015
SMON: Parallel transaction recovery tried
Tue Jun 16 13:07:30 2015
ORA-00600 [13011], [104], [4216981], [239], [4216981], [17], [], [], [], [], [], []
Tue Jun 16 11:24:47 2015
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_j002_27844.trc:
ORA-00600: internal error code, arguments: [13011], [104], [4216981], [239], [4216981], [17], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745
ORA-06512: at "LDBO.SP_MVCLIENTFOLLOWUP", line 4
ORA-06512: at line 1
select object_name,object_type,owner from dba_objects where data_object_id=104;
analyze table DEPENDENCY$ validate structure cascade;
SELECT
ss.program "SOFTWARE",last_call_et,
substr(sqa.sql_text, 1, 50) "SQL"
,'alter system disconnect session ''' || ss.sid || ',' || ss.serial# || ''' immediate;'
fROM v$process pr, v$session ss, v$sqlarea sqa
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.status = 'ACTIVE'
ORDER BY last_call_et desc;
ANALYZE INDEX I_DEPENDENCY1 VALIDATE STRUCTURE;
ANALYZE INDEX I_DEPENDENCY2 VALIDATE STRUCTURE;
alter INDEX I_DEPENDENCY1 rebuild;
alter INDEX I_DEPENDENCY2 rebuild;
DROP INDEX "SYS"."I_DEPENDENCY1";
DROP INDEX "SYS"."I_DEPENDENCY2";
CREATE UNIQUE INDEX "SYS"."I_DEPENDENCY1" ON "SYS"."DEPENDENCY$" ("D_OBJ#", "D_TIMESTAMP", "ORDER#")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 32768 NEXT 114688 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
CREATE INDEX "SYS"."I_DEPENDENCY2" ON "SYS"."DEPENDENCY$" ("P_OBJ#", "P_TIMESTAMP")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 32768 NEXT 114688 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
SQL> DROP INDEX "SYS"."I_DEPENDENCY1";
DROP INDEX "SYS"."I_DEPENDENCY1"
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkdlGetCkyName1], [106], [], [],
[], [], [], [], [], [], [], []
SQL>
SQL> analyze table DEPENDENCY$ validate structure cascade;
analyze table DEPENDENCY$ validate structure cascade
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL>
ORA-00064 object is too large to allocate on this OS (1,10085160)
process should be less 500
create pfile from spfile;
rename spfile
open pfile and change processes to 200
and restart services
create pfile from spfile;
rename spfile
open pfile and change processes to 200
and restart services
Oracle Installation Issue Please ensure that this directory is writable and has at least 45MB of disk space
Virus
AntiVirus
Rights
Space in temp
Cross verify the registry using 'regedit' and check it doesn't have any unclean services of previos oracle installation (if any).
a) Insufficient free space in the temporary directory.
b) Insufficient access rights on the temporary directory.
c) Not using a local console.
d) Corrupted software set.
e) Wrong Unzip utility is used.
For Database: %Oracle_extracted_media%\database\install\oraparam.ini
Edit value: BOOTSTRAP=TRUE
New value: BOOTSTRAP=FALSE << this allows OUI creates less files /tmp and avoids creation of autorun.inf file @ %tmp%
2) Then run the setup.exe -debug from the media (where the file praparam.ini edited ).
Example: run setup.exe -debug from required media location
cd %Oracle_extracted_media%\database\setup.exe
create autorun.inf file in temp folder, try to save this
unload officescan
PLS-00920 parameter plsql_native_library_dir is not set
sho parameter plsql
plsql_code_type string INTERPRETED
plsql_compiler_flags string INTERPRETED, NON_DEBUG
10g
alter system set plsql_code_type ='INTERPRETED';
plsql_code_type string INTERPRETED
plsql_compiler_flags string INTERPRETED, NON_DEBUG
10g
alter system set plsql_code_type ='INTERPRETED';
The specified DSN contains an architecture mismatch between the Driver and Application
64 bit m/c
Reason
odbc at both location
c:\windows\system32\odbcad32.exe
c:\windows\sysWOW64\odbcad32.exe
remove odbc connection from c:\windows\system32\odbcad32.exe
You will get this error if you attempt to do the following on a 64-bit Windows machine:
Connect a 64-bit application to a data source for a 32-bit ODBC driver.
Connect a 32-bit application to a data source for a 64-bit ODBC driver.
If you are using a 64-bit application, it will be linked against the 64-bit version of the Microsoft ODBC Driver Manager, which can only load a 64-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 64-bit ODBC Data Source Administrator (accessible from Administrative tools in Control Panel).
Similarly, if you are using a 32-bit application, it will be linked against the 32-bit version of the Microsoft ODBC Driver Manager, which can only load a 32-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 32-bit ODBC Data Source Administrator (accessible by running %windir%\syswow64\odbcad32.exe in the Windows Run dialog box).
If an ODBC driver is listed in both versions of the ODBC Data Source Administrator, both a 32-bit and a 64-bit version of that driver are installed.
Reason
odbc at both location
c:\windows\system32\odbcad32.exe
c:\windows\sysWOW64\odbcad32.exe
remove odbc connection from c:\windows\system32\odbcad32.exe
You will get this error if you attempt to do the following on a 64-bit Windows machine:
Connect a 64-bit application to a data source for a 32-bit ODBC driver.
Connect a 32-bit application to a data source for a 64-bit ODBC driver.
If you are using a 64-bit application, it will be linked against the 64-bit version of the Microsoft ODBC Driver Manager, which can only load a 64-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 64-bit ODBC Data Source Administrator (accessible from Administrative tools in Control Panel).
Similarly, if you are using a 32-bit application, it will be linked against the 32-bit version of the Microsoft ODBC Driver Manager, which can only load a 32-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 32-bit ODBC Data Source Administrator (accessible by running %windir%\syswow64\odbcad32.exe in the Windows Run dialog box).
If an ODBC driver is listed in both versions of the ODBC Data Source Administrator, both a 32-bit and a 64-bit version of that driver are installed.
ORA-00344 unable to re-create online log ORA-27040 file create error unable to create file
http://blog.dbvisit.com/activating-standby-database-failover/
ORA-00344 unable to re-create online log ORA-27040 file create error unable to create file
SQL> alter database rename file '/oracle/oradata/dbvisitp/redo01.log'
to '/oracleX/oradata/dbvisitp/redo01.log';
Database altered.
SQL> alter database activate standby database;
alter database activate standby database
*
ERROR at line 1:
ORA-00344: unable to re-create online log
'/oracleX/oradata/dbvisitp/redo01.log'
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory
The database is still a standby database as the activation failed.
We cannot manually create the redo logs, as this is an Oracle internal operation.
The only thing we can do is to give the correct location for the redo log files.
Rename the redo log to the correct location:
SQL> alter database rename file '/oracleX/oradata/dbvisitp/redo01.log' to
'/oracle/oradata/dbvisitp/redo01.log';
Database altered.
SQL> alter database activate standby database;
Database altered.
SQL>
Note: all previous backups of this database are now invalid and cannot be used to restore this database. This is because of the RESETLOGS command which resets the archive sequence number (SEQUENCE#) and invalidates all previous archive logs. The SCN number of the database is not reset.
ORA-00344 unable to re-create online log ORA-27040 file create error unable to create file
SQL> alter database rename file '/oracle/oradata/dbvisitp/redo01.log'
to '/oracleX/oradata/dbvisitp/redo01.log';
Database altered.
SQL> alter database activate standby database;
alter database activate standby database
*
ERROR at line 1:
ORA-00344: unable to re-create online log
'/oracleX/oradata/dbvisitp/redo01.log'
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory
The database is still a standby database as the activation failed.
We cannot manually create the redo logs, as this is an Oracle internal operation.
The only thing we can do is to give the correct location for the redo log files.
Rename the redo log to the correct location:
SQL> alter database rename file '/oracleX/oradata/dbvisitp/redo01.log' to
'/oracle/oradata/dbvisitp/redo01.log';
Database altered.
SQL> alter database activate standby database;
Database altered.
SQL>
Note: all previous backups of this database are now invalid and cannot be used to restore this database. This is because of the RESETLOGS command which resets the archive sequence number (SEQUENCE#) and invalidates all previous archive logs. The SCN number of the database is not reset.
Could not load file or assembly 'ChilkatDotNet4' or one of its dependencies. An attempt was made to load a program with an incorrect format.
Common Error #1
The Chilkat .NET assembly is a mixed-mode assembly. It provides a managed API, but the inner core contains native code. A process must load the correct assembly at runtime. A 32-bit process must load the 32-bit ChilkatDotNet4.dll, and a 64-bit process must load the 64-bit ChilkatDotNet4.dll. When a process tries to load the incorrect format, the following error will occur:
Could not load file or assembly 'ChilkatDotNet4' or one of its dependencies. An attempt was made to load a program with an incorrect format.
See Incorrect Format for more information.
check application pool (32 bit enable or not)
check ChilkatDotNet4 version 9.3.1
Microsoft Visual C++ 2010 SP1 Redistributable 32 bit / 64 bit
Microsoft Visual C++ 2012 SP1 Redistributable 32 bit/ 64 bit
The Chilkat .NET assembly is a mixed-mode assembly. It provides a managed API, but the inner core contains native code. A process must load the correct assembly at runtime. A 32-bit process must load the 32-bit ChilkatDotNet4.dll, and a 64-bit process must load the 64-bit ChilkatDotNet4.dll. When a process tries to load the incorrect format, the following error will occur:
Could not load file or assembly 'ChilkatDotNet4' or one of its dependencies. An attempt was made to load a program with an incorrect format.
See Incorrect Format for more information.
check application pool (32 bit enable or not)
check ChilkatDotNet4 version 9.3.1
Microsoft Visual C++ 2010 SP1 Redistributable 32 bit / 64 bit
Microsoft Visual C++ 2012 SP1 Redistributable 32 bit/ 64 bit
Could not load file or assembly 'ChilkatDotNet4.dll' or one of its dependencies. The specified module could not be found.
install
vcredist_x64
vcredist_x86
vcredist_x64_2010
vcredist_x86_2010
vcredist_x64_2012
vcredist_x86_2012
Common Error #2
The Chilkat .NET assembly requires the VC++ runtime to be installed on any computer where your application runs. Most computers will already have it installed. Your development computer will have it because Visual Studio has been installed. However, if deploying to a computer where the VC++ runtime is not available, the following error will occur:
Could not load file or assembly 'ChilkatDotNet4.dll' or one of its dependencies. The specified module could not be found.
http://www.microsoft.com/en-us/download/details.aspx?id=5555
Common Error #1
The Chilkat .NET assembly is a mixed-mode assembly. It provides a managed API, but the inner core contains native code. A process must load the correct assembly at runtime. A 32-bit process must load the 32-bit ChilkatDotNet4.dll, and a 64-bit process must load the 64-bit ChilkatDotNet4.dll. When a process tries to load the incorrect format, the following error will occur:
Could not load file or assembly 'ChilkatDotNet4' or one of its dependencies. An attempt was made to load a program with an incorrect format.
See Incorrect Format for more information.
vcredist_x64
vcredist_x86
vcredist_x64_2010
vcredist_x86_2010
vcredist_x64_2012
vcredist_x86_2012
Common Error #2
The Chilkat .NET assembly requires the VC++ runtime to be installed on any computer where your application runs. Most computers will already have it installed. Your development computer will have it because Visual Studio has been installed. However, if deploying to a computer where the VC++ runtime is not available, the following error will occur:
Could not load file or assembly 'ChilkatDotNet4.dll' or one of its dependencies. The specified module could not be found.
http://www.microsoft.com/en-us/download/details.aspx?id=5555
Common Error #1
The Chilkat .NET assembly is a mixed-mode assembly. It provides a managed API, but the inner core contains native code. A process must load the correct assembly at runtime. A 32-bit process must load the 32-bit ChilkatDotNet4.dll, and a 64-bit process must load the 64-bit ChilkatDotNet4.dll. When a process tries to load the incorrect format, the following error will occur:
Could not load file or assembly 'ChilkatDotNet4' or one of its dependencies. An attempt was made to load a program with an incorrect format.
See Incorrect Format for more information.
PLS-00123 program too large (Diana nodes)
in 10g, plsql is not taking such size.
better way to use large procedures and functions should always be defined within packages
microsoft excel cannot open or save any more documents because there is not enough available memory
at Control Panel \ All Control Panel Items \ Default Programs \ Set Default Programs \ Set Program Associations
In Excel, go to File/Options/Trust Center/Trust Center Settings/Protected View. Untick the "Enable Protected View for Outlook Attachments" - and all will be well.
no mapping between account name and security ids was done server 2008 service installation
grant rights of folder
If you do choose the SYSPREP route though here is what you need to do:
From the Start Menu select Run
Enter C:\Windows\System32\sysprep\sysprep.exe in the box and click OK
Be sure that Enter System Out-of-Box Experience (OOBE) is selected
Check the box next to Generalize (If this is not select the SID won’t get changed)
Click OK and follow the prompts when the system reboots.
C:\Windows\System32\sysprep\sysprep.exe
If you do choose the SYSPREP route though here is what you need to do:
From the Start Menu select Run
Enter C:\Windows\System32\sysprep\sysprep.exe in the box and click OK
Be sure that Enter System Out-of-Box Experience (OOBE) is selected
Check the box next to Generalize (If this is not select the SID won’t get changed)
Click OK and follow the prompts when the system reboots.
C:\Windows\System32\sysprep\sysprep.exe
Silverlight out of browser export to excel download issue require Administrator to create the file
at time of package build, in properties there is a tick for out of browser
LD Ledger Client Code not search
Insert into tblsaudatable select distinct Firmnumber,Oowncode,'C','N' from sauda minus
Select distinct cFirmnumber,cclientcode,'C','N' from tblsaudatable Where cSegment='C' ;
Insert into Tblsaudascriptable select distinct Firmnumber,Oowncode,Compcode,'C' from sauda minus
Select distinct cFirmnumber,Cclientcode,cscripcode,'C' from Tblsaudascriptable Where cSegment='C' ;
Insert into tblsaudatable select distinct Firmnumber,Oowncode,'D','N' from fosauda minus
Select distinct cFirmnumber,CClientcode,'D','N' from tblsaudatable Where cSegment='D' ;
Insert into Tblsaudascriptable select distinct Firmnumber,Oowncode,Compcode,'D' from fosauda minus
Select distinct cFirmnumber,Cclientcode,Cscripcode,'D' from Tblsaudascriptable Where cSegment='D' ;
Insert into Tblfintable select distinct firmnumber,oowncode,branchcode,'N' from ledger minus
select distinct cfirmnumber,Cclientcode,Cbranchcode,'N' from Tblfintable ;
Select distinct cFirmnumber,cclientcode,'C','N' from tblsaudatable Where cSegment='C' ;
Insert into Tblsaudascriptable select distinct Firmnumber,Oowncode,Compcode,'C' from sauda minus
Select distinct cFirmnumber,Cclientcode,cscripcode,'C' from Tblsaudascriptable Where cSegment='C' ;
Insert into tblsaudatable select distinct Firmnumber,Oowncode,'D','N' from fosauda minus
Select distinct cFirmnumber,CClientcode,'D','N' from tblsaudatable Where cSegment='D' ;
Insert into Tblsaudascriptable select distinct Firmnumber,Oowncode,Compcode,'D' from fosauda minus
Select distinct cFirmnumber,Cclientcode,Cscripcode,'D' from Tblsaudascriptable Where cSegment='D' ;
Insert into Tblfintable select distinct firmnumber,oowncode,branchcode,'N' from ledger minus
select distinct cfirmnumber,Cclientcode,Cbranchcode,'N' from Tblfintable ;
ORA-29861 domain index is marked LOADINGFAILEDUNUSABLE
Exec dbms_network_acl_admin.create_acl ('utl_http_access.xml','Normal Access','DPCDSL',TRUE,'connect',NULL,NULL);
Exec dbms_network_acl_admin.add_privilege (acl => 'utl_http_access.xml', principal => 'DPCDSL',is_grant => TRUE, privilege => 'resolve');
Exec dbms_network_acl_admin.assign_acl ('utl_http_access.xml', '*',NULL,NULL);
Commit ;
ERROR at line 1:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252
ORA-06512: at line 1
select owner,index_name from all_indexes where domidx_status != 'VALID' or domidx_opstatus !='VALID';
alter index xdb.XDB$ACL_XIDX rebuild;
"ORA-28547: Connection to Server Failed, Probable Oracle Net Admin Error"
Edit the SQLNET.ora file in a text editor such as Notepad.
Change this line to what is shown below:
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.AUTHENTICATION_SERVICES = (NONE)
Check Path at Env Var
Listener rights issue
Restart Listener
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 )
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;
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;
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
===========================================================================================
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
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
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
;
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
;
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
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;
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
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:
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
;
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;
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';
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';
FROM DBA_INDEXES
WHERE STATUS = 'UNUSABLE';
Subscribe to:
Posts (Atom)