Re: help connecting to database

You should be able to login as system/manager or sys/change_on_install.

1. Check to make sure your TNS listener is running: ps -ef |grep tns
2. If it's not running, try to start it login as oracle lsnrctl start
3. If it still does not start, check your tnsnames.ora file, which should be located in $ORACLE_HOME/network/admin

"Peter Choe" <choepete_at_mindspring.com> wrote in message news:3B1E2D4F.485660B2_at_mindspring.com...
> i was able to install Oracle 8i on a freebsd machine. at least i think
> it installed correctly.
>
> but when i tried to use sqlplus to try to connect using scott/tiger i
> get an error saying ORACLE is not available.
>
> how do i make it available? or what id can i use? i run it as oracle
> user, the same user that i installed oracle with.
>
> peter choe
Received on Wed Jun 06 2001 - 14:31:47 CDT