How to start Personal Oracle?

[stewstryker]

This may seem dumb to some, but... that's never stopped me before!

I've installed Personal Oracle on my laptop so I can create a test database to mess around with separate from our corporate database.

During the installation process I created a database, but now what???

It looks like it created a tnsnames.ora entry for it and I can see it created the database files, but I can't connect to it via SQL*plus or anything else.

Are there steps I need to do to start the listener or something like that?

Thanks,

Stew

[skalvi]

Depends on what OS you have , If windows it would start the services automatically ( which I like to make manual since dont want it effecting everything else when not using oracle).
You can create a tnsnames files it is under ORACLE_HOME\network\admin\ dir.( It should have been created as part of the listner configration durring install )
If you didnt modify anything durring installation the database sid will be ORCL and you should be able to connect using OS auth. e.g.
sqlplus
/ as sysdba
----------
or
sqlplus system/manager@orcl

H.T.H

[fuzzypig]

If it's personal oracle in Win32, then check the services are up and when you fire up SQLPLUS, use the connect string "2:" with quotes, this should simply connetc to the local DB.

Rgds