 |
My name is Coskan Gundogar. I am 29 years old and living in UK. I have been a DBA since 2002. After 3 years of experience on MS SQL 2000 RDBMS, I got bored from the environment which wasn’t giving the real administration power to me, so I changed my career path to work on Oracle RDBMS. I am really happy to work with and discover Oracle. Oracle satisfies me enough for feeling of administration. On this blog I am trying to share the clues, tricks I learned about Oracle during my daily DBA routine. I will be much satisfied , If these blogs ease your life.I think I will never say that I know ORACLE because there is always something to learn about ORACLE.If you think that ,there is something wrong with any blog entry, feel free to warn me with you comments.I try not to put anything that I can’t prove with code, but there is always possibility of an opposite resulted way which could elude from my observation.Feel free contact me from my e-mail. Thanks for visiting |
||
 |
 |
 |
 |
About Me
20 Comments »
RSS feed for comments on this post. TrackBack URI
Nice blog!Here i have a question.when i connected as sysdba i used oracle/oracle(user,pwd) n created a tablr named “dept”.I went to OEM and opend oracle db.but the table was not there.I shutdown the db(oracle).I again connected as sysdba n created table “dept’ using oracle/oracle.This time a db named “arif” was opend and i can see the dept table in the schema.so my question is when i am connected as sysdba where it connects….which db?what happens?
Comment by Anannya — July 27, 2007 @ 5:36 am
Thanks for you comments anannya.
The answer of you question depends on the ORACLE_SID environment variable. IF there are more than one database instance then maybe you have created on another instance.
sqlplus / as sysdba
command will connect to the database whose name is written in the ORACLE_SID environment value. If you want to see ORACLE_SID value you shoul write
echo $ORACLE_SID in Unix
echo %ORACLE_SID% in windows environments
Comment by coskan — July 27, 2007 @ 10:43 am
Merhaba Coskan, kiz arkadasimin ablasinin calistigi sirkette acemi teknisyen olarak basladim. 2 aylik 10g ocp egitiminden sonra ( icerden torpilli oldugum icin
) direk junior olarak ise aldilar. calistigim yerdeki elemanlar cok tecrubeli, bir tanesi 1988 den beri bu isi yapiyor. bense toplasan kursla beraber 4 aylik bilgiyle basladim, ama elemanlar cok iyi hem ogretiyolar hemde acele etme diyolar.
Calistigim yer Londrada, burda (simdiye kadar kavradigim kadariyla) musterilerin gunduz ve aksam check leri yapiliyor. musterilerin bazilari grid control ile check ediliyor. bazilari RAC sistemine sahip, vb.
simdi benim sormak istedigim:
ben 10g ocp kursuna gittim, bu kursta administration I ve administration II ogrendik. Database control ogrendik ama..
Grid Control yada RAC uzerinde dahi durmadik. simdi ben burda teknisyenlere sorular soruyorum, yeni oldugum icin sorularim basit oluyor. Elemanlarda bana bu gibi konularin ustunde durma diyorlar. simdilik Daily Checks ve ilerdede Grid Control ve RAC ogrenecekmisim.. yani kursta ogrendigim yok ‘tablespace yaratma’ yok ‘drop table’ filan hikaye oldu.
bu normalmi?
ben burdaki elemanlara sordum, nerden basliyayim ogrenmeye diye (daily check lerin yaninda). bana baslangic icin; database kur, recovery (catalog) database kur rman i ogren dediler.
sen ne tavsiye edersin?
tesekkurler
Comment by evrim — August 3, 2007 @ 3:48 pm
Selam Evrim
Acık konusmak gerekirse veritabanı yoneticiligi daha onceden otomatize ettigin islerin izlenmesidir. yani kimse sana drop table create tablespace yaptirmaz surekli. yeri gelince yapilan islerdir asıl veritabanı yoneticiligi sistemin yedeginin dogru duzgun alinması ve o yedegin dogru duzgun donulebilmesinden emin olabilmek ve sistemin performansıdır. performans herseyden onemlidir. zamanla ogreneceksin. tavsiyem kursun ustune bir de consepts kitabını okumandır sana cok sey katacaktır.
RAC grid kontrol konularında ise kursta gormemen normal onlar baska bir kursun konusudur. bu konular da ogrenmenin ustune tecrube etmekle pekismesi gereken konulardır. yavas yavas ogreneceksin. ben 3. seneme giriyorum ve oracle benim icin hala okunması ogrenilmesi gereken zilyon adet seyden ibaret. ogrenirsin ogrendigini belleginin bir yerine kazırsın ve en cok ihtiyac anında cat diye ben bunu biliyorum okumustum dersin. DBA lik boyle bisi kod yazmaya falan benzemez. bildiklerini iyi hatırla metalinkte nasıl arama yapabilecegini ogren tahiti.oracle.com giris sayfan olsun consept de kutsal kitabin. gerisi gelecektir
basarılar diliyorum
Comment by coskan — August 6, 2007 @ 7:12 am
Coskan tavsiyelerin icin tesekkurler. Burdaki teknisyen arkadaslarda ayni tavsiyelerde bulunmuslardi. Senin soylediklerinle beraber daha iyi anlamis oldum. Tesekkurler.
Biz kursu Sybex in Oracle 10g Administrator I ve Oracle 10g Administrator II kitaplarinda takip ettik. ilk kitabi bitirdim ve 1Z0-042 sinavini gectim. fakat ikinci kitaba baslamadim henuz.
tahiti.oracle.com adresine birazdan bakiyorum. RAC Gid Control olayini simdilik rafa kaldirdim, metalink, performance, recovery ve checking sheduled tasks uzerinde durucam.
fakat Concept kitabindan neyi kastettigini anlamadim. kisaca aciklayabilirmisin, tam isim verebilirmisin.
Tesekkurler
Evrim
Comment by evrim — August 6, 2007 @ 9:16 am
Concepts her oracle releasinin big picture i gibi dusunulebilecek bir kitap. calistigin sisteme hakim olmak icin o sistemin neler yapabilecegini ogrenmenin en iyi yolu concepts kitabı.
10gr2 icin
http://www.oracle.com/pls/db102/to_toc?pathname=server.102%2Fb14220%2Ftoc.htm&remark=portal+%28Getting+Started%29
10gr1 icin
http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10743%2Ftoc.htm&remark=portal+%28Getting+Started%29
daha onceki versiyonlar icin de tahiti.oracle.com dan bakabilirsin. sahsi kanım Oracle uzerine yazılmıs en iyi kitaplar once concepts kitapları sonrada tum oracle online dokumantasyonudur. daha baska kaynaga ilk asamada ihtiyacın yok. onunde zilyon adet sayfa var okuman gereken benim de dha okuyamadıgım. sana tavsiye olarak
Thomas Kyte in kitabından asagidaki okuma yolunu önerebilirim.
Required Reading for Both Developers and DBAs
For both groups, to be read with each and every new release, we have:
■ Concepts Guide
■ New Features Guide
Required Reading for Developers
For developers, continue your reading with:
■ Application Developers Guide (Fundamentals)
■ PL/SQL Users Guide and Reference
■ Performance Tuning Guide and Reference (Designing and Tuning for Performance
Guide in 8i and earlier)
As noted earlier, developers should be sure to read the first half of the Performance Tuning
Guide and Reference, and look over the other sections at your leisure. As a prequel to this guide
in Oracle9i and later, consider looking at the Performance Method (9i Release 1) or Performance
Planning (9i Release 2) reference. This guide, weighing in at a very light 60 pages, describes the
topics you need to understand in order to be successful, such as scalability, system architecture,
application design principles, and so on.
Required Reading for DBAs
After the Concepts Guide and New Features Guide, DBAs should continue with:
■ Backup and Recovery Concepts
■ Recovery Manager Reference
■ Backup and Recovery Concepts (No, this isn’t a typo. Yes, I put it in here twice. It really
is that crucial. It is the one thing you are not allowed to get wrong. It is also the thing
that DBAs get wrong the most. Just read it and understand it. You won’t regret it.)
■ Administrators Guide
■ Performance Tuning Guide and Reference (with special attention to the second half)
Comment by coskan — August 6, 2007 @ 10:17 am
Thanks for sharing with us. I have been used oracle for over than 5 years. But my roles as just developer not DBA.
I hope can learn a lot from you.
Comment by Lowongan — January 15, 2008 @ 10:07 am
I hope this blog helps you for your needs. Thank you for the feedback
Comment by coskan — January 16, 2008 @ 5:46 pm
I love your blog Coskan. Very helpful and very entertaining!
I have been involved with Oracle since 1990 (version 2).
Currently I am working full time in the Washington DC area as an Oracle Consultant/DB Engineer.
I have a question not really technically related:
If you had your choice between an Oracle DBA related job that paid a good salary and good benefits with a potential to last indefinitely, even between contracts/assignments, and another job which would pay almost 43% more money but limited benefits and may only last 1 to 2 years, which one would you take? There is a potenial I may go perm on the 1-2 year assignment with the prime contractor and end up in a similar position I am in now if my performance is deemed very good.
Other factors are involved as the higher paying job will be much more demanding and stressful as opposed to working in an almost stress free Oracle DBA environment if you can believe that.
I may need to make a decision on this very soon and wanted to get the pros and cons of professional high paying consulting (1099/C2C) work versus less paying salaried full-time with benefits/paid vacation/holidays,etc. work.
I have done both for over 18 years but now I may return to the higher-paying 1099/W2 hourly work once again.
Thanks ahead of time for any feedback provided from your audience and thank you!
PS:
London is great isn’t it?
Comment by bigjoe — March 26, 2008 @ 1:13 pm
hi Joe
Thank you for your comments about the blog. After I finish my honeymoon, I promise I will start to write again
I dont have an exact answer for your question, I just can hope not to be in your position.
Listen nobody but your heart and brain together. Go for a job at which you wont sing “I can get no satisfaction”
London is excellent. It is not Europe not Asia not Australia not Africa not America. It is all
Comment by coskan — March 27, 2008 @ 9:06 pm
Thanks for the reply Coskan. Enjoy your honeymoon! Stay another month or two if you can. Life is short and we should enjoy it at any opportunity.
As far as my job, your advice is actually very good. So with that and my own pondering in mind, I am leaving my current job to pursue one that will be both a lot more challenging and mentally stimulating as well as paying a lot more money which takes care of the “Look After You and Your Own First” philosophy.
I hope to visit London again soon and hopefully see the rest of Europe.
Peace!
Bigjoe
Comment by bigjoe — March 28, 2008 @ 1:13 pm
iyi günler istanbulda oracle kurslarından tavsiye edebileceğiniz bir kurs var mı?İtü bilgisayar m. son sınıf öğrencisiyim.
Comment by hasan — April 6, 2008 @ 11:56 am
Slm Coskan,
Ben Amerika’da yasiyorum. Trde iken Oracle Forms ve Reports ile calismisligim oldu yaklasik 5 yil. Sonra buraya tasindim, dil, cevre falan derken meslekten koptum. Su anda Oracle 10g OCA ve OCP kursuna gidiyorum. Database ile create table harici bir islemim olmadi gecmiste
Ogrendigim hersey cok yeni benim icin. Yakinda bende OCA sinavina girecegim. Evren ile ayni kitaptan egitim aliyorum. Hem size merhaba demek istedim, hemde Evren’in sinava girdigini okudum, kendisinden sinav hakkinda bilgi almak isterim. Iletisim bilgileri eger sizde varsa, bu mesajimi kendisine ulastirabilirmisiniz?
Sevgiler,
Cigdem
Comment by Cigdem — May 20, 2008 @ 12:38 am
Hi, I’am students from Gadjah Mada University (http://www.ugm.ac.id) in Indonesia.
I really happy , coz your blog is very useful for me. My Dream is, wanna be an Oracle DBA, like you
. and next agustus may be i’ll take the exam.
Last but not least, Nice to know you.
you can give comment on my blog , in english.
http://tiftazani.wordpress.com
Comment by mrti — July 27, 2008 @ 5:35 pm
[...] OCA nanti (Amiin), gw gak akan pernah puas (dalam hal belajar tentunya), karena -mengutip dari Mr.Coscan, Seorang DBA asal Inggris- there’s always something to learn about ORACLE, ya karena ada saja [...]
Pingback by Sebuah pelajaran berharga buat gw… « .:: The Mrti’s Blog ::. — July 30, 2008 @ 8:27 am
Hi
I am webmaster of a few personal websites. While looking for more related sites, I came across “http://coskan.wordpress.com”. I found your site very pleasing and would love to purchase text-links to my sites on it.
Please do come back on this with your views.
Awaiting your response,
James
Comment by james — September 16, 2008 @ 9:09 am
thanks for the link on – How to find value of bind variables used by SQLs
It really helped me today ..
Comment by sachin — November 17, 2008 @ 6:20 am
I do not know about Oracle but I loved your hairstyle <3 “)))
Basarilarin devamini da dileriz adamim “)
Barb.
Comment by Barb "Chuck Base" — May 9, 2009 @ 10:33 am
Hi Coskan,
Thanks a lot for your script to view hidden parameters. I really appreciate your attitude.
Comment by Magesh — August 11, 2009 @ 1:38 pm
Hey Coskan,
i just wanted to show you another nice project i made and blogged about in my blog:
It is a project which stores database connection strings in an openLDAP (or any other ldap server) to be used by oracle client for database name resolution.
http://blog.ronnyegner-consulting.de/2009/09/30/storing-oracle-database-connection-strings-in-openldap-instead-of-oid/
Yours Ronny
Comment by Ronny Egner — November 4, 2009 @ 9:35 am