Try shutting down the service using the services GUI, especially the tns and agent services, then remove the snmp.ro and snmp.rw in the ORACLE_HOMEnetworkadmin directory, then restart the services. Make sure the entries in the tnsnames file are proper and any entries in the listener.ora as well.
Dig deeper on Oracle database design and architecture
Related Q&A from Mike Ault, Senior Oracle Consultant, Burleson Consulting
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists.continue reading
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to...continue reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.