Archive for December, 2009

Oracle Cheat Sheet

Posted by Sergio Rodriguez de Guzman in Oracle on December 17, 2009

Some quick commands for oracle: 1. Some useful commands To start a session as sysdba: sqlplus sys@tnsname as sysdba; To start a sysdba session under Windows (9iAS): sqlplus “/as sysdba” To list all tables in current schema: SELECT table_name FROM user_tables; or, all tables current user has access to: SELECT table_name FROM all_tables; To list [...]

FacebookTwitterGoogle BookmarksLinkedInShare

No Comments

How to install Oracle Database 11g Release 2 (11.2) on Solaris 10 (Part 3 of 3)

Posted by Arnaud Delanoue in Oracle, Solaris on December 14, 2009

On my previous post (Part 2 of 3) we have seen how to install Oracle Database 11g Release 2 on Solaris 10, so now we are going to verify that the installation has been done successfully. How? First, we need to set up the environment for the oracle user by defining the variables ORACLE_HOME, ORACLE_SID, [...]

FacebookTwitterGoogle BookmarksLinkedInShare

, ,

5 Comments

How to install Oracle Database 11g Release 2 (11.2) on Solaris 10 (Part 2 of 3)

Posted by Arnaud Delanoue in Oracle, Solaris on December 14, 2009

After reviewing the requirements for installing Oracle Database 11g Release 2 (11.2) on Solaris 10, (see the previous post Part 1 of 3), let’s begin the installation. After unzipping the 2 downloaded files, we have a database directory which contains all the needed files for the installation and the OUI (Oracle Universal Installer), the GUI [...]

FacebookTwitterGoogle BookmarksLinkedInShare

, ,

4 Comments

How to install Oracle Database 11g Release 2 (11.2) on Solaris 10 (Part 1 of 3)

Posted by Arnaud Delanoue in Oracle, Solaris on December 14, 2009

The deal today is to install the last version of Oracle Database, which is the 11g Release 2 (11.2), on Solaris 10. The first part of an instalation process should be to verify the requirements needed by the software we want to install. So the question is : What are the Oracle Database Preinstallation Requirements [...]

FacebookTwitterGoogle BookmarksLinkedInShare

, ,

No Comments

Deploy a small Grid on Sun Fire T1000 with Solaris Containers

Posted by Jorge Moratilla in Geek, Networking/Security, Solaris on December 4, 2009

This post is the first of three posts in which we will show you how to setup a fresh installed Sun Fire T1000 Server as a Solaris container server and deploy the Sun Grid Engine 6.2u4 software on different, securified, isolated zones. Architecture We are using a T1000 with on 1 Chip MultiThread processor with [...]

FacebookTwitterGoogle BookmarksLinkedInShare

, , , , , , , , ,

No Comments