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...
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?
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.