ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
Service "tstora" has 1 instance(s).
Instance "tstora", status READY, has 1 handler(s) for this service...
This is dynamic instance registration. Based on the listener.ora file you aren't doing this. The listener should be started before the database is started in this situation, otherwise it can take some time for the database to register with the listener or it may not register.Service "tstora" has 2 instance(s).
Instance "tstora", status UNKNOWN, has 1 handler(s) for this service...
Instance "tstora", status READY, has 1 handler(s) for this service...
This is static instance registration but the listener was running before the database started. Then UNKNOWN status is the static registartion. The READY is because it seems to do both dynamic and static if the listener is up before the database.Service "tstora" has 1 instance(s).
Instance "tstora", status UNKNOWN, has 1 handler(s) for this service...
This is static instance registration but the listener was down when the database started. The UNKNOWN status is from static registration and documented that way in the link provided previously. Based on the information posted in this thread so far, I believe this is the scenario you have.ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
A few questions to jump start things. :)
1 - What version of Oracle have you installed?
2 - Are you using the Oracle client (on the "desktop") or something else?
3 - If the Oracle Client, what is the version of the Oracle client?
4 - What is the result of running TNSPING against the new database?