Oracle Database 12.1.0.2 has been released

Oracle has released Oracle database version 12.1.0.2 and it has many new features, and a major one every body is waiting for (in-memory).

The release is a “full instillation” so no need to install first 12.1.0.1

**other features in the new release are:

  • Improvements to Oracle Multi-tenant
  • Advanced Index Compression
  • Zone Maps
  • Approximate Count Distinct
  • Attribute Clustering
  • Full Database Caching
  • Rapid Home Provisioning

this new “Enterprise Edition” is certified on Linux and Solaris platforms so far.

a very good paper released by Oracle for the new in-memory feature can be found here:

http://www.oracle.com/technetwork/database/in-memory/overview/twp-oracle-database-in-memory-2245633.html

Oracle Blog Reference & instillation link reference:

https://blogs.oracle.com/UPGRADE/entry/oracle_database_12_1_0

 

as an Oracle DBA Excited ¬†ūüôā

cheers !

Scheduling Python arcpy script in windows task scheduler

The following steps illustrates how to schedule a python script in windows server task scheduler….this can also be applied to any other scripts if applicable:

 

1. create a new task

1

2. ¬†under “General” tab setup the general task scheduler description & properties as shown below

2

 

3. under “triggers” tab schedule the specific time for the execution of the script

3

 

4. ¬†under the “Actions” tab under the program/script section you should reference the python script.

under add arguments (option) you should reference the location of your arcgis desktop python libraries.

4

 

5. ¬†under “conditions” tab

5

 

6. under “settings” tab:

6

 

ORA-00832: no streams pool created and cannot automatically create one / stream pool and expdp

if you face the following error while performing a datapump export operations:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPV$FT_INT”, line 672
ORA-39080: failed to create queues “KUPC$C_1_20140711224328” and “KUPC$S_1_20140
711224328″ for Data Pump job
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPC$QUE_INT”, line 1606
ORA-00832: no streams pool created and cannot automatically create one

Solution:

check the current sizing of your shared_pool_size, by using the following command:

SQL> show parameter shared_pool_size 

10% of the value of the shared pool size will be assigned to the streams pool (also, buffer cache size will be reduced) 

So, alter the value using the command:

SQL> alter system set streams_pool_size = (10%of shared pool size) scope = spfile;

and then try use expdp command again….

*********EXPLANATION*******

Oracle DataPump utility which is frequently used by many Database Administrators will in fact be using “Streams Pool”, this stream pool size will be assigned 10% of the size of the shared pool and will reduce the amount of the buffer cache.
To avoid reduction of other memory structures sizes (shared pool,buffer cache) you need to configure the streams_pool_size with proper value as Data Pump operations will use streams !!!

if, sga_target is equal to zero then SGA is not auto-tuned

SQL> show parameter sga_target

NAME TYPE VALUE
———————————— ———– —–
sga_target big integer 0

so, its better to set a value for the SGA to be automatically tuned.

 

 

Unable to create logfile system tables. User perhaps lacks permissions or resources to create tables

while performing an editing session in ArcMap, you may receive the following error message:

Unable to create logfile system tables. User perhaps lacks permissions or resources to create tables

 

solution:

Your ArcSDE Geodatabase is configured for a “standalone log file architecture”.

for more information:http://resources.arcgis.com/en/help/main/10.2/index.html#/Log_file_table_configuration_options_for_geodatabases_in_Oracle/002n00000014000000/

use the “sdeconfig” command to list the parameters or the server_config system table under your SDE schema.

The user will require the following permissions granted to him:

CREATE SESSION
CREATE TABLE
CREATE TRIGGER
CREATE SEQUENCE
CREATE PROCEDURE

 

cheers!