Home » RDBMS Server » Server Administration » how connect with 12c
how connect with 12c [message #654044] Tue, 26 July 2016 05:48 Go to next message
mfahimaamirgmailcom
Messages: 50
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 Go to previous messageGo to next message
John Watson
Messages: 7624
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 #654046 is a reply to message #654044] Tue, 26 July 2016 05:59 Go to previous messageGo to next message
John Watson
Messages: 7624
Registered: January 2010
Location: Global Village
Senior Member
And, in future, please use [code] tags when you copy/paste. Described here, How to use [code] tags and make your code easier to read
Re: how connect with 12c [message #654050 is a reply to message #654045] Tue, 26 July 2016 06:59 Go to previous messageGo to next message
EdStevens
Messages: 985
Registered: September 2013
Senior Member
John Watson wrote on Tue, 26 July 2016 05:58
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.


Slight correction:

"or use the tnsnames.ora entry that specifies service name."

If the tnsnames.ora entry specified sid instead of service name, it would just be repeating the same error. Smile
Re: how connect with 12c [message #654083 is a reply to message #654045] Wed, 27 July 2016 00:59 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 50
Registered: May 2011
Location: pakistan
Member
Thank you for your reply.
Dear this is my
tnsnames.ora file how I start pluggable container. Also I am sending detail file.

# tnsnames.ora Network Configuration File: D:\app\OracleHomeUser1\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

PDBORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdborcl)
    )
  )
  • Attachment: detail.png
    (Size: 382.25KB, Downloaded 155 times)
Re: how connect with 12c [message #654086 is a reply to message #654083] Wed, 27 July 2016 01:08 Go to previous messageGo to next message
John Watson
Messages: 7624
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
err ORA-01033 [message #654113 is a reply to message #654050] Wed, 27 July 2016 03:03 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 50
Registered: May 2011
Location: pakistan
Member
dear i use hr schema in sql developer by this command
alter pluggable database pdborcl open
alter session set container = pdborcl;

but next day i try to connect
I got the ORA-01033 Oracle initialization or shutdown in progress error. What did I do wrong ? and what can I do to fix it ?? Thank you for the help.


how auto open my database
please help me
regard
Re: err ORA-01033 [message #654707 is a reply to message #654113] Wed, 10 August 2016 14:33 Go to previous message
Bill B
Messages: 1805
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

Previous Topic: unable to see dba_audit_trail
Next Topic: user access problem
Goto Forum:
  


Current Time: Tue Oct 23 23:43:22 CDT 2018