Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dbtoo2001

    3 databases - but only 1 can connect to rman

    Have you resolved this? Can you login to sqlplus as sysdba? Since it's only the network connected servers, it may be that a GPO was applied which changed what the oracle dba group administrators have been granted.
  2. dbtoo2001

    Motivate Yourself as DBA

    I would suggest the following: automate the list that you gave of normal routine, email yourself the results (if you don't do that already.) if your company doesn't have a 'play machine', insist on one, and start practicing - standby databases, scenarios for failures, rman, etc. join OTN...
  3. dbtoo2001

    sqlplus: not found.

    Typically (even when spelled correctly) you don't include the bin in the home... ORALCE_HOME=/appl/oracle/10.1.0/bin; export ORACLE_HOME should be ORACLE_HOME=/appl/oracle/10.1.0; export ORACLE_HOME
  4. dbtoo2001

    RMAN Restore of Hot Backup

    http://forums.oracle.com/forums/thread.jspa?messageID=2262928&#2262928
  5. dbtoo2001

    Measure changes for disaster recovery.

    Read through http://www.oracle.com/pls/db92/db92.show_toc?partno=a96653&remark=drilldown&word=dataguard . It will explain what is necessary.
  6. dbtoo2001

    Deinstall Spatial (MDSYS)

    Metalink Note:179472.1
  7. dbtoo2001

    [b]Best Way To Delete By Date?[/b]

    Of course I'm familiar with Tom's montra. He also offers great advice on many things, including bulk collect: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3561337894959 (sorry, don't have access to tiny url from work.) It wasn't 'my' proscribed solution, as it was a...
  8. dbtoo2001

    [b]Best Way To Delete By Date?[/b]

    ? http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls.htm#35883
  9. dbtoo2001

    [b]Best Way To Delete By Date?[/b]

    Consider bulk collect: http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls.htm#28415
  10. dbtoo2001

    How to export an old oracle database?

    http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/osbackup.htm#1366
  11. dbtoo2001

    Accessing Oracle DB Over Internet

    http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_environments.htm#sthref47
  12. dbtoo2001

    completely re-moving oracle from windows

    http://www.mydigitallife.info/2005/12/13/manual-and-clean-uninstall-oracle-for-windows/ Found this from google
  13. dbtoo2001

    Help with Oracle 10g

    You haven't been paying attention in class, have you? http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch3.htm#sthref712 http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements008.htm#sthref722 http://ORA-00955.ora-code.com/ Crystal ball says you need to...
  14. dbtoo2001

    FAQ on "how to post" required?

    Since I've got Santa rolling on the floor laughing, here's a couple more: Parasiting I'm in a position I said I could do But haven't experience to back what I knew So I post in the forum - my defacto mentor Brain dump your knowledge to this genus stentor I need it right now, it's an URGENT...
  15. dbtoo2001

    Using only archivelogs for recovery?

    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen003.htm#BRADV224 I've never tried it. Let us know how you make out, and what the steps were that you did. Thanks. Good luck.
  16. dbtoo2001

    FAQ on "how to post" required?

    Newbies I'm Under the gun to get things done so let me just ask a guru. They've worked more years than I've been alive, no need for me... to even give it a try. I'll just post my assignment, kick back and wait, for them to reply, with an answer that's great. I'll take the credit as...
  17. dbtoo2001

    how to use a full export to move a database

    Here is info on import (impdb - can't be used when exp created the dump file.) http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2292 http://download.oracle.com/docs/cd/B19306_01/win.102/b14304/create.htm#sthref188
  18. dbtoo2001

    Does group by or distinct force a sort?

    Ask BOB - http://www.forumtopics.com/busobj/index.php I beleive the LOV can be sorted in the universe.
  19. dbtoo2001

    Odd server activity

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/technique.htm#sthref229 http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/autostat.htm#PFGRF02606
  20. dbtoo2001

    ORA-01092 ORA-30012

    Let us know how it went.

Part and Inventory Search

Back
Top