| User and Password error (merged 3) [message #644500] |
Sun, 08 November 2015 09:19  |
|
|
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
[mod-edit: image inserted into message body by bb]
-
Attachment: oracle1.jpg
(Size: 117.27KB, Downloaded 3136 times)
[Updated on: Tue, 26 January 2016 21:39] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: User and Password error [message #644508 is a reply to message #644504] |
Sun, 08 November 2015 10:06  |
|
|
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 #644513 is a reply to message #644507] |
Sun, 08 November 2015 12:13 |
John Watson
Messages: 8962
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; |
|
|
|
| Re: User and Password error [message #644518 is a reply to message #644508] |
Sun, 08 November 2015 23:49 |
Lalit Kumar B
Messages: 3174
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
