Could you try also connect using OS authentication and change sys password
using alter user...
ср, 12 февр. 2020 г., 17:41 Jeffrey Beckstrom <jbeckstrom@xxxxxxxxx>:
xxxxxxxx:/oracle/db/12_2_0_1/dbs:] $ ls -al orapwnewcdb
-rw-r-----. 1 oradmin oinstall 11264 Feb 12 09:37 orapwnewcdb
xxxxxxx:/oracle/db/12_2_0_1/dbs:] $
And show please file permissions for your pwfile. ls -laSayan Malakshinov <xt.and.r@xxxxxxxxx> 2/12/20 9:35 AM >>>
ср, 12 февр. 2020 г., 17:33 Sayan Malakshinov <xt.and.r@xxxxxxxxx>:
Hi,
Have you tried to set authentication_services=(none) in sqlnet.ora?
ср, 12 февр. 2020 г., 17:28 Jeffrey Beckstrom <jbeckstrom@xxxxxxxxx>:
I am trying to connect to the cdb not the pdb.
connect sys/xxxx@newcdb as sysdba - fails
connect system/xxxxx@newcdb - works
Jeff,Chris Taylor <christopherdtaylor1994@xxxxxxxxx> 2/12/20 9:21 AM >>>
What is the service_name registered with the listener for the PDB, and
does it match the service_name you're providing on the command line:
sqlplus sys/xxxx@newcdb as sysdba (is "newcdb" the service_name
registered with the listener for the PDB?)
Chris
On Wed, Feb 12, 2020 at 8:42 AM Jeffrey Beckstrom <jbeckstrom@xxxxxxxxx>
wrote:
I am trying to do a TNS connection as sys to the CDB and that's when I------------------------------
get the invalid username/password error. If I try a TNS connection as
system to the CDB it works so TNS is correct.
Hello Jeff.angelo <angelolistas@xxxxxxxxx> 2/12/20 8:33 AM >>>
If you try to connect onto your cdb using sys as sysdba, before.
and next, change your session from cdb to container. e.g.
SQL> alter session set container=newpdb;
SQL> show con_id;
Does it work ?
what about services_name from pdb? In TNS, must be different from cdb.
below, my db tnsnames for example.
CDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
xxxdb01.lanocpsp.allspoc.oraclevcn.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CDB01_gru196.lanocpsp.allspoc.oraclevcn.com)
)
)
PDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
xxxdb01.lanocpsp.allspoc.oraclevcn.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb01.lanocpsp.allspoc.oraclevcn.com)
)
)
On Wed, 12 Feb 2020 at 09:51, Jeffrey Beckstrom <jbeckstrom@xxxxxxxxx>
wrote:
We have had non-container databases until now. We just built a------------------------------
container and added a PDB to it. We can connect to the container as user
"system" as well as a user to the PDB via TNS. However, if we try connect
sys/xxxxxx@newcdb as sysdba, we get an invalid username/password
error. If we try the same connection on the server after setting
oracle_sid
and not using tns, then it works. However, if we add the TNS string, it
then fails. We have created a password file and remote_login_passwordfile
is set to exclusive. We have followed our same steps as we would for
setting this up for an non-CDB database. We are at a loss as to what is
wrong. Any help would be appreciated.
Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
This email has been scanned for spam and viruses. Click here
<https://attseg.cloud-protect.net/index01.php?mod_id=11&mod_option=logitem&mail_id=1581514403-I0hHpL_vQOl2&r_address=jbeckstrom%40gcrta.org&report=1>
to report this email as spam.
This email has been scanned for spam and viruses. Click here
<https://attseg.cloud-protect.net/index01.php?mod_id=11&mod_option=logitem&mail_id=1581517284-i5rj7HAk6gz8&r_address=jbeckstrom%40gcrta.org&report=1>
to report this email as spam.
------------------------------
This email has been scanned for spam and viruses. Click here
<https://attseg.cloud-protect.net/index01.php?mod_id=11&mod_option=logitem&mail_id=1581518140-025vOXKdWIif&r_address=jbeckstrom%40gcrta.org&report=1>
to report this email as spam.
