Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Contacts

You Can Directly Message to Me:

Name
Email *
Message*

Availability 24/7:
Please avoid chatting. It is better to contact me on Gmail at any time.

Present Location:
QL2 (India) Gurgaon

Basic Location:
Jamia Nagar, Okhla
New Delhi  (India) 110025

Permanent Location:
Vill+Po.- Balasath
Dist - Sitamarhi
Bihar  (India)
Link: More About Balasath

33 comments:

  1. hey Assalamalikum...

    i am from india, hyderabad
    i am serching for oracle dba job i have done ORACLE certified professional certification ...

    plzzzz help he out

    ReplyDelete
    Replies
    1. Walekum Salam,

      I already uploaded different job site link or direct HR email id in my blog. Try to upload your resume there or send directly to the company HR.

      Thanks
      Shahid Ahmed

      Delete
  2. Assalamalikum Shahid Vhai,
    This is Sarowar Morshed From Bangladesh. I can not run developer Suit2 10g Report from any Form.
    Last 7 days i am trying to convert all of my project in Suite 10g but faild.
    Please send me step by step suite 10g conflagration.

    Thanks
    soheail@gmail.com

    ReplyDelete
    Replies
    1. Dear,

      You did not clearly written which OS, you are using to install Developer suite. If you want to install 10g Database and Developer suite on Windows 2007 then try to follow my post: "Install Oracle developer suite 10g on windows 7" also check the discussion of this post to solve your issues.

      Delete
  3. Dear shahid ahmed

    i read all the tutorial nice and well . in this tutorial both new and experience update the knowledge through this http://shahiddba.blogspot.in.

    in may one think iam using Sql Developer tools developing in my office . already i see performance tuning are in only Toad tool .Kindly,i want to you provide the sql developer way of examples.


    thanks and Regards
    sankar

    ReplyDelete
    Replies
    1. Dear,

      Nice to hear that you regularly reading my blog. As you know it is very difficult to focus on every aspect at a time (specially same things with different tools) but in future i can try to upload some of the topics.
      Hope you can understand!

      Thanks
      Shahid Ahmed

      Delete
  4. Hi Shahid,

    How to find out os level locks,if locks held at os level what happens and how resolve this issue?

    ReplyDelete
  5. Dear Shahid,

    I followed your blog regularly. It is very nice and helpful to somany DBA's.

    My question is

    How to get the list of patches applied to database if lsinventory corrupted?

    Great thankful if you provide the answer

    Regards
    kiran kumar

    ReplyDelete
  6. Salam
    Bhai i m from pakistan lahore. i have learned my 2 exams of oca but i dont have necessary hands on practice.
    how should i become more and more expert in SQL and ADMIN 1-2. database is new for me. how should i prepare for exams as
    well.
    kindly suggest
    Ahmed

    ReplyDelete
  7. hallo sir,

    i want to install oracle 11g on rhel 5.....when i install it some of packages are not find....so plz send me whole procedure to install
    oracle 11g on rhel and link of required packages...below is my mail address.
    singh.pawan624@gmail.com

    pawan singh
    dba

    ReplyDelete
    Replies
    1. Dear Pawan,

      I am sorry to say that i don't have step by step document for the same. Try to search or install. If you have any issue mail me the error so that i can suggest if any...

      Thanks
      Shahid Ahmed

      Delete
  8. sir if i competently format my c drive (cress of system ) , and i want to up my database that can existing on these system so how it possible , and no backup available

    ReplyDelete
    Replies
    1. Why this non-sense!. If you already loose all of your oracle binaries then you need to install oracle binaries and then after
      restore the oracle database.

      Delete
  9. how increse performance of my query if my system is same for clint or server in oracle 10g

    ReplyDelete
    Replies
    1. Dear,

      I already uploaded too many article on performance tuning. Please use the search option on blog.

      Delete
  10. assalamulaikum shahid bhai,

    i read all the tutorial nice and well, you are doing good job may allah give you more success thanx.

    ReplyDelete
    Replies
    1. Walekum Salam,

      Thanks for your appreciation!

      Delete
  11. hello sir,this is my first visit to your blog it is impressive and knowledgable ,i am MCA2012 passedout and have been trying for job as java developer but i did not get any so i decided to change to oracleDba so please give some suggestions how should i get knowledge on oracleDba and what are practising methods to get complete knowledge and how are the oppertunities for dbs now please help me

    ReplyDelete
    Replies
    1. Dear Naveen,

      In every field initially you have to struggle but already if you have decided to change ‎your track as a DBA then I will suggest you try to take training as a DBA and possible do ‎the certification.‎
      For your knowledge I would like to suggest you. Try to practice the entire concept one by ‎one.‎
      ‎–‎ Table space or data files storage maintenance.‎
      ‎–‎ Different Backup and Recovery Scenario.‎
      ‎–‎ Database Maintenance.‎
      ‎–‎ Standby database
      ‎–‎ Tablespace Management.‎

      Delete
  12. Assalamualykum Shahid

    I tried to mail u my doubts but it keep on saying enter the valid mail address even though i gave my E-mail Id correctly. i tried giving both official and gmail Ids but nothing is working.. can u say how to get my queries to you. i am giving my gmail ID below if possible can u drop a mail to me so that i can reply to that with the doubts that i am having

    Thanks in advance
    sansnaseer@gmail.com

    ReplyDelete
  13. Hi Shahid,

    Do you offer Oracle DBA training? Kindly message me @ schhabria80@gmail.com

    ReplyDelete
  14. Assalam o alikum

    let's consider a scenario where I commited the data and and it has not been written to the datafiles,and instance crashes. Now in instance recovery how will oracle recover the data from redo entries.

    Thanks in advance.

    ReplyDelete
  15. Dear sir,

    I saw that your website is for college students and I was wondering whether you could add our link (http://neuvoo.co.in/en) to your site so that it is useful to the students and visitors. You can take a look at the site and know how we can be a value addition to your visitors.

    ReplyDelete
  16. hi your site is really useful and you are doing great job really appreciatebeing DBA i can understand . i am farhan i work in kuwait and i am ocp 10g so need to upgrade my ocp certification. i searched many sites to get 1z0-060 dumps .do you have the mentioned dumps and send me soft copy or suggest me somthing

    ReplyDelete
  17. Hello sir..

    Awsome info;;

    Sandip
    Pune

    ReplyDelete
  18. mohammadnaved1@gmail.com

    Dear Sir,
    I am a MCA and I am recently working at Railway I.t. Centre (Maintenance of Oracle Database) I found your blog very useful i am preparing from it and Sir I heartly want to do the job in gulf. My financial condition is soo low i hardly managing my day to day expenses. Please help me sir. Khuda Hafiz.

    ReplyDelete
  19. Hello Shahid, Sir,

    I need your help, I had made one Oracle home Data base fro Demo instance , this is working fine with listner .ora file, now i had made a same mount point created a Development Database with new oracle home. Now the problem is coming i am not able to connect SQL plus with Development data base ... i had update tnsname.ora and listner.ora file... when i tnsping CSDEV it give me this error TNS-12541: TNS:no listener Please help Sir . I am a new in Oracle.

    ReplyDelete
  20. [oracle@CVM-1429 ~]$ sqlplus sys/sys as sysdba

    SQL*Plus: Release 12.1.0.2.0 Production on Sat Oct 8 18:11:55 2016

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


    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

    SQL> select name from v$database;

    NAME
    ---------
    CSMEC

    SQL>
    [oracle@CVM-1429 ~]$ ps -ef|grep pmon
    oracle 1286 1 0 Oct07 ? 00:00:10 ora_pmon_CSDEV
    oracle 17032 1 0 Sep27 ? 00:01:40 ora_pmon_CSMEC
    oracle 30817 30328 0 18:12 pts/2 00:00:00 grep pmon
    [oracle@CVM-1429 ~]$
    [oracle@CVM-1429 admin]$ pwd
    /u03/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin
    [oracle@CVM-1429 admin]$ more listener.ora
    LISTENER=
    (DESCRIPTION=
    (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=tcp)(HOST=10.56.184.32)(PORT=1525))
    (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
    ))
    SID_LIST_LISTENER=
    (SID_LIST=
    (SID_DESC=
    (GLOBAL_DBNAME=CSMEC)
    (ORACLE_HOME=/u03/oracle/app/oracle/product/12.1.0/dbhome_1/)
    (SID_NAME=CSMEC))
    ))


    LISTENER1=
    (DESCRIPTION=
    (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=tcp)(HOST=10.56.184.32)(PORT=1530))
    (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
    ))
    SID_LIST_LISTENER=
    (SID_LIST=
    (SID_DESC=
    (GLOBAL_DBNAME=CSMEC)
    (ORACLE_HOME=/u03/ORCDEV/oracle/app/oracle/product/12.1.0/dbhome_1/)
    (SID_NAME=CSDEV))
    ))

    [oracle@CVM-1429 admin]$

    [oracle@CVM-1429 admin]$ more tnsnames.ora
    # tnsnames.ora Network Configuration File: /u03/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    CSMEC =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.56.184.32)(PORT = 1525))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = CSMEC)
    )
    )



    CSDEV =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.56.184.32)(PORT = 1530))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = CSDEV)
    )
    )

    [oracle@CVM-1429 admin]$
    [oracle@CVM-1429 admin]$ tnsping CSDEV

    TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 08-OCT-2016 18:20:18

    Copyright (c) 1997, 2014, Oracle. All rights reserved.

    Used parameter files:


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.56.184.32)(PORT = 1530)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CSDEV)))
    TNS-12541: TNS:no listener
    [oracle@CVM-1429 admin]$

    ReplyDelete
  21. Hello, Good Morning, Can you please share golden gate documents which will help to understand the GG. Thank you.

    ReplyDelete
  22. Hi Sir,

    As i am facing a problem in my environment Oracle 9i, increasing of
    PgSp value abnormally while monitoring through TOPAS command.
    --------------------------------------------------
    Name PID CPU% PgSp Owner
    oracle 1187868 5.9 551.0 oracle
    --------------------------------------------------
    Also the out figured query from this particular PID is having SELECT type query.

    But as of now we have to kill related PID to get rid from situation.

    What we should process next steps for better solution.
    Looking for your valuable revert to help please.


    Thanks,
    Shailesh

    ReplyDelete
  23. hie Sir.

    what is the practically difference between physical and logical backup.

    thanks.

    ReplyDelete
  24. Hi Shahid,

    I am searching Oracle dba job in Gulf. Please let me know what is the right way to search job.

    currently I am working with IBM India Pvt Ltd. on Bharti Airtel africa Project since 5 years.


    Thanks
    ===========

    Sagar Bhambay
    +91 8860000618
    sbhambay29@gmail.com

    ReplyDelete
  25. I want to migrate the oracle forms and reports 6i to 11g, please guide me what should I do???????????

    ReplyDelete