Home » RDBMS Server » Server Administration » [newbie] 10g: add new user: could not log in
[newbie] 10g: add new user: could not log in [message #212098] Wed, 03 January 2007 16:24 Go to next message
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 #212117 is a reply to message #212098] Wed, 03 January 2007 18:15 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you verified that the new user has the CONNECT role? What error are you receiving ?
Re: [newbie] 10g: add new user: could not log in [message #212343 is a reply to message #212098] Thu, 04 January 2007 17:34 Go to previous messageGo to next message
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 #212344 is a reply to message #212098] Thu, 04 January 2007 17:42 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
When hearing about such problems I reach two conclusions.
1) Oracle is accurately reporting reality
2) Cause invariably is PEBKAC.
Use SQL*Plus & show us via cut & paste EXACTLY what you are doing.

[Updated on: Thu, 04 January 2007 18:04] by Moderator

Report message to a moderator

Re: [newbie] 10g: add new user: could not log in [message #212506 is a reply to message #212343] Fri, 05 January 2007 10:47 Go to previous messageGo to next message
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 #212510 is a reply to message #212098] Fri, 05 January 2007 11:10 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
UGH! Windoze!
While logged into/onto Windows as the OS user who installed the Oracle software, invoke SQLPLUS
When prompted with "Enter user-name:" enter
/ as sysdba
& post what happens
Re: [newbie] 10g: add new user: could not log in [message #212527 is a reply to message #212510] Fri, 05 January 2007 12:18 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or even (note double quotes!)

C:\> SQLPLUS "sys/password as sysdba"
Re: [newbie] 10g: add new user: could not log in [message #212552 is a reply to message #212527] Fri, 05 January 2007 16:36 Go to previous messageGo to next message
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
Re: [newbie] 10g: add new user: could not log in [message #212554 is a reply to message #212098] Fri, 05 January 2007 16:39 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
SQL> ALTER USER saffron IDENTIFIED BY ATE2MUCH;
SQL> CONNECT saffron/ATE2MUCH
SQL>
Previous Topic: Issue in v$logmnr_contents
Next Topic: ORA-01552 problem
Goto Forum:
  


Current Time: Sat Dec 03 03:47:39 CST 2016

Total time taken to generate the page: 0.10388 seconds