Hi newbie, thanks for writing this:
> I installed Oracle 8i
>
> The database I created was called test1
>
> It gave this during install
> ----------------------
>
> global datbase name : test1
> database SID : test1
> internal account password: oracle
> SYS account password : change_on_install
> SYSTEM account password : manager
>
> I went to SQL Plus & tried to launch it.
> No combination of username / passwords as suggested by Oracle
> above worked. I get the error
>
> (I am not sure what to install at HOSTSTRING. I assume it is the
> hostname I tried blank as well)
>
> EROOR:
> ORA-01034:ORACLE not available
>
- Open a DOS window
- Type the following sqlplus commands:
c:\> set ORACLE_SID=test1
c:\> sqlplus /nolog
sql> connect / as sysdba
sql> startup
...[displays sga and other stuff; continue when db 'open' displayed]...
sql> exit
--
[:%s/Karsten Farrell/Oracle DBA/g]
Received on Thu Jul 31 2003 - 16:09:19 CDT
