Re: Oracle newbie

database_at_freemail.gr (db_happy) wrote:

>Hello
>
>I install Oracle8 Enterprise Edition Release 8.0.4 for Windows NT and
>I choose Typical in Starter Database.As I understand ORACLE create a
>sample database for me (If that is wrong please inform me).Also the
>installation create some services.Probably my starter database is
>OracleServiceORCL and OracleStartORCL which they running.Also running
>OracleTNSListener80 and OracleWebAssistant.
>
>Then i try to connect with Oracle Enterprise Manager with username
>internal and password oracle (i found this information in the
>Internet).In the left upper pane none of the choices show me nothing.
>
>How can i show my database in Oracle Enterprise Manager?
>Can this done via SQL (I am interested more in connection howto no in
>common SQL queries - but a full example it is OK for me)
To have any choices in Enterprise Manager, you need to load the tnsnames.ora entries. Read the help files and the docs to find out how. Oracle is not a product that is easy to just 'pick up by doing' and without doing some serious reading, you will only frustrate yourself..Also, why on earth are you using such an outdated version of Oracle? Go to
http://tahiti.oracle.com
read the Concepts and Server Administration docs, at a minimum.. If it asks you to register ( it is actually part of Technet at http://otn.oracle.com) do so..It is free and you will find Technet to be one of the best Oracle sites around..( That is also where you can get the latest Oracle versions for Downloading)

The 2 'default' ids for administration work are sys/change_on_install - ( it means you should change it once you log in the first time) system/manager ( change this one to)

You may also have scott/tiger Received on Wed Jul 16 2003 - 08:58:51 CDT