Re: Oracle9i installation - Oracle Net Services problems

From: Alan <nomorezpam3_at_hotmail.com>
Date: 27 Sep 2004 12:50:56 -0700
Message-ID: <84f54f12.0409271150.564e3c73@posting.google.com>

Wise words - and I think this was the problem. I was using my unix root login to access sqlplus instead of my oracle (orac9i) login in unix.

Having established that as a problem - and [su - orac9i] over to the oracle login - I've been able to login as [/ as sysdba] and then issue a ...

oracle> sqlplus /nolog

SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup

ORACLE instance started

Total System Global Area 324......
..
.
.
.

Database mounted
Database opened
SQL> exit
oracle> ps - ef | grep pmon
orac9i 24325 1 0 19:59:13 ? 0:00 ora_pmon_ORACLE9i orac9i 24325 17275 0 19:59:41 pts/8 0:00 grep pmon

This seems to have got my database running now.

Thanks
Alan Received on Mon Sep 27 2004 - 14:50:56 CDT