Database Express login as pluggable container [message #621494] |
Wed, 13 August 2014 14:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/ce008b01bc45715902bdb653d88e8049?s=64&d=mm&r=g) |
oragami
Messages: 16 Registered: July 2014
|
Junior Member |
|
|
HI- I am using 12c and cannot connect a user who is under a pluggable dbase container in Database Express. I get an login denied; invalid username/password Error~
User is created properly as when I I can connect in sql plus and Sql Dev as client and I can do selects, etc.
The port default 5501 works for sysdba admin when I https in.
I tried to login in as sysdba & alter my session to the pluggable db.
Then I checked the httpport with a select and it returned null. So i adjusted my init.ora file for listener and dispatcher accordingly to
point to the correct tcp port and restarted OS.
Then when I checked the httpport under the pdb session container as sysdba still no port. Okay so I try an exec command to get set a port to 5501 and voila!!! this happens
error at line 1:
ora-44718 Port conflict in XDB config file!!!
when I connect as CBD$ROOT and alter session I get the httpport listed at 5501 when I check the used port from dual
listener.ora is set up for two listeners as local port - 1521 and an additional port under computer name as 5501
Router is set up to port forward everything
please help!!!!!!!!!!!!!!!!!!!
they make this soooooo complicated... So much time wasted to set things up that should take a minute...mysql where are u???
Thanks!!!
[Updated on: Wed, 13 August 2014 14:50] Report message to a moderator
|
|
|
|
|
|
|
Re: Database Express login as pluggable container [message #621525 is a reply to message #621494] |
Thu, 14 August 2014 01:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:HI- I am using 12c and cannot connect a user who is under a pluggable dbase container in Database Express. I get an login denied; invalid username/password Error~ From the docs:
Quote:Note:
PDB management with EM Express is available starting with Oracle Database 12c Release 1 (12.1.0.2). and Quote:A different HTTPS port must be configured for each CDB and PDB that you want to manage using EM Express.
Are you using the latet patchset, 12.1.0.2?
[Updated on: Thu, 14 August 2014 01:07] Report message to a moderator
|
|
|
|
|
|
|
Re: Database Express login as pluggable container [message #621537 is a reply to message #621535] |
Thu, 14 August 2014 01:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
If I understand correctly, you are not specifying the correct PDB name while making the connection.
Ok let's do it this way, if you have a user already in PDB, try this connection as an example, user, DB and password you need to replace :
sqlplus scott@pdborcl/tiger
In my case, i am on enterprise edition and I unlocked scott and following is the tns entry :
PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl.in.oracle.com)
)
)
|
|
|
Re: Database Express login as pluggable container [message #621539 is a reply to message #621512] |
Thu, 14 August 2014 01:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
oragami wrote on Thu, 14 August 2014 04:28i just hope that then IF i get things working i can allow differing users to utilize the simplicity of the express system over web to connect to same dbase but each have a dedicated login and therefore
table schemas & content. I just noticed the above sentence. You do not need to usable pluggable containers at all for this. You need a simple non-container database. Have you even bought the Multitenant option? You can of course use multitenant-single occupancy for free, but that is little advanced for a beginner. And you don't need it.
|
|
|
Re: Database Express login as pluggable container [message #621603 is a reply to message #621531] |
Thu, 14 August 2014 14:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/ce008b01bc45715902bdb653d88e8049?s=64&d=mm&r=g) |
oragami
Messages: 16 Registered: July 2014
|
Junior Member |
|
|
Ok John, I reinstalled ORA 12c without PDB and created a user with all privileges and was able to log into EM Express. How can the user execute SQL statements like select, create, etc like in a worksheet mode in EM Express r is that not possible?
Thank you much!
|
|
|