Linux Oracle Terminal Database Start, Enterprise Management Console

//oracle kullanıcı ile sistemi kurduğumuz için
//kullanıcı değiştiriyoruz terminalde.
$ su - oracle

//uzak bağlantı yapılabilsin diye listener çalıştırılacak.
$ lsnrctl start

//Database başlatmak için sqlplus ı sysdba olarak çalıştırıyoruz.
$ sqlplus / as sysdba

//Database çalıştırılacak
SQL> startup

//SQLPLUS tan çıkıyoruz.
SQL>quit

//DB çalıştı şimdi enterprise management console
//çalıştırılacak ki webden işimizi kolayca görelim.
$ emctl start dbconsole

//Enterprise Management Console'a girmek için web adresini ziyaret ediyoruz.
http://oracle1o.oracle.com:1158/em/

TSQL de Inner Join ve Group By birlikte kullanmak

DECLARE @ay AS INT
SET @ay=1
DECLARE @yil AS INT
SET @yil=2008

SELECT h.hasta_id, h.adi+' '+h.soyadi [Adı Soyadı], s.total
FROM hastalar as h
INNER JOIN
(
  SELECT refHasta_id, count(1) AS total
  FROM seanslar AS s
  WHERE s.refKlinik_id=71 AND month(tarihi)=@ay AND year(tarihi)=@yil AND durumu=1
  GROUP BY refHasta_id
) AS s
ON s.refHasta_id=h.hasta_id
ORDER BY h.adi+' '+h.soyadi




hasta_id Adı Soyadı                                total
----------- -------------------                      -----------
25123       ABDULKADİR KARAHAN  13
27420       ABDULKADİR UÇAN             9
24097       ABDULLAH DAKMAN           8
25091       ABDULLAH TUNÇ                 14

Linux Command not found

"/u01/app/oracle/product/10.2.0/db_1/bin/ " dizinindeki tüm çalıştırılabilir dosyalara artık doğrudan erişebileceğiz.

export PATH=$PATH:/u01/app/oracle/product/10.2.0/db_1/bin/ >> ~/.bash_profile

Oracle 10g Administration 1

Oracle Managed Files (OMF)

DB_CREATE_FILE_DEST
Defines the location of the default file system directory for data files and temporary files
DB_CREATE_ONLINE_LOG_DEST_n
Defines the location for redo log files and control file creation
DB_RECOVERY_FILE_DEST
Defines the location for RMAN backups

SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u01/oradata';
SQL> CREATE TABLESPACE tbs_1;

OCP Courses

Oracle Database 10g: Administration Workshop I – A Preview

Oracle Database 10g: Administration Workshop II – A Preview

1. In this class, you will learn
2. how to configure an Oracle database for multilingual applications.
3. You will practice various methods of recovering the database, using

• RMAN,


• SQL,


• and the Flashback technology.

4. Tools to monitor database performance and steps to be taken to improve database performance are also covered in this course.
5. You will also learn how to use various database technologies, such as

• Resource Manager,


• Scheduler,


• and Automatic Storage Management (ASM).

6. The lesson topics are reinforced with structured hands-on practices and a workshop.

Oracle 10g Köprüleri

SWF, EXE
Oracle Demoları: http://www.oracle.com/webcasts/demos/index.html
10g Kurulumu: http://www.oracle.com/broadband/demo/oracle_database_10g_installation.swf