New answers tagged

0

suppose Orcl service already created but you can't communicate with them then do follow : you need to run your database service like "oracleServiceorcl" as a Administrator so that client server can communicate. If any doubt then plz put error like ora- Any Digiy


0

Do not use show sga for querying the current SGA size. Total System Global Area in the output of show sga is computed as select sum(value) from v$sga, you can easily confirm this by enabling SQL trace. SQL> select * from v$sga; NAME VALUE -------------------- ---------- Fixed Size 2258040 Variable Size ...


0

I've struggled the same problem and I think the problem comes from gnome failing to pop up the confirmation dialog. That's why there is nothing in the error logs. So what I did is changing the window manager from gnome to xfce. That solved the problem. It would probably work with another manager or there may be a fix for gnome but here is how to install ...


0

memory_target is a dynamic parameter which can be set dynamically not necessarily its changes reflect on various components. Its value can be increased up to memory_max_target value.The SQL>show sga shows the MEMORY_MAX_TARGET and ‘Variable Size’ included the memory it will not use. For details: MEMORY_TARGET and MEMORY_MAX_TARGET


0

Oracle's optimiser is clever, it makes decisions about how best to do certain things (e.g. joins) based on what the contents of the tables are. At least, it can do if it knows what the contents of the tables are. The optimiser uses table statistics to achieve this. If it knows that there is a particular type of data, or a particular distribution of ...


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


-1

you should create at least one database user that you will use to create database objects. A database user is a type of database object: a user is associated with a database schema, you connect to the database as a database user, and the database user is the owner of any database objects (tables and so on) that you create in the schema associated with the ...


0

BEGIN DBMS_WORKLOAD_REPOSITORY.create_baseline ( start_snap_id => --ANY Integer Number_Min Value, end_snap_id => --ANY Integer Number_Max value, , baseline_name => 'batch baseline'); END; / So here min and max value are already in DBA_HIST_BASELINE view. You can't chose random value for snapshot. Remember value already in oracle ...


0

$ORACLE_HOME/dbs is used to store the spfiles, init files and password files on Linux and Unix systems. But as you pointed out the dbs directory not used on windows servers. So on a Windows servers it is probably not needed.


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


0

I addressed this with the PL/SQL project manager years ago, and was told that it is not possible. You can't address the :NEW or :OLD columns as a record and convert them to anything. You can create a temporary table that is either identical to the table that you are writing the trigger for or generic, i.e. table_name, column_name, column_type, clob. You ...


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

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


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

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


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


0

When you delete a table without 'purge' clause, this table "goes" to recyclebin. However, recyclebin its not a different physical space. Oracle just mark those table blocks as "they are part of a table in recyclebin". Reclcledbin table's blocks aren't shown in dba_extents view, but they count in dba_free_space view. If you want to check, try this: ...


0

ORA-3262: the file is non-empty *Cause: Trying to drop a non-empty datafile *Action: Cannot drop a non empty datafile To drop the datafile following requirement should be met.Datafile - cannot be offline must be empty should not belong to read-only tablespace cannot be the first file that was created in the Tablespace(Can drop tablespace) ORA-3262 ...


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

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)



Top 50 recent answers are included