how connect with 12c [message #654044] |
Tue, 26 July 2016 05:48 |
|
mfahimaamirgmailcom
Messages: 64 Registered: May 2011 Location: pakistan
|
Member |
|
|
Sir,
I install 12c as per oracle instruction Installing Oracle Database 12c on Windows and alter hr account as per instruction
sqlplus sys/Oracle_1@pdborcl as sysdba;
alter user hr identified by hr account unlock;
connect hr/hr@pdborcl
select count(*) from employees;
these work right but when I open sql Developer and connect with
user id hr and password hr / hostname Localhost/ port 1521 and SID orcl
that not connect and give me error
Failure : test failed ORA-01017 : invalid username / password; login deined
Please help me
Regard
|
|
|
Re: how connect with 12c [message #654045 is a reply to message #654044] |
Tue, 26 July 2016 05:58 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You have created a multitenant database, and your HR schema is in a pluggable container. You can't connect to a pluggable container by specifying ORACLE_SID, that will connect you to the root container. You need to specify the service name of the pluggable container, or use the tnsnames.ora entry.
|
|
|
|
|
|
Re: how connect with 12c [message #654086 is a reply to message #654083] |
Wed, 27 July 2016 01:08 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:And, in future, please use [code] tags when you copy/paste.
Is this a new question -
Quote:how I start pluggable container
If so, you can connect to the root container and use ALTER PLUGGABLE DATABASE OPEN or to the pluggable container AS SYSDBA and issue a STARTUP command.
This is very basic database admin. Have you read the introductory giude yet? Here it is, http://docs.oracle.com/database/121/ADMQS/toc.htm
|
|
|
|
Re: err ORA-01033 [message #654707 is a reply to message #654113] |
Wed, 10 August 2016 14:33 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
One solution in 12C is to NOT make it plug able when you build the database. You are not required to and unless you are running multiple databases in the container there is zero need to do so. Doing that will cause it to act just like every other database before version 12.
[Updated on: Wed, 10 August 2016 14:34] Report message to a moderator
|
|
|