Hot answers tagged

3

Ok, that error (ORA-00600 [6856]) is related to corruption. Normally a DBA would go to My Oracle Support, follow the notes (for example ORA-600 [6006] ORA-600 [6856] During Startup Instance, Followed by Termination by SMON (Doc ID 549000.1)), identify the affected objects then try to repair them, recover corruption, or restore a valid backup. If you ...


3

According to the My Oracle Support, ORA-01792 is caused due to an unpublished bug. Oracle suggest to alter the query and/or view definitions to avoid the error. However in cases where the SQL cannot be adjusted then the checking can be disabled by: SQL> alter system set "_fix_control"='17376322:OFF'; Alternatively an interim patch for this fix (patch ...


2

if you do not have problems with your disks and the controlfile is corrupted you can do the following: start the database in nomount (startup nomount), then check the output of the command show parameter control (run the command in sqlplus). If the command shows more than one control file, you can overwrite D:\APP\FROZEN\ORADATA\ORCL\CONTROL01.CTL with ...


1

I implemented what you are trying to do this way: the transformation to a user defined object happens in a packaged procedure that is called by triggers. ---all comments and debugging removed to keep it simple---- CREATE OR REPLACE TRIGGER when_close_ini AFTER UPDATE OF end_date ON YOUR_TABLE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW ...


1

on Windows system you have to use oradim.exe to admnister the Oracle instance behavior. This is the documentation: Using ORADIM to Administer an Oracle Database Instance You have to check: if the Windows service exists (if not create it with oradim); how it is configured (using oradim)


1

Follow the below steps to get it done: Open the registry with regedit. Always back up the registry before making changes. Navigate to the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\oracle_home_name. There will be a key called: ORA_SID_AUTOSTART. SID is your database SID. This key should be set to TRUE. If not the server starts but does not start the ...


1

I would assume STDEV_SAMP is calculating the sample standard deviation and the other the population standard deviation. See http://math.stackexchange.com/questions/15098/sample-standard-deviation-vs-population-standard-deviation for some discussion of the difference. A quick search brings up https://www.mathsisfun.com/data/standard-deviation-formulas.html ...


1

In fact you have STDDEV, STDDEV_SAMP and STDDEV_POP. Sample and population are standard definitions for STDDEV. When calculating a standard deviation one needs to know if the data set is a sample or the entire population. There is plenty of explanation on the web about this. See for example Standard Deviation which states: The standard deviation is a ...


1

While investigating the cause of the problem we must be able to find the problem area. The top most error(ORA-00204) says that the Oracle process is unable to read the block from control file. Second error(ORA-00202) specifies the name of the control file which the Oracle process is unable to access and read. The exact error is OSD-04006, that this is ...



Only top voted, non community-wiki answers of a minimum length are eligible