Archive

Archive for the ‘Oracle’ Category

Tizen Linux for mobile tablet smartphone will takeover the world. Backed by Intel, Samsung, Linux foundation. Good luck.

February 26, 2012 1 comment

Tizen Linux for mobile tablet smartphone will takeover the world. Backed by Intel, Samsung, Linux foundation. Good luck.

– Android is less important in such case

– IPhone also

 

Advertisements

How to create a database without any database server?

August 5, 2011 Leave a comment

@todo

Please ask, i will post how to’s

Categories: MySQL, Oracle, PHP, Zend

CentOS zend server oracle enterprise interconnect

April 12, 2010 Leave a comment

* Go Centos 5.4
* Zend server / PHP enterprise / Oracle

1. Setup the yum download links

[root@www yum.repos.d]# pwd
 /etc/yum.repos.d
[root@www yum.repos.d]# <strong>wget http://public-yum.oracle.com/public-yum-el5.repo</strong>
--2010-04-12 13:32:23--  http://public-yum.oracle.com/public-yum-el5.repo
[root@www yum.repos.d]# ls
 adobe-linux-i386.repo  atomic.repo  CentOS-Base.repo  CentOS-Media.repo  mirrors-rpmforge  <strong>public-yum-el5.repo</strong>  rpmforge.repo  rpmforge-testing.repo  zend-server.repo
[root@www yum.repos.d]#

Read more…

Categories: cakePHP, centOS, Fedora 12, Oracle, PHP, Zend

CentOS jdeveloper forms builder gui pl sql getting started installation

April 11, 2010 Leave a comment

* Centos 5.4
* Get jdeveloper : http://www.oracle.com/technology/software/products/jdev/htdocs/soft11.html

1. Make world executeable


[root@www Desktop]# chmod a+x jdevstudio11112install.bin


2. Installer execute


[root@www Desktop]# ./jdevstudio11112install.bin
Extracting 0%....................................................................................................100                                                              %

Done

Categories: centOS, Fedora 12, Oracle

CentOS – oracle sqlplus use command line sqlplus manage

April 11, 2010 Leave a comment

SQL> CREATE TABLE employee 2 (fname VARCHAR2(8), 3 minit VARCHAR2(2), 4 lname VARCHAR2(8), 5 ssn VARCHAR2(9) NOT NULL, 6 bdate DATE, 7 address VARCHAR2(27), 8 sex VARCHAR2(1), 9 salary NUMBER(7) NOT NULL, 10 superssn VARCHAR2(9), 11 dno NUMBER(1) NOT NULL) ; Table created. SQL> Cockpit:

SQL>connect SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 11 19:11:22 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect

Enter user-name: system

Enter password:

Connected.

SQL> exit

Categories: centOS, Fedora 12, Oracle

Centos oracle oracle10g learn oracle quick install oracle linux getting started centos oracle

April 11, 2010 3 comments

* GO CentOS 5.4 (enterprise linux get it)
* Oracle get it: http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html

1. installing oracle 10g

[root@www Desktop]# <strong>yum --nogpg localinstall oracle-xe-10.2.0.1-1.0.i386.rpm</strong>
Loaded plugins: fastestmirror
Setting up Local Package Process
Examining oracle-xe-10.2.0.1-1.0.i386.rpm: oracle-xe-10.2.0.1-1.0.i386
Marking oracle-xe-10.2.0.1-1.0.i386.rpm to be installed
Loading mirror speeds from cached hostfile
* addons: ftp.belnet.be
* atomic: www5.atomicorp.com
* atomic-testing: www5.atomicorp.com
* base: ftp.belnet.be
* contrib: ftp.belnet.be
* extras: ftp.belnet.be
* rpmforge: fr2.rpmfind.net
* updates: ftp.belnet.be
Resolving Dependencies
--> Running transaction check
---> Package oracle-xe.i386 0:10.2.0.1-1.0 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================
Package         Arch       Version              Repository                          Size
==========================================================================================
Installing:
oracle-xe       i386       10.2.0.1-1.0         /oracle-xe-10.2.0.1-1.0.i386       380 M

Transaction Summary
==========================================================================================
Install      1 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total size: 380 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing     : oracle-xe                                                          1/1
Executing Post-install steps...

You must run '/etc/init.d/oracle-xe configure' as the root user to
configure the database.

Installed:
oracle-xe.i386 0:10.2.0.1-1.0

Complete!

2. /etc/init.d/oracle-xe configure


[root@www Desktop]# <strong>/etc/init.d/oracle-xe configure</strong>

Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:<strong>8080</strong>

Specify a port that will be used for the database listener [1521]:<strong>1521</strong>

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
<strong>initial configuration:
Confirm the password:</strong>

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:<strong>y</strong>

Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"
[root@www Desktop]#

3. Open it in firefox browser: http://127.0.0.1:8080/apex

Done

*go oracle on fedora/centos.

Oracle VS MySQL

December 23, 2009 Leave a comment

Oracle VS MySQL – [ 1990 till 2010 this report, will not maintain for next decades]

Top 6 Points:    Oracle/with Mysql and almost others
———————————————————————————————————————————————————–

1. JVM :  http://projectkenai.com/projects/mysql-jvm/pages/Home

2. storage safety

3. data lose 99%

4. lots of features

5. RAC (allowing others to share)

6. ASM (is oracle's logical volume manager)

Inquery:

Q. Mysql and Oracle what is the biggest fair?

A. oracle is a database, mysql is a pimped excel sheet collection, PL/SQL is a language that runs inside the database (like the JAVA stuff, too), Ruby/PHP/GTK runs outside the database.

LET CONSIDER: from database it runs, did you mean if oracle processid id = 2244, plSQL runs from 2244 process id or new thread id ?
no, i the language is interpreted and executed by the database system
stored procedures, functions, java packages
they run inside the database system
no i don’t mean “oracle comes with a JRE”
i mean “oracle integrated a JVM into the database system itself”

pump mass data into your mysql server, all CPUs at 100%, mass storage IO at maximum, several hundert MB/s
then pull the cables
do you really think your database survives this?
no, i give up for that.
with oracle i only lost data one time, a hardware bug from a RAID controller that injected wrong data/didn’t complete write operations
for the rest… nothing. power outs, subsystem failures, etc etc etc
no data loss
okay, needs some percent of luck, too, but in general… you start the instance, it recovers as much as it can, and goes online
if it can’t recover to a consistent status, it won’t open the database
if you can open it (without hacks), you can be sure it’s consistent (regardless physical block failures and stuff, that’s another story)
(i mean “if you can open it after a crash”)

Q. in which case its pimped excel sheet compared to Oracle, size of data? like wirehouse data vs bank ?

A. how often can you push the power button of a mysql server, until you’re unsure if the data is still consistent?

the concept is completely different, mysql is just a file editor with SQL interface. oracle is that, too, but that’s just one part of it

Q. in short if i think, what made it so powerfull from xyz DBMS ? its engine or the storange or the features it allows to solve problems?

A. *storage
yes. if you need a guestbook on your homepage, you don’t need oracle. if you need a database system, you need oracle, db2, sql server, maybe postgres and with mysql you have to fight against things like read locks

(which is a design decision for the database engine, so it’s unfair to mention that, admitted)
most typical mysql applications from the LAMP area just use the database as simplified storage
without the need for relational logic

Q. What is RAC?

RAC is a pretty oracle-uniqe feature
several database systems accessing one database
i’m not against mysql, don’t get me wrong
i use it, too
but there where it belongs to
in the low power area where dataloss isn’t a catastrophic problem
i checked the logs for one of our most important databases. the service itself (it’s a RAC) was available for 100% during the last 4 years
RAC is a pretty oracle-uniqe feature

Q. What more?
well, there are many features. personally i like RMAN and datapump. it’s not “god”
it’s… oracle. the average oracle tool is crap, but the core product (database) is great
but as always: everything depends on the situation and the needs

well, for a bigger company there are only a few choices on the market
plus postgres/enterprisedb, depending on the project
but mysql in a company with important data.. uhmmmmmaybe not.

Q. Whats your experience in oracle?
for the capacity and stuff: i definitely don’t run the biggest database in world, but my biggest machine operates oracle with about 100G database memory and a 40 terabyte ASM diskgroup. it’s not an everyday system, but such things are no phantasy
(the datafiles just take 10 tera for the moment, so the DB is 10T only)
i wouldn’t even think about using anything else than Oracle or DB2 for that
alone the fact that a MySQL would operate on top of a filesystem of such a size… uh

Other staff to attack oracle/mysql server for study:

devcon: to find windows interface ids
http://www.wlanbook.com/enable-disable-wireless-card-command-line/
Backtrack 4 (linux and ) wifi tools: aircrack/airdump
http://wirelessdefence.org/Contents/Aircrack-ng_WinAircrack.htm

Categories: MySQL, Oracle Tags: