[newbie] 10g: add new user: could not log in [message #212098] |
Wed, 03 January 2007 16:24 |
brwarn
Messages: 4 Registered: January 2007
|
Junior Member |
|
|
I'm brand new to Oracle. I have 10g loaded onto a Windows XP box. I added a new user via the Enterprise Manager by following the steps in the 'Oracle Database 2 Day DBA' guide starting on p. 7-9. I cannot log in at all through the Enterprise Manager or through SQL*Plus.
Would someone please let me know which (log) files I should check to determine why I can't log in or point me to troubleshooting guides which might assist me in sorting out the cause of this problem?
Thanks!
brian
|
|
|
|
Re: [newbie] 10g: add new user: could not log in [message #212343 is a reply to message #212098] |
Thu, 04 January 2007 17:34 |
brwarn
Messages: 4 Registered: January 2007
|
Junior Member |
|
|
the error is ORA-01017: "invalid username/password; logon denied". The error is the same whether I use the Enterprise Manager or SQL*Plus. For completeness, here's what I did:
1. Logged into Oracle EM as 'sys' in the orcl database instance.
2. Created a 20GB tablespace that the user will use. The tablespace has the following properties:
Bigfile tablespace No
Status ReadWrite
Type Permanent
Extent Management local
Storage
Allocation Type Automatic
Segment Space Management Automatic
Enable logging Yes
Block Size (B) 8192
3. Created the user with:
default profile
password authentication
the tablespace I created above is the default tablespace
TEMP is the temporary tablespace
selected 'CREATE SESSION' from the available system priveleges list in the system privileges section
4. Saved and attempted log in with the previous log in errors.
|
|
|
|
Re: [newbie] 10g: add new user: could not log in [message #212506 is a reply to message #212343] |
Fri, 05 January 2007 10:47 |
brwarn
Messages: 4 Registered: January 2007
|
Junior Member |
|
|
You're exactly right regarding #s 1&2. It is for precisely these reasons that I looked for this type of Oracle newbie site. Until I'm able to sit through an Oracle fundamentals course (I hope to do so sometime this month), I have to struggle 'til then to figure out how to do the most basic operations.
Here's all I can do in SQL*Plus right now. I can't log in as SYSTEM as all and SYS requires me to qualify (not sure that's the right term) the login as a SYSDBA or SYSOPS (haven't been able to figure out how to do that from the command line.
C:\Documents and Settings>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 5 08:41:50 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: saffron
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: sys
Enter password:
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Thanks.
|
|
|
|
|
Re: [newbie] 10g: add new user: could not log in [message #212552 is a reply to message #212527] |
Fri, 05 January 2007 16:36 |
brwarn
Messages: 4 Registered: January 2007
|
Junior Member |
|
|
Yes, I would much prefer a friendlier Solaris or Linux environment, but I'm stuck fighting MS. system as dba works just fine now:
C:\oracle\product\10.2.0\db_1\BIN>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 5 14:26:00 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system as sysdba
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
Thanks!
-brian
|
|
|
|