Help for oracle beginner

[themistry]

Hi all,

im getting to grips with Oracle 10g on the windows platform, its quite a
shift from SQL Server.

Online documentation doesn't seem to be the best, nor does anything seem to
follow a natural order (well damm, my MS background finally killing me ).

Alas, I have the product installed but haven't got the faintest idea about
how to manage and or use it. I.e. creating a database, adding user accounts
(do these even exisit or is everything hooked into the OS level?).

Any tips or advice on how to go about create a blanc database with a valid
user account etc would be most helpful. Further, is there anything like SQL
Server Enterprise manager for oracle? I couldnt find anything similar
installed.

Thanks all,
TM

 

[JIMA]

Hi,

It's been a while since I installed Oracle 10g but hopefully this will help - it's what I remember anyway.

In the Start/Oracle menu you'll find a Database Configuration Assistant (or similar). This enables you to create databases in a wizard sort of thing. As far as I remember each database has a service that you assign to a port.

When the database has been created a service will be created for that database, something like OracleDBConsoleDBName. Once this has been started you can log onto the admin for the database by using a browser, giving a URL such as:

http://localhost:xxxx/em

where xxxx is the port of the DB to use. A list of the ports in use is also contained in the ORACLE_HOME/install/ports.ini file . You can log on as sysdba using the password you specified when you installed Oracle. This presents a web-based interface where you can administer your database.

If you look in the documentation you should find a 2 Day DBA course which is worth looking at. Not sure if these were a separate download or not.

Hopefully I haven't left anything vital out there, it's been a while since I had Oracle running.

Jim

 

[themistry]

JIMA,

many thanks for that reply. I will post back if im still stuck!

Thanks,
TM

 

[Haircut]

The DBCA (Database Configuration Assistant) provides a GUI to create databases.

Not sure where it is put for a Windows installation, but it should be around.