New install of 10g

[William F. O'Neill]

I have just upgraded my Oracle db from 9i to 10g. Of course, the
installation did not go straightforward. Does 10g use a TNSNAMES.ora & a
LISTNER.ORA FILE. If so, where should they be placed in the new directory
tree of Oracle10? Also, when I had 9i, I called EM with the following:
C:\oracle\ora90\bin\oemapp.bat console. How do I call EM with Oracle 10g?

[Pedro Lopes]

The listener.ora and tnsnames.ora still in ORACLE_HOME/network/admin/
....
The EM in 10g is web based... go to a shell
and type:

emctl status dbconsole

you can try to start it typing

emctl start dbconsole

you can check in the ORACLE_HOME directoty for a folder named
<hostname>_<sid>
if you dont't see any folder.. try to run DBCA to configure the EM (web
based). Most of the features moved here. Some still in the Java Console
(spatial, replication and a few more), but for this you'll need to
install it from the companion CD.

hope it helps

pedro

William F. O'Neill wrote:

I have just upgraded my Oracle db from 9i to 10g. Of course, the
installation did not go straightforward. Does 10g use a TNSNAMES.ora & a
LISTNER.ORA FILE. If so, where should they be placed in the new directory
tree of Oracle10? Also, when I had 9i, I called EM with the following:
C:\oracle\ora90\bin\oemapp.bat console. How do I call EM with Oracle 10g?

[William F. O'Neill]

Thanks Pedro. I'll give it a try. Would you believe with all the
documentation that Oracle gives you, I couldn't find this info. Maybe,
they(Oracle) feels you should just automatically know this!!!

"Pedro Lopes" <pe*********@netvisao.pt> wrote in message
news:ne********************@newsfront4.netvisao.pt ...

The listener.ora and tnsnames.ora still in ORACLE_HOME/network/admin/
...
The EM in 10g is web based... go to a shell
and type:

emctl status dbconsole

you can try to start it typing

emctl start dbconsole

you can check in the ORACLE_HOME directoty for a folder named
<hostname>_<sid>
if you dont't see any folder.. try to run DBCA to configure the EM (web
based). Most of the features moved here. Some still in the Java Console
(spatial, replication and a few more), but for this you'll need to install
it from the companion CD.

hope it helps

pedro

William F. O'Neill wrote:

I have just upgraded my Oracle db from 9i to 10g. Of course, the
installation did not go straightforward. Does 10g use a TNSNAMES.ora & a
LISTNER.ORA FILE. If so, where should they be placed in the new
directory tree of Oracle10? Also, when I had 9i, I called EM with the
following: C:\oracle\ora90\bin\oemapp.bat console. How do I call EM with
Oracle 10g?