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

    Oracle TNS Listner problem on Internet

    Directly connected to the internet?? I'm connecting via sqlnet using Oracle clients software to connect to the server. Obviously I travel over the internet to get to the server which sits behind a firewall. I have installed the known patches for buffer overflow. I cannot use a VPN, the current...
  2. greekgirl

    SQL Conn through SEF7

    I'm trying to connect to an oracle database through the standard port 1521 and receive TNS errors that the operation timed out. Is there anything particular that needs to be done to the firewall configuration to allow sqlnet traffic through port 1521 and point to a specific database?
  3. greekgirl

    Oracle TNS Listner problem on Internet

    Can you please explain how this was fixed. I am having the same TNS operation timed out errors.
  4. greekgirl

    script a whole database

    Thank you all for clarifing that I only needed to create the controlfile with the changes. Also, the control files (.ctl) should not be copied when changing the database name and issuing the create controlfile script. Since I was on the same machine and needed a new sid, I did not need to copy...
  5. greekgirl

    script a whole database

    Thanks so much for the info. Part of my problem is that the duplicate database is on the SAME machine. I did a ALTER DATABASE BACKUP CONTROLFILE TO TRACE and edited this file to create the controlfile for my new database. Would I do the following step BEFORE OR AFTER I create the controlfile...
  6. greekgirl

    script a whole database

    I tried this, because I need to clone my database, too. I get to step 6: 6. Use SQL*Plus to connect to an idle instance as follows sqlplus "/ as sysdba" Connected to an idle instance. And this is where I get errors. ORA-12560 TNS:protocol adapter error. Should the entry for the...
  7. greekgirl

    Improving performance of query by inlining function into SQL

    Try using a sub query to make it one query. SELECT PLATE_NAME, DATE_SYNTHESIS_BEGAN, CHEMIST, AVERAGE_PLATE_MASS, BATCH_NUMBER, EVERANALYSED, FROM SYNTHESIS_PLATES SP, ( select sc.synthesis_plate_id, count(sc.SYNTHESIS_PLATE_ID) EVERANALYSED from synthesised_compounds sc, anal_plates_compounds...

Part and Inventory Search

Back
Top