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