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 )
);

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 )

ora-12801 ora-12853 ora-04031

not need to set large_pool or other

only set sga pga or memory

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

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

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 ;

impdp hang on grant role and sql SYS.kupc$que_int.receive

 increase stream_pool_size

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

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;

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;

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-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

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-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

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-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>

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

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