Problems with new installation

From: Sam Fredland <samfredland_at_yahoo.com>
Date: Mon, 27 Dec 1999 19:07:15 GMT
Message-ID: <DNO94.20097$ds3.205041@news1.alsv1.occa.home.com>

Hi,

I have installed Oracle 8i on a Solaris 2.7 Sparc Ultra 60. This is my first installation of Oracle (except personal Oracle 7) and I'm having some problems.

Particularly getting into the database with SQL*Plus. I named my ORACLE_SID user and my database user. I tried logging in and got some errors. Here is a transcript:

corp1sun% echo $ORACLE_HOME
/OraHome
corp1sun% echo $ORACLE_SID
user

Here is where I tried sqlplus:

corp1sun% sqlplus -s sys/manager
ERROR:ORA-01033: ORACLE initialization or shutdown in progress

ERROR:ORA-01017: invalid username/password; logon denied

ERROR:ORA-01017: invalid username/password; logon denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

So there are two problems: I don't have the correct user name and password and the ORA 1033. Does anyone know the default username and passwords for SYS, SYSTEM or any other important users? I haven't changed them since the intallation.

In regards to ORA 1033, here is what was running:

corp1sun% ps -ef | grep -i ora
oracle 1875 1874 0 09:55:43 pts/6 0:00 (dns helper) oracle 1625 1 0 09:22:17 ? 0:00 /OraHome/bin/tnslsnr LISTENER -inherit

oracle  1692     1  0 09:27:37 ?        0:00 ora_dbw0_user  oracle  1696
1  0 09:27:38 ?        0:00 ora_ckpt_user
oracle  1694     1  0 09:27:37 ?        0:00 ora_lgwr_user  oracle  1690
1  0 09:27:37 ?        0:00 ora_pmon_user
oracle  1698     1  0 09:27:38 ?        0:00 ora_smon_user
oracle  1700     1  0 09:27:38 ?        0:00 ora_reco_user
oracle  1702     1  0 09:27:38 ?        0:00 ora_s000_user
oracle  1704     1  0 09:27:38 ?        0:00 ora_d000_user  oracle  1808

369 0 09:38:06 pts/4 0:00 -csh
oracle 1854 1846 0 09:47:26 pts/6 0:00 -csh oracle 1888 1887 0 10:04:46 pts/7 0:00 sh -i oracle 1897 1888 0 10:05:29 pts/7 0:00 grep -i ora

Any ideas?

-Sam Fredland Received on Mon Dec 27 1999 - 13:07:15 CST