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!

Register Log in
  • Congratulations bkrike 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: *

  • Users: did02
  • Content: Threads
  • Order by date
  1. did02

    Remove monitored DB from EM

    Hi all, Has anyone experienced to remove a monitored database from EM ? [sadeyes] What are the main steps (Oracle 10g on W2k3) ? - stop agent, - remove agent - remove $ORACLE_HOME\hostname_sid directory - remove oc4j instance - update $ORACLE_HOME\install\portlist.ini what else (config file...
  2. did02

    Database OS migration

    Hi all, I have to determin the best way to copy a 200 Gb data running on Solaris 8 /Oracle 8.1.7 on a W2K / Oracle 8.1.7 plateform. I'm trying to know the used options on the source config (32/64b, MTS, parallele server) and come back as soon as possible. Any help would be appreciated...
  3. did02

    ALWAYS_SEMI_JOIN & ALWAYS_ANTI_JOIN parameters

    Hello, I'm tuning a database. I used a tool that indicates me to set up these variables in the InitSID.ora ALWAYS_SEMI_JOIN = HASH #default value = NESTEED_LOOPS ALWAYS_ANTI_JOIN = HASH #default value = NESTEED_LOOPS I did it. But now, it seems that many queries run very slow. I take an...
  4. did02

    ORA-12514 : URGENT

    Hi, I have a pb on a database : when I try to acces a distant DB trough a DBlink, I get an error message ORA-12514. * I don't find this message in the Oracle documentation. * A sniffer allowed me to say that the message is sent by the distant DB. * Moreover, all the DBLinks of my database...
  5. did02

    Import into a database in archivelog mode

    Hi, I have to import data from a dump file into a database in archivelog mode. The estimated time for a database in noarchivelog mode is 5 hours. My questions : - are the insert orders (generated by imp tool) loggued into the archive log ? - If yes, I certainly need to set up the database in...

Part and Inventory Search

Back
Top