Revlon New Complexion Concealer

A new adventure

In life, you know, happen to ask questions about what was done to a certain point in their lives, be it emotional, work, etc.. You pull out a little money and this is what has happened to me in recent months, particularly with regard to my work.

A premise is a must: in these two and a half years of work I was able to collaborate with colleagues, especially those of my own office, who have treated me well, from the human side as the professional I have whenever I have endured Broken boxes with my ideological wars VS Windows GNU / Linux), from whom I learned a lot (and which I hope I have left something in my very modest small stock of knowledge).

Secondly, my current job, Oracle DBA and systems engineer, I really like and I always tried to carry it forward with passion, sharing knowledge with many other fans of the sector, which has greatly helped me to grow professionally.

However, perhaps the young age (27 years old the other day;), perhaps because of the need to make some new experience, a little cut the umbilical cord that binds you to comfort the family, at work attached to home, I tried another opportunity to work, finding it!
As stated very clearly by the image of opening the post, one way is to close, that my Oracle dba activities and another opens in its place, my new job: GNU / Linux (hehehehehe).

will change a little of everything: from private to public step by Oracle dba and generic system, step by GNU / Linux full time, I'll move from Ferrara in that Casalecchio, life at home with my family, the independent living in an apartment (I just need to find it;)) and who knows what else. But hell, if I do not now, I have the impression that I would not ever again!

In short, this is a little bit of my blog post concluding that, anyway, I decided not to eliminate since it contains the fruit of two years working with Oracle, hack, of hours spent on sites, forums, mailing list to try (and sometimes write) solutions to the problems that arise every day in the life of a dba!

Greetings to all! Simone

Foundation To Cover Acne For Wedding

Ubuntu and Oracle SQL Developer

few days ago, tired of the constant infections Conficker strong and the fact that my pc is a simple workstation from which I connect on the machines I work with real (a mixture of Windows Server 2003 environments and GNU / Linux, real and virtualized), I decided to format my Windows XP PC that was equipped to switch to Ubuntu 8.10.

One tool I use for some time now and that gives me the same satisfaction of Toad (but more is free and does not require licenses) is Oracle SQL Developer. This software is written in Java so it's available for several platforms, including GNU / Linux, even if there is a deb package for Debian and Debian distributions like. If you want you can use the Alien tool to convert the rpm in deb, or you can always download a zip file containing the entire environment ready for use.

version for GNU / Linux comes with the Java SDK, needed to run the SQL Developer interface, but with Ubuntu 8.10, for example, you can easily remedy the deficiency with: $ sudo aptitude install

sun-java6-jdk

Suppose you want to use the zip file provided by Oracle, you can unpack, for example, in / usr / src /: $ tar xzf

sqldeveloper-1.5.4.59.40-no-jre.zip
sqldeveloper $ sudo mv / usr / src /

The script to run is in / usr / src / sqldeveloper (the path is to be adapted depending on the chosen installation directory):

$ cd / usr / src / sqldeveloper
$. / sqldeveloper.sh

However, you may notice the appearance on the terminal of an error message: Oracle SQL Developer

Copyright (c) 2008, Oracle. All rights reserved. Type the

full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~ / .sqldeveloper / jdk

In this case, you have to finish the creation of the script with Ctrl-C, and then create a directory called . Sqldeveloper (attention to the point of first name, because it is a hidden directory) in your home and all ' inside this directory create a file called jdk . This file must then contain the path to the jvm:

$ mkdir / home / username / .sqldeveloper
$ cd ~ /. Sqldeveloper
jdk
$ echo $ touch / usr/lib/jvm/java-6-sun> jdk

After that you can start SQL Developer with confidence!

How To Get A Lisence For Ambuled

Windows Vista and SP2-1503

A colleague of mine has just bought a classic laptop with Microsoft Windows Vista Home Premium SP1 (eh oh well ...) and, since its activities around each wheel to create web apps that interface with Oracle, has tried to install on this laptop, Oracle Instant Client 10.2.0.1. He followed the standard procedure, opting for an installation from an administrator, set up the tnsnames.ora entries with the correct, yet, launching a prompt sqlplus, or Toad, etc., shows the following error:



On the OTN forum we recommend:

1) correctly set the environment variables ORACLE_HOME, TNS_ADMIN, LD_LIBRARY_PATH and PATH
2) check the security settings of Windows as lacking permission "create global objects"

Now, the number 1 solution did not work and, apparently, Windows Vista Home Premium SP1 is not possible, or at least I have not found, access to policies a secure facility, so I could not verify the absence of the privilege "create global objects" for my user.

San Google, as usual, came to help me with this article by Christian Shay in which the author points out that Windows Vista is available for a package that allows you to install Oracle Client 10.2.0.3 directly, ie without need, as before, to install the client version 10.2.0.1 then patch it to 10.2.0.3 that, in fact, solves the problem SP2-1503. Retained
my time link to download the Oracle client version 10.2.0.3 for Windows Vista / Windows 2008!

install this package everything went smoothly, until I tried a connection to my db test with TOAD and end up with the following error (Bella Vista, yes yes):



Another Google search and landing on asktoad.com site and more specifically in this FAQ , here we read that the problem is caused by UAC: User Access Control, which is the system control user access to Windows Vista, when enabled (and it is by default) does not ensure that a user write access to Program Files directory . Also from the FAQ says that when Toad 9.5 is installed it creates a file called lexlib.new that, when you launch the GUI Toad should be renamed lexlib.lxl This has not been allowed by its UAC (unless Toad running as a user Administrator).

There are two solutions: *

disable UAC, for example as shown in this guide
Toad * run as administrator user

I chose the first option, which is very easy to implement!

Korean Entertainment Audition 2010

The startup and shutdown of Oracle are two important procedures that need to be able to perform properly to ensure the operation of the DBMS itself, as well as the integrity of data managed by it.

services (daemons within GNU / Linux) to boot before you can interact with the Oracle listener and one or more instances .
With Microsoft Windows, the services to which they refer are: *

OracleServiceSID: service bootstrap that allows the oracle instance starts, indicated by the string "SID". Once the service OracleServiceSID you can start / stop the instance manually
* OracleHOME_NAMETNSListener: is the service that is responsible to control the Oracle listener

For directors of Oracle on Microsoft Window recommend you take a look at this description (in English, but very clear) detailed and comprehensive services Oracle environment variables that you must set the registry key and fundamental to Oracle!

If you prefer the operating system GNU / Linux (as in my case;), Oracle provides the command "lsnrctl" for the management of the listener and the script "dbstart" for launching one or more instances. Both are located in the directory "$ ORACLE_HOME / bin". In order to automate
startup and shutdown of Oracle (listener instance + s, then), I use this simple script I found online and I called it "gestoracle.sh"

# / bin / bash #

# Run-level Startup script for the Oracle Instance and Listener

# # chkconfig: 345 91 19
# description: Startup / Shutdown Oracle listener and instance


# ORA_OWNR = "oracle" # if

the executables do not exist - display error

if [! -F $ OH / bin / dbstart-o! -D $ OH]

then echo "Oracle startup: can not start" exit 1



fi # Depending on parameter - startup, shutdown, restart
# of the instance and listener or usage display

case "$1" in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
$OH/bin/lsnrctl start
$OH/bin/dbstart $ORACLE_HOME
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
$OH/bin/lsnrctl stop
$OH/bin/dbshut $ORACLE_HOME
echo "OK"
;;
reload start reserved.

Start / u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: wait ...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
The file system parameters is / u01/app/oracle/product/10.2.0/db_1/network /
admin / listener.ora Log messages recorded
in / u01/app/oracle/product/10.2.0/db_1 /
network / log / listener.log
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1))) Listening on

: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = debiandb) (PORT = 1521)))
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))) STATUS of the LISTENER

------------------------ Alias \u200b\u200bLISTENER Version

TNSLSNR for Linux: Version 10.2.0.4.0 - Production Start Date
02-APR-
2009 08:58:14 Uptime 0 days 0 hours 0 min. 0 sec.
trace level off

Security ON: Local OS Authentication SNMP OFF

file parameters listener/u01/app/oracle/product/10.2.0/db_1/network/admin /

listener.ora Listener Log File / u01 / app/oracle/product/10.2.0/db_1/network/log /
listener.log
Summary table of the endpoints of listening ...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1)))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = debiandb) (PORT = 1521))) Summary table
services ...
The "PLSExtProc" has 1 instances. The application
"PLSExtProc" was UNKNOWN, has 1 handler for this service ...
The command was OK



Now that the DBMS is running you can start the application you want (always make sure that the ORACLE_SID system variable is correctly set):

debiandb oracle @: ~ $ export ORACLE_SID = TEST
debiandb @ oracle: ~ $ sqlplus / nolog

SQL * Plus: Release 10.2.0.4.0 - Production on Thu
April 2 08:58:39 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> conn / as sysdba Connected to an instance
suspended.

SQL> startup ORACLE instance started
.

Total System Global Area 1174405120 bytes Fixed Size 1267116 bytes

Variable Size 620759636 bytes Database Buffers 536870912 bytes

Redo Buffers 15507456 bytes Database
MOUNT run. Database opened

The procedure of "openness" of a database consists of several levels: *

LEVEL 0 - database closed:
instance is turned off and users can not perform login, access the data in db, etc..
*
LEVEL 1 - nomount:
running the command

SQL> startup nomount
Oracle reads the contents of the SPFILE, which contains essential information for the start of the specified by the ORACLE_SID system variable (for example, the size of the various areas RAM to be reserved for instance, the size of blocks of data, the character set, etc.), so is the start of the instance by allocating a certain amount of RAM and the start of

background processes.
The database is not yet accessible to users.

* LEVEL 2 - MOUNT:
accessible from level 0 with the command:

SQL> startup mount
or from level 1 with the command
SQL> alter database mount;

This level Oracle reads the contents of s control file, the file system whose position is indicated in the SPFILE, to determine the position, again on a file system, in the datafile, however, fails to open.

* LEVEL 3 - OPEN:
state open database can be accessed directly from level 0 with the command
SQL> startup or from levels 1 and 2 with the command
SQL> alter database open mounts in Oracle read-only or read / write the datafile, then the data contained in the database are accessible to users.

As usual, you can freely download the image

start post as released under Creative Commons Attribution-Noncommercial 2.0 Generic
;)

Ideas Of Psa Commercial

Startup and shutdown ORA-01940: Can not drop a user is currently connected That

It 's a bit of time I do not write on my blog, but alas, this time working with Oracle has absconded and, consequently, also the ideas from which I draw my posts: (
This morning, however, a simple operation DROP a user in my db test initiated an Oracle error ORA-01940
: can not DROP a user is currently connected That
Abstract:

diagram above is the backend application web-based jsp made and run by Tomcat. Of course, before you run, user-system, drop the schema you want, I am concerned to warn users that they were working in the test of effetturare log out, then, given a reasonable period of time, I stopped the Tomcat server .

Time:
I thought that any hung sessions db level should depend on the presence of some users still connected with the ongoing operations in the test when I ran the stop the Tomcat server.

The view v $ session provides all the session information for active / inactive / kill and it is from this that one must start to do some diagnostics. The following SELECT statement queries the view just join in with another view of the system, ie
v $ process in order to get the id, the serial number and status of the session, as well as the PID of the process to it connected.

SQL> select s.sid, s.serial #, s.status, p.spid from v $ session s, v $ process p WHERE

s.username = 'MyUser' p.addr and (+) = s.paddr;
The result you get is something like: SID SERIAL # SPID
STATUS ---------- ---------- ----- ------------ 12065 136 48808 135 31 595 INACTIVE INACTIVE
11092 12030 132 12 779 INACTIVE Now, inactive sessions can be terminated with the following command (to be repeated for each session to be terminated, and of course to run as a user with DBA privileges):

SQL> alter system kill session '';
rerun the query from v $ session view is that the sessions will be passed to the "KILLED", however, as has happened to me, it can happen that after a few moments, new sessions (or even when you kill them) come back again to the "INACTIVE" again making it impossible to run the drop of the user. I personally believe that Oracle tries to bring completed the job submitted by the Tomcat server db and encapsulated in the sessions described above, but having already lost the connection to the Tomcat, these sessions are always in the "INACTIVE".
The solution is really simple, just put it in the lock before you drop idle sessions:

SQL> alter user MyUser account lock;


You can then proceed to drop the user with peace of mind!

Conclusion:

starting from system views it solves everything! ;)

The image of early post with the garden gnomes I've recovered from

here and is released under Creative Commons
Attribution-No Derivative Works 2.0 Generic

(so you can copy and distribute it). I put it because one of the dwarfs have sunglasses -> need to see -> views of Oracle -> sclero:-D

<#sid,#serial>

Dragon Ball Z Comple Bed Set

ARCHIVELOG mode and nu metal

As passionate about Oracle and metal music (especially in nu heavy and its variants) when I saw this video I decided to propose it again!

The video explains how to put a db in Oracle 10g
ARCHIVELOG mode and the background sound suggests the mythical
System Of A Down . For completeness, I refer you to the excellent blog author of the video and to his personal page on Youtube
with other interesting videos on Oracle.

Enjoy and happy listening!

Angela Pitts Myammee Hairstyles

ANGELO mosaic

The mosaic is executed with technical pose direct on a panel of marine plywood

Decoration Landscaping made with resins in natuirali spatula

cm 250 x 180

family graves, cemetery of Altessano, Torino

Coupon For Bonefish Grill, Jacksonville Fl

PAINTINGS AND WORKS OF DECORATIVE CEILING CENTRES




























representation of figurative images carried on board in painting and mosaic

Missionary Wrap Legs Around Man

inserts made of polychrome marble floors

Maturebritish Women In Girdles

FLOORING














threshold polychrome marble with mirror drawing performed by the technique of laying backward. Sita
mansion in Turin. 100 x 75 cm














Stadt Montecarotto (AN).
with marble on glass fiber mesh. 100 x 80 cm














badge runs for a grand hotel in San Marino.
with marble on glass fiber mesh. 100 x 100 cm

Mickie James Doing A Stripteas

In essence, allows Oracle Streams to replicate this scheme on a stream in a db db destination, in addition, any DDL or DML performed under schema to be replicated on the source will also check the db schema replicated in the destination db.
on OLTP databases, the process of extracting data can not be run directly as it interferes with normal DDL / DML, because the architecture uses Oracle Streams ARCHIVELOG, decidedly intrusive chin. Before you can use Oracle a stream, you must ensure that they meet certain prerequisites:
1) configure properly the two db server so that you can run tnsping db server from source to destination and vice versa 2) put both in ARCHIVELOG MODE databases

3)

create a user for the management of the stream to both Oracle database

4) create a db link to the initial creation, only to run the first time, the db replica on the target schema using the Data Pump utilities 5) create a db link from the source to the destination db, useful in cases where the initial creation of the schema replication occurs at the network without using an intermediate dmp file (I also created this db link anyway) 6) configuration utilities and expdp impdp both the source database is on target qyello

7)
create a directory and a corresponding Oracle db file system directory on the source server to host the script generated by the DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS that deals with the schema replication via Oracle streams.
Assuming for convenience that the points 1) and 2) are already satisfied, I start directly from step 3). Henceforth, the term "PROD" identifies the source database and the letter "TEST" identifies the target. The scheme will be to replicate the ubiquitous "SCOTT!"

1) OK 2) OK 3) create a user on the management of the stream, and on both PROD to TEST, connect as user SYS as SYSDBA:
streams_tbs CREATE TABLESPACE DATAFILE '/ u01/app/oracle/oradata / streams_tbs.dbf ' SIZE 25M;
strmadmin CREATE USER IDENTIFIED BY DEFAULT TABLESPACE strmadminpw streams_tbs
QUOTA UNLIMITED ON streams_tbs; GRANT DBA TO strmadmin;
BEGIN DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE (
grantee => 'strmadmin', grant_privileges => true ) END;
4) Set a db link from PROD to TEST for the initial import of the schema to be replicated:

- to connect strmadmin
PROD / PROD strmadminpw @

CREATE DATABASE LINK TEST CONNECT TO
strmadmin
STRMADMINPW

IDENTIFIED BY USING 'TEST';


5) Now create a db link from TEST in PROD:

- connect to TEST
strmadmin / strmadminpw TEST @ PROD

CREATE DATABASE LINK TO CONNECT
strmadmin
STRMADMINPW
IDENTIFIED BY USING 'PROD';


6) configure the data pump utilities of the two db server by creating an Oracle directory called "source" on the PROD db server hosting and a directory of Oracle named "dest" on the db server hosting TEST. The two-level operating system directories are created with the appropriate operating system commands (mkdir, for GNU / Linux):

- up conn sys @ PROD PROD

as sysdba CREATE OR REPLACE DIRECTORY source AS '/ u01/app/oracle/oradata/source ';
GRANT READ, WRITE ON DIRECTORY TO strmadmin source;

- to TEST
conn sys @ TEST AS SYSDBA CREATE OR REPLACE DIRECTORY
dest AS '/ u01/app/oracle/oradata/dest';
GRANT READ, WRITE ON DIRECTORY dest TO strmadmin;

7) create an Oracle directory and a corresponding file system directory on the db server that hosts the database PROD. This directory will contain the script to run for the SCOTT schema replication from PROD to TEST via Oracle streams:

strmadmin CONNECT / @ PROD strmadminpw
CREATE OR REPLACE DIRECTORY SCRIPT_DIR AS '/ home / oracle / script_dir';


Once satisfied all the requirements, the db server hosting PROD I have created a strmadmin script to run as user with the following contents:

DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS (
schema_names => 'scott',

source_database => 'prod',
destination_database => 'test',
capture_name => 'capture_scott',

capture_queue_table => 'rep_capture_queue_table',
capture_queue_name => 'rep_capture_queue',
capture_queue_user => null,
apply_name => 'apply_scott',
apply_queue_table => 'rep_dest_queue_table',
apply_queue_name => 'Rep_dest_queue',
apply_queue_user => null,
propagation_name => 'prop_scott',
log_file => 'exp_scott.log',
bi_directional => false,

include_ddl => true, instantiation =
> dbms_streams_adm.instantiation_schema,
perform_actions => false,

script_name => 'schema_replication.sql',
script_directory_object => 'script_dir'
)

END;

I would say that is a must for an explanation of the basic parameters Otherwise, it does not understand much: *


schema_names:
the schema name (or patterns, separated by commas) to propagate (in this case Scott) *

source_database:
the source database

destination_database *:
the target database

* capture_name:
the name of the capture process configured to capture changes made on PROD

* capture_queue_table:
append the table name for each queue used by a capture process

* capture_queue_name :
the name of each queue used by a capture process

* capture_queue_user:
be set to null to indicate that the procedure can not give the grant of any privilege

* propagation_name:
spread the name of each configured to propagate changes
* log_file: the name of the log file generated by expdp
* bi_directional: if set to 'false' indicates that the delegate spread is one-way information from the production db to test
* include_dll: set to 'true' indicates that both the DDL and DML ones are replicated from the source db to the destination
* instantiation: if set to DBMS_STREAMS_ADM.INSTANTIATION_SCHEMA indicates that the instance of the target schema will be performed using the utilities expdp / impdp
* perform_action: if set to 'true' allows the script PL / SQL, when set to 'false' stores the result in another script that will be placed in the directory indicated the parameter 'script_directory_object'
* script_name: set with the string 'schema_replication.sql'. This script will be created in Oracle directory 'script_dir' (/ home / oracle / script_dir) and will contain all the steps to instantiate the schema replication
* script_directory_object: the Oracle directory to store the script 'schema_replication.sql'
Flipping the script Oracle does not start the stream, so even the replication process on the user SCOTT db TEST, but the script is created schema_replication.sql in / home / oracle / script_dir that will always run in part as a user strmadmin @ PROD. The creation of intermediate script checks to see if there were errors during the execution of the procedure DBMS_STREAMS_ADM.INSTANTIATION_SCHEMA, alternatively, you can always skip the middle and create the script directly launch the procedure DBMS_STREAMS_ADM.INSTANTIATION_SCHEMA with these parameters:
DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS ( schema_names => 'scott',
source_database => 'prod', destination_database => 'test', capture_name => 'capture_scott',
capture_queue_table => 'rep_capture_queue_table', capture_queue_name => 'rep_capture_queue', capture_queue_user => null,
apply_name => 'apply_scott', apply_queue_table => 'rep_dest_queue_table', apply_queue_name => 'rep_dest_queue',
apply_queue_user => null, propagation_name => 'prop_scott', log_file => 'exp_scott.log',
bi_directional => false, include_ddl => true, instantiation = > dbms_streams_adm.instantiation_schema,
perform_actions => true ) END;


be noted that the "perform_actions" is now set to true and not to guidelines "script_name" and "script_directory_object.
If everything works correctly, the TEST db will be an exact replica of the db schema SCOTT PROD, now you just have to test if any DDL / DML performed on the schema SCOTT @ PROD is also replicated on SCOTT @ TEST.

Good replica!

Ah, I leave some useful links to deepen the subject: *

http://www.dba-oracle.com/t_streams_schema_replication.htm


http://ca.geocities.com/mosicr * @ rogers.com / * OracleStreams101.htm


http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_strm_a.htm # ARPLS305

Foto Nu Long Dong Silver

Oracle Streams Oracle and SQL Server





Last week I were asked if we could share the supplier master contained in a table on an Oracle db with our warehouse management software that uses a database on SQL Server 2005 platform. A quick Google search led me to

linked servers, or components of Microsoft SQL Server (I used version 2005 Standard Edition) that allow this RDBMS to communicate with heterogeneous data sources such as Oracle or AS400 and even Excel spreadsheets!

The components of a linked server are two: *

OLE DB (a DLL that handles communication with a data source) * OLE DB data source

Looking for a guide that explains how to set up a linked server from SQL Server to Oracle I came across this blog post by Greg Wright
, really clear and well done. Basically, Greg suggests in the first instance to install the Oracle client (Possibly in a version compatible with the Oracle db which must be connected) on the same machine on which you installed SQL Server, and then, using Net Manager or by manually editing the tnsnames.ora file, you must configure a service name that points db Oracle desired. In the post, following the configuration of the linked server, and finally launched an example of a query via SQL Server db on Oracle to which you connect to.

In particular, wanting to run a SELECT db on Oracle via linked server, the syntax is:

select * from OPENQUERY (linked server, 'select * from dbname.tablename where clause') The key to the previous statement is function openquery whose purpose is to return a table with a record set of the query (the second parameter of the function) run on the db (Oracle) to which you connect through linked server (the first parameter of the function).
Wishing You can also perform joins between tables in SQL Server and Oracle tables with a syntax like this: select
tabellaSQLServer.campo1, X.campo2, X.campo3 from tabellaSQLServer
join openquery (nomeLinkedServer, 'select * from AltraTabella where Condition = 1 ') X = on tabellaSQLServer.campoSQLServer X.campoAltraTabella

Well, everything is now continuing with my connection test SQL Server - Oracle!

Kates Plaqyground Vids

L ' ABC


work with Oracle for a couple of years and almost got in a head that big will the DBA, yes! :-D

Like anyone approaching for the first time to a new topic, I immediately searched the documentation that would clarify the various aspects of Oracle.
In my experience, the main sources from which to draw information: *

colleagues (very useful to directly ask those who know more) * books (the old print media is always a good starting point) * Internet

after breaking up a few boxes just not willing connects with all my questions (forgive me) and seeing that the role DBA increasingly fascinated me, I started to browse through literally hundreds of pages in pdf format on many different subjects that revolve around this RDBMS, subscribe to forums, mailing lists, groups on Facebook, etc.. All this has allowed me from time to time, to solve problems of various kinds, for example relating to the installation of Oracle Database Server, or the backup management, or execution of SQL queries to generate reports, and so away, but I always felt that I lacked a more orderly way (from the standpoint of DBA, as always) like this:

BASES FOR ORACLE -> Install DBMS -> DB CREATION -> Backup Manager - -> PERFORMANCE TUNING

Unfortunately, this led me to having to take back many times the same things maybe because I discovered not to have them studied and thorough enough before, or they may discover a document that I should study before losing, in fact, long .

With this post I intend to csotruire a sort of primer (see image at the beginning of post) useful for an orderly approach to Oracle and its documentation.
1) BASIS OF ORACLE: Oracle Database Concepts

Oracle is the official document that explains the foundations of the popular RDBMS

2) INSTALLATION: in this case comes to rescue an entire section Oracle documentation team (version 10.2 of the DBMS). It is not necessary to read all the documents proposed (I have a lot), but simply choose the suitable one according to its platform hw (32/64 bit) and SW (Microsoft Windows, FNU / Linux, Solaris, etc.)

3) CREATING DB: the essential guide to reference (and even more technical), is known
Administrator's Guide


4) MANAGEMENT BACKUP: You can find the section (Backup and Recovery) in the homepage of the Documentation for Oracle Database
Server 10.2 through the tab "Administration"

5) PERFORMANCE TUNING: topic
the "Performance Tuning Guide"
on how to configure and monitor the performance of Oracle Database Server


points made above are, in my view, the wealth of knowledge that should be right of the figure and from which the DBA before interested in other aspects of this complex and powerful RDBMS.
Happy reading!

How Do You Wear Sleeveless Sweater Vests?

DBA Oracle Critical Patch Update January 2009



Tuesday, January 13 was a full day rather than in terms of patch simultaneously with the release of security bulletin MS09-001
Microsoft on the Windows SMB protocol and Critical
Patch Update released by Oracle for this first quarter of 2009.
take advantage of this double issue to create a parallel between my own personal activities of the system and the database administrator with regard to the installation of the patches (I have no certificates for any of the two roles, but in fact is what I'm involved to work):

1) both must be able to document any patch updates even before they are issued, in order to gather information on the vulnerabilities covered by the patches, set up a test on which to test it before going into production, the operation schedule update and experience, as a result, users of any downtime of the services offered by the servers affected by the update. In this sense, a good starting point it provides the network. The administrator of Microsoft Windows will not wait for the automatic notification of Windows Update, but will use sites like Feliciano Intini Blog
, for example, in the same way, the Oracle DBA can refer to
OTN (Oracle Technology Network )
.
short, the imperative is
ALWAYS BE ADVISED!

2) the output of a new patch, both the sysadmin and the DBA should consider the impact that the application of the patch itself will have on their servers can test it, if time permits, on a

"sandbox" , ie a test environment. The testing phase is vital to ensure that the update is successful and does not create problems, once installed, the configuration of server / DBMS
3) after a necessary and crucial phase of testing, the application the patch must be done also in the production (which should take place when users are not connected and should not cause problems, if enough testing has been carried out as described in step 2) The purpose of this post First of all, is to acquire the skills necessary to install the CPU January 2009 (1), while the phase installation of the patch update in a test environment (step 2) will be the topic of a post I will publish soon!
Ok first of all need to read up on so I head
section dedicated to the OTN Critical Patch Update
, my goal is to answer some questions: *
what vulnerabilities are resolved by the January 2009 CPU?
* in which products (and version) Oracle can apply? * should install it or are there any contraindications? * as you install it? Link on CPU on OTN contains lots of useful information, for example, we learn that the update patches are issued on a quarterly basis, In fact, the upcoming release dates are: April 14, 2009 *

* * July 14, 2009 October 13, 2009 * January 12, 2010
addition, OTN provides two useful links to resources that indicate respectively how to enable the notification
email
the CPU as soon as they are released and a PDF document with
"Best Practices"
to install the patch updates.
In particular, the OTN
page dedicated to the CPU
January 2009 contains a list setting out for comfort even in the picture below, with all the versions of Oracle software and interested in the application of the patch:



Assuming, as in my case, it will apply the patch to the component of Oracle Database Server 10g, you can see from the above table, for example, as the version 10.2.0.1 of the DBMS is not supported (some more information it can
read from this thread on the forum
OTN), as well as Oracle Database Server versions prior to 9.2.0.8, and so on.
you read on the same page on OTN, it was discovered that the patch updates are cumulative for many Oracle products (not all though), that is, each CPU includes all previous fixes of the CPU. Fortunately, this case applies to Oracle Database Server and then just install the patch to update for January 2009 also fixes the previous patch updates!
Still the same page of OTN contains a table, reproduced below, with the list of products affected by the January 2009 CPU, the links to the risk matrices (tables that set out a list of vulnerabilities and their description for each family of commodities for which Oracle recommends that you install the patch), links to Metalink, etc..







It follows, then, include a table taken from the Metalink note 753340.1 on the CPU in January 2009, as supplied, the summary notes, also on Metalink, to access documentation and download the CPU JAN 2009 for various platforms and versions of Oracle Database Server:

For this time all the material there is plenty to digest. In the next post will deal installing CPU Jan 2009 on my test system, ie a virtual machine Debian GNU / Linux installed with Oracle Database version 10.2.0.4, all VMware ESXi!

Help For Dexedrine Side Effects

Extend the functionality that Blogger




Yesterday I found myself with some free time so I took the opportunity to study the potential of Blogger, the platform made available by Google to quickly and easily create a blog, just like this. Blogger allows, once set up the skeleton of your blog (via GUI css ready for use, gadgets for inclusion in the side panel to enrich your pages, etc.), to further extend the functionality through the inclusion of widgets created by third parties, provided compatible with the platform itself. Definitely cool to do some testing!

First I tried a few online resources covering the topic well and I ended up Creareblog . The howto presented by Tenebrae, the author of the blog, there are indeed numerous and well made and I recommend you read if you're interested in this!
Changes to my blog are both aesthetic and functional:

- removed the top bar added to the default platform blogspot blog (do not incur any legal dispute by doing so, then why not?)
- Blogger does not by default, to publish only an introduction to the homepage Articles are too long and while posting entirely in separate page (accessible by the user clicking on a link type "Read more" ). Now you can! :-D Very comfortable!

- To differentiate the lines of code from the rest of the text, while composing the post using the pre tag

and

tt. So I changed the css by adding the following lines: / * Code style * /
.
code {font-family: courier new;
font-size: 85%;}
blockquote.code {background: Gainsboro;
border: 1px solid LightSlateGray;
padding: 5px 5px ;
white-space: pre;}


The result you can see above.
- I added a tag cloud
the side panel. Certainly less comfortable than traditional well-ordered list of tags, is also likely to be seasick, but I like me ;-) - I also added a search engine that uses Google as the basis for the articles the blog (including this component is accessible from the sidebar). It was practically forced addition, since removing the top bar of Blogger (see point 1), I found myself without a search engine with which post in my blog.

Although the focus of this blog is more to a kind of notebook where exactly everyday experiences, trial and error combined by me and others, as long as it rotates around the world of Oracle, the mere fact that someone can read what I write is for me a source of satisfaction. As some readers will not give me more obnoxious, in fact, comments and any collaboration proposals are always welcome, I thought of putting into practice the tips of

Creareblog
for the positioning of my blog in the major search engines, starting from the same Google that is most commonly used at the global level and then passing to

Microsoft Live Search and Yahoo

.

addition to indexing of my blog on the main search engines, I have also
article Creablog of publishing the sitemap for a site on Google, Live Search, or Yahoo
.
What's a Sitemap? I quote from above post:

[cut]

The sitemap is a document that contains information about the post and the hierarchical structure of a blog. It 's very similar to the feed and in the case of feed ATOM formats match. The Sitemap of your blog can be sent to a search engine so that they are properly indexed pages.

Google Webmaster Tools is the best known tool for the reporting of your sitemap and in general for information and statistics on its website in terms of search engine. Contrary to popular belief, tell them your sitemap to Google does not imply a better ranking in search results, at best allows it to be our blog for a more coherent approach to issues it contains. Report on our website also does not accelerate the process of indexing the pages. This is what is explicitly stated by Google, and that there is actually the field.
[/ cut] Google Webmaster Tools allows you to have significant statistics for your site / blog provided directly from Google.