connect infa_training/infa_training@pdborcl as sysdba

没有配置成功,虽然创建了用户,但是无法连接db

次のコマンドの開始中にエラーが発生しました : 行 20 -   connect ... エラー・レポート - 接続に失敗しました   USER          = infa_training   URL           = jdbc:oracle:thin:@(DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATEDL)      (SERVICE_NAME = pdborcl)    )  )   エラー・メッセージ = ORA-01017: invalid username/password; logon denied Commit  

 

需要进行如下两步配置修改

C:\app\ora\product\12.1.0\dbhome_1\NETWORK\ADMIN

tnsnames.ora

pdborcl =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )     (CONNECT_DATA =       (SERVER = DEDICATEDL)       (SERVICE_NAME = pdborcl)     )   )

C:\app\ora\product\12.1.0\dbhome_1\NETWORK\ADMIN

listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = pdborcl)       (ORACLE_HOME = C:\app\ora\product\12.1.0\dbhome_1)       (PROGRAM = extproc)       (ENVS = "EXTPROC_DLLS=ONLY:C:\app\ora\product\12.1.0\dbhome_1\bin\oraclr12.dll")     )   )

 

修改后重启orcle服务

重启后,数据库默认进入cdb,需要更改为pdb.

show con_name

CON_NAME  ------------------------------ CDB$ROOT

 alter session set container=PDBORCL;

Sessionが変更されました。

 select con_id, dbid, guid, name , open_mode from v$pdbs;

3    2465088550    A1BAF80879C948C68D8EE0D78DC989BB    PDBORCL    MOUNTED

alter pluggable database PDBORCL open;

Pluggable database PDBORCLが変更されました。

 

connect infa_training/infa_training@pdborcl as sysdba

配置后连接