Oracle-L: Cannot connect in SQLplus

From: Thomas Wang <thomasw_at_CRSS.ESY.COM>
Date: Mon, 4 Mar 1996 15:49:51 -0600
Message-Id: <9603042208.AA21201@alice.jcc.com>

Hi there,

Is anyone out there may help and give me any idea about the problem as addressed folowing ?

We have installed and initialized Oracle 7.2.3 on SQI/IRIX 5.3 and databases was created thru CDROM installation process.

Later on, I've added users on it (as shown in the following).

However, the system will not let me connect to database via sqlplus, though it can be connected in sqldba environment.

Why not sqlplus ?

And erroring me out as :

SQL*Plus: Release 3.2.3.0.0 - Production on Mon Mar 4 13:33:46 1996

Enter user-name: TEST
Enter password:
ERROR: ORA-07268: szguns: getpwuid error.

Why ? Am I missed something ? As a Sybase DBA and 5 years experience with Oracle version 6, I belived I've done it right already. But ...

Will someone help me out ? Thanks in advance for your help.

sincerely,

Thomas
E-System,
Dallas, TX

Following are what I've done for adding user "test" on the system ...

SQLDBA > connect internal;
Connected.
SQLDBA >create user test identified by test123; Statement processed.
SQLDBA >grant connect, resource to test; Statement processed.
SQLDBA > alter user test default tablespace USER_TS1 temporary tablespace temp; Statement processed.
SQLDBA> select * from dba_users;

USERNAME                       USER_ID    PASSWORD
                      DEFAULT


------------------------------ ---------- ------------------------------


-------


_TABLESPACE             TEMPORARY_TABLESPACE           CREATED   PROFILE


----------------------- ------------------------------ ---------

SYS                                     0 8A8F025737A9097A               SYSTEM
                        TEMP                           28-FEB-96 DEFAULT

SYSTEM                                  5 2D594E86F93B17A1               TOOLS
                        TEMP                           28-FEB-96 DEFAULT

NAMES                                   8 9B95D28A979CC5C4               SYSTEM
                        SYSTEM                         28-FEB-96 DEFAULT

TEST                                   13 7C029A1EC393C725
              USER_TS
1                       TEMP                           04-MAR-96 DEFAULT

4 rows selected.

SQLDBA> connect test/test123;SQLDBA> exit SQL*DBA complete.

% sqlplus test/test123

SQL*Plus: Release 3.2.3.0.0 - Production on Mon Mar 4 14:17:13 1996

ERROR: ORA-07268: szguns: getpwuid error.

Enter user-name: test
Enter password:
ERROR: ORA-07268: szguns: getpwuid error. Received on Mon Mar 04 1996 - 17:08:26 CST