Home » SQL & PL/SQL » Client Tools » User and Password error (merged 3) (Oracle Database 12c)
User and Password error (merged 3) [message #644500] Sun, 08 November 2015 09:19 Go to next message
venus_shinny
Messages: 5
Registered: November 2015
Location: South Korea
Junior Member

Hello all!

I am new learner for Oracle. I installed Oracle database 12c several times. But before starting my first query, I can not initiate the ORACLE SQL DEVELOPER. I always fail to enter User and Password for ORACLE SQL DEVELOPER.

Please help me how this user and passwords come from. And what is this user name and passwords for?

Thanks
/forum/fa/12903/0/


[mod-edit: image inserted into message body by bb]
  • Attachment: oracle1.jpg
    (Size: 117.27KB, Downloaded 149 times)

[Updated on: Tue, 26 January 2016 21:39] by Moderator

Report message to a moderator

Re: User and Password error (merged 3) [message #644503 is a reply to message #644500] Sun, 08 November 2015 09:35 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Open a DOS box, check ORACLE_HOME is correct and PATH contains %ORACLE_HOME%\BIN, and execute:
lsnrctl services


Please read How to use [code] tags and make your code easier to read.

Re: User and Password error [message #644504 is a reply to message #644500] Sun, 08 November 2015 09:37 Go to previous messageGo to next message
BlackSwan
Messages: 25797
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

I am going to assume that you installed Oracle DB on some flavor of Windows.
What is OS name, version & edition?

Open Command Window & do as below

lsnrctl startup
lsnrctl status
sqlplus / as sysdba
startup
alter user scott identified by 'tiger' account unlock;
connect scott/tiger

COPY the results from above then PASTE all back here.

Re: User and Password error [message #644506 is a reply to message #644504] Sun, 08 November 2015 10:01 Go to previous messageGo to next message
venus_shinny
Messages: 5
Registered: November 2015
Location: South Korea
Junior Member

/forum/fa/12907/0//forum/fa/12906/0/



Thank you very much for the replay and welcoming.

Yes I installed Oracle DB on Windows7 Professional ,64bit OS(SP1).

Please see the attached file.

Thanks


  • Attachment: oracle3.jpg
    (Size: 91.05KB, Downloaded 235 times)
Re: User and Password error [message #644507 is a reply to message #644504] Sun, 08 November 2015 10:01 Go to previous messageGo to next message
venus_shinny
Messages: 5
Registered: November 2015
Location: South Korea
Junior Member

/forum/fa/12908/0/
  • Attachment: oracle2.jpg
    (Size: 205.29KB, Downloaded 231 times)
Re: User and Password error [message #644508 is a reply to message #644504] Sun, 08 November 2015 10:06 Go to previous messageGo to next message
venus_shinny
Messages: 5
Registered: November 2015
Location: South Korea
Junior Member

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\flipflop>lsnrctl startup

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 09-NOV-2015 01:04
:12

Copyright (c) 1991, 2014, Oracle. All rights reserved.

NL-00853: undefined command "startup". Try "help"

C:\Users\flipflop>lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 09-NOV-2015 01:04
:21

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Produ
ction
Start Date 08-NOV-2015 21:28:28
Uptime 0 days 3 hr. 35 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\oracle\product\12.1.0\db_1\network\admin\listen
er.ora
Listener Log File C:\app\oracle\diag\tnslsnr\flipflop-PC\listener\alert\
log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=flipflop-PC)(PORT=5500))(Security=(
my_wallet_directory=C:\APP\ORACLE\admin\orcl\xdb_wallet))(Presentation=HTTP)(Ses
sion=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "pdborcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Users\flipflop>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 9 01:04:35 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> alter user scott identified by 'tiger' account unlock;
alter user scott identified by 'tiger' account unlock
*
ERROR at line 1:
ORA-00988: missing or invalid password(s)


SQL> connect scott/tiger
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL>
Re: User and Password error [message #644509 is a reply to message #644507] Sun, 08 November 2015 10:08 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The first command is "lsnrctl start" not "startup".
Anyway your listener is started.
Your service name is "orcl" not "xe", modify your connection input.

[Updated on: Sun, 08 November 2015 10:08]

Report message to a moderator

Re: User and Password error [message #644510 is a reply to message #644508] Sun, 08 November 2015 10:09 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
alter user scott identified by 'tiger' account unlock;


Password should enclosed between DOUBLE quotes not simple ones or, in this case, not enclosed at all.

And once more, Please read How to use [code] tags and make your code easier to read.

[Updated on: Sun, 08 November 2015 10:10]

Report message to a moderator

Re: User and Password error [message #644511 is a reply to message #644509] Sun, 08 November 2015 10:16 Go to previous messageGo to next message
venus_shinny
Messages: 5
Registered: November 2015
Location: South Korea
Junior Member

Thanks

How can I modify my my input from xe to orcl?

Thanks
Re: User and Password error [message #644512 is a reply to message #644511] Sun, 08 November 2015 11:28 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Use your mouse to click in the SID field and your fingers to type "orcl" (without the quotes) on your keyboard to fill the field.

Re: User and Password error [message #644513 is a reply to message #644507] Sun, 08 November 2015 12:13 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
Venus, I suspect that you have made things complicated for yourself by created a multitenant container database, rather than a simple non-container database. To prove this:
sqlplus / as sysdba
select cdb from v$database;
select name,open_mode from v$containers;
and I think you will see that you have three containers: cdb$root, pdb$seed, and pdborcl. This is a complication that you really do not need. It might be nest to drop this database, and create a new non-container database.
Re: User and Password error [message #644518 is a reply to message #644508] Sun, 08 November 2015 23:49 Go to previous message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
venus_shinny wrote on Sun, 08 November 2015 21:36

Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "pdborcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully


The listener service is up and running. You have created a container database with a single pluggable database, i.e. a single-tenant deployment. CDB - orcl and PDB - pdborcl

Quote:

C:\Users\flipflop>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 9 01:04:35 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions


you are connecting locally using the combination of ORACLE_HOME and ORACLE_SID environment variables. In 12c, that would by default connect you to the CDB not the PDB.

Quote:

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first


This is not required, you database is already started.

Quote:

SQL> alter user scott identified by 'tiger' account unlock;
alter user scott identified by 'tiger' account unlock
*
ERROR at line 1:
ORA-00988: missing or invalid password(s)


1. As already pointed by Michel, no need to use single-quotation marks around the password.
2. You are trying to unlock user SCOTT in CDB, while the sample schemas reside in the PDB.

Quote:

SQL> connect scott/tiger
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL>


As I said, you need to first connect to the PDB which you have named as pdborcl, and then unlock SCOTT and connect it by providing the correct SERVICE_NAME.

For example,

SQL*Plus: Release 12.1.0.1.0 Production on Mon Nov 9 11:15:25 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Last Successful login time: Mon Nov 09 2015 10:45:51 +05:30

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> conn scott/tiger@pdborcl
Connected.
SQL>


Also, there are few post-installation steps you need to complete manually, have a look at Oracle 12c Post Installation Mandatory Steps




Regards,
Lalit
Previous Topic: Tools for auditing database for finding plain text credit card numbers.
Next Topic: Could not resolve service name
Goto Forum:
  


Current Time: Sat Jan 20 14:18:40 CST 2018

Total time taken to generate the page: 0.07847 seconds