Home » RDBMS Server » Server Administration » Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 (Oracle Database 12c 12.2.0.1.0)
Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 [message #686003] Tue, 24 May 2022 04:08 Go to next message
shamsad.khan@gmail.com
Messages: 12
Registered: October 2016
Junior Member
Hi

I have installed oracle database 12.2.0.1.0. as container database with orclpdb as my pluggabe database

Logged in sqlplus as connect sys as sysdba

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON=FALSE SCOPE=BOTH;

create user c##test identified by test;

grant dba to c##test;

*Tried to connect c##test/test@orcl, got error message*

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE


Again logged in through sqlplus and did the below job

alter session set container=orclpdb;

alter pluggable database orclpdb open;

alter pluggable database orclpdb save state;

create user scott identified by tiger;

grant dba to scott;

Tried to connect scott/tiger@orcl, got error message*;

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

*My listener.ora*

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = c:\app\shamsad\product\12.2.0\dbhome_1)

(PROGRAM = extproc)

(ENVS = "EXTPROC_DLLS=ONLY:c:\app\shamsad\product\12.2.0\dbhome_1\bin\oraclr12.dll")

)

)


LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)



tnsnames.ora

LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(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 = 192.168.1.105)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)


*lsnrctl status are ok*

*tnsping orcl is also ok*


*Please guide me why i am not able to login*
Re: Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 [message #686004 is a reply to message #686003] Tue, 24 May 2022 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

orcl <> orclpdb

Re: Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 [message #686006 is a reply to message #686004] Tue, 24 May 2022 09:25 Go to previous messageGo to next message
shamsad.khan@gmail.com
Messages: 12
Registered: October 2016
Junior Member
I didnt get orcl <> orclpdb. Could you explain

Thanks
Re: Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 [message #686012 is a reply to message #686006] Tue, 24 May 2022 12:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You created SCOTT in oraclpdb:

Quote:
alter session set container=orclpdb;
create user scott identified by tiger;

You tried to connect to "orcl":

Quote:
connect scott/tiger@orcl
Quote:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

SCOTT is not known in "orcl", so the error.

Re: Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 [message #686013 is a reply to message #686012] Tue, 24 May 2022 12:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Note:

Quote:
grant dba to scott;

This is a very bad idea.
DBA should not be granted to any user.

Re: Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 [message #686015 is a reply to message #686013] Tue, 24 May 2022 13:11 Go to previous messageGo to next message
shamsad.khan@gmail.com
Messages: 12
Registered: October 2016
Junior Member
Thank you very much

I am testing this installation on my personal laptop, so granted DBA.
Anyhow appreciate for your advise.
Re: Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 [message #686016 is a reply to message #686015] Tue, 24 May 2022 13:57 Go to previous messageGo to next message
shamsad.khan@gmail.com
Messages: 12
Registered: October 2016
Junior Member
How do i connect to user c##test created in the root container.

Please advise
Re: Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 [message #686020 is a reply to message #686016] Wed, 25 May 2022 08:23 Go to previous message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Read Database Security Guide
Section 3.2.6.1 SEC_CASE_SENSITIVE_LOGON Parameter and Password Case Sensitivity

Note that, for obvious security reasons, it is not wise to set SEC_CASE_SENSITIVE_LOGON to FALSE.

[Updated on: Wed, 25 May 2022 08:25]

Report message to a moderator

Previous Topic: Dropping database link
Next Topic: Unable to connect Forms 6i and Oracle 12c 12.2.0.1.0
Goto Forum:
  


Current Time: Sun Aug 14 10:09:03 CDT 2022