Coskan’s Approach to Oracle

About Me

coskan My name is Coskan Gundogar (It is pronounced as JoshKahn so people call me Josh)  and I’m currently 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
10gocp_logo 11g_ocp_logo linuxocelogo sqlocelogo

43 Comments »

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. I hope this blog helps you for your needs. Thank you for the feedback

    Comment by coskan — January 16, 2008 @ 5:46 pm

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. [...] 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

  16. 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

  17. 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

  18. 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

  19. 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

  20. 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

  21. Hey Coskan,

    Any plans to add a RSS feed for your blog posts?

    Comment by ken — January 6, 2010 @ 2:18 pm

    • Hi Ken,

      Normally readers discovers feeds,
      I can’t remember now but probably thats why I remove them from the navigation bar. I now added them at the bottom of the navigation

      Comment by coskan — January 6, 2010 @ 2:31 pm

  22. Selam Coşkan, ingilteredeki çalışma ortamı ve şartları ile ilgili aklım takılan noktalar var, cevaplayabilirsen gerçekten çok sevindirici olur, yukarıdaki mail adresinden iletişim kurabilirmiyiz.

    teşekkürler.

    Comment by kadir sahan — June 4, 2011 @ 9:06 am

  23. Its not my first time to pay a quick visit this web page, i am visiting this web page
    dailly and take pleasant information from here every day.

    Comment by reclaimedwoodcoffeetables.org — November 12, 2012 @ 7:51 pm

  24. What a data of un-ambiguity and preserveness of precious familiarity concerning unexpected feelings.

    Comment by Sherry N. Groesbeck — January 30, 2013 @ 8:09 pm

  25. Hi would you mind letting me know which webhost you’re working with? I’ve loaded your blog in
    3 different browsers and I must say this blog loads a lot faster then
    most. Can you suggest a good hosting provider at a fair price?
    Kudos, I appreciate it!

    Comment by time travel — February 22, 2013 @ 1:04 am

  26. Thanks designed for sharing such a good thought, piece of writing is nice,
    thats why i have read it completely

    Comment by mobile apps — July 25, 2013 @ 12:50 am

  27. I tend not to leave a ton of remarks, however i
    did a few searching and wound up here About Me | Coskan’s Approach to Oracle. And I do have a couple of questions for you if you do not mind. Is it simply me or does it seem like some of the responses come across as if they are left by brain dead folks? :-P And, if you are writing at additional online sites, I’d like to keep up with
    everything new you have to post. Could you make a list of every one of your public
    sites like your twitter feed, Facebook page or linkedin profile?

    Comment by starting today? TOO EASY for Newbies!! MSM Magic DOWNLOAD — July 30, 2013 @ 5:34 pm

  28. Hi! I’m at work surfing around your blog from my new iphone! Just wanted to say I love reading through your blog and look forward to all your posts! Keep up the great work!

    Comment by libardo-garzon.com — July 30, 2013 @ 5:50 pm

  29. Useful information. Lucky me I discovered your site by
    chance, and I’m shocked why this accident didn’t happened in advance!
    I bookmarked it.

    Comment by league of legends riot points — July 31, 2013 @ 5:44 am

  30. I used to be suggested this website by means of
    my cousin. I’m no longer certain whether or not this put up is written via him as no one else realize such certain about my problem. You are amazing! Thanks!

    Comment by body fat scale — July 31, 2013 @ 12:16 pm

  31. Currently it seems like BlogEngine is the best blogging platform available right now.
    (from what I’ve read) Is that what you are using on your blog?

    Comment by Myles — August 3, 2013 @ 3:31 am

  32. Just stated, each and every human being is diverse.

    Comment by ichtyose.fr — August 5, 2013 @ 7:02 am

  33. Hey There. I found your blog using msn. That is a really neatly written article.
    I will make sure to bookmark it and come back to read more
    of your helpful info. Thank you for the post. I will definitely return.

    Comment by League of Legends Riot Points Generator — August 8, 2013 @ 8:40 am

  34. Useful information. Lucky me I found your web site accidentally, and
    I’m shocked why this coincidence didn’t happened in advance!

    I bookmarked it.

    Comment by oferty towarzyskie — August 13, 2013 @ 12:21 am

  35. Die Abwechslung und Vielfalt auf unserer Plattform wird ganz groß geschrieben.
    me anzumelden und die heißen Frauen anzuflirten,
    mit denen du dich im Bett wiedersehen möchtest.

    me ganz schnell die Liebe online finden und glücklich werden.

    Comment by kostenlose sextreffen — September 5, 2013 @ 11:15 pm

  36. I don’t even know how I ended up here, but I
    thought this post was great. I do not know who you are
    but definitely you’re going to a famous blogger if you are not already ;) Cheers!

    Comment by pirater facebook sans logiciel — September 15, 2013 @ 6:27 pm

  37. The truth is, at times, men do not have enough testosterone.
    The majority of the children supported with Edwards ‘ syndrome seem weak and fragile, and they are often
    of insufficient weight. The System menu also gives you access to more complex information about your
    system.

    Comment by click here animated gifs — September 16, 2013 @ 5:50 am

  38. Thank you for your well-thought content. I’m really at perform proper now! So I ought to go off with no reading through all I’d like. But

    Comment by Ingin Cepat Hamil — September 24, 2013 @ 10:23 pm

  39. Coach Cyber Monday Sale

    Comment by Cyber Monday Michael Kors — November 28, 2013 @ 4:51 am

  40. I visit each day some blogs and sites to read
    posts, however this weblog provides feature based
    content.

    Comment by rp hack — February 24, 2014 @ 9:33 pm

  41. Every weekend i used to go to see this site, for the
    reason that i wish for enjoyment, since this this web site conations in fact good funny stuff too.

    Comment by Francisco — March 15, 2014 @ 2:10 am

  42. Hi there, I desire to subscribe for this weblog to obtain most
    up-to-date updates, so where can i do it please help out.

    Comment by Romona M. Kuras — September 21, 2014 @ 6:47 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Theme: Silver is the New Black. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 203 other followers

%d bloggers like this: