Can't connect as SYSTEM user

From: Andrew Sammut <sammut_at_dstc.qut.edu.au>
Date: Thu, 27 Oct 94 07:00:55 GMT
Message-ID: <1994Oct27.070055.22127_at_news.qut.edu.au>


I have just installed the Oracle 7.0.16(server only) on a DEC Alpha 3000/500S running OSF/1 2.0.

After following the instructions on the Installation and Configuration Manual, I find I am not allowed to login as the Oracle SYSTEM user. And I am definitely using the correct password.

The ORACLE_SID environment variable has been set to what I entered in the installation process. The value of ORACLE_SID is LNX.

The following is a copy of a session:

---start

oracle(-su)# sqldba lmode=y

SQL*DBA: Release 7.0.16.6.1 - Production on Thu Oct 27 16:21:24 1994

Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.

ORACLE7 Server Release 7.0.16.6.1 - Production

SQLDBA> connect system/
Password:
ORA-01017: invalid username/password; logon denied

SQLDBA>
---end

If I don't have the ORACLE_SID environment variable set, the following happens:

---start

oracle(-su)# sqldba lmode=y

SQL*DBA: Release 7.0.16.6.1 - Production on Thu Oct 27 16:52:02 1994

Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.

ORACLE7 Server Release 7.0.16.6.1 - Production

SQLDBA> connect system/
Password:
ORA-01034: ORACLE not available
ORA-07200: slsid: oracle_sid not set.
SQLDBA>
---end

Has someone encountered the problem where the SYSTEM user cannot log in? If so, could you please e-mail me any useful tip that you might know?

I have a feeling it has something to do with the /etc/tnsnames.ora file, but I have no idea what one is supposed to look like. I don't have access to the SQL*Net Admin manual, which I am told contains the information about this file.

Waiting in anticipation(anticipation is half the fun!)

Thanks,
Andrew Sammut Received on Thu Oct 27 1994 - 08:00:55 CET

Original text of this message