创建SCOTT用户

ORACLE 12c 安装后，PDB中默认不包括SCOTT用户，需要手动创建。

1.在tnsname.ora中添加PDB的监听。tnsname的位置是“$ORACLE_HOME/network/admin/tnsnames.ora”

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.


#LISTENER =
#  (DESCRIPTION_LIST =
#    (DESCRIPTION =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.197.133)(PORT = 1521))
#      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
#    )
#  )

ORACS133 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.197.133)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORACS133)
    )
  )

          
ORACS133PDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.197.133)(PORT = 1521))
    (CONNECT_DATA = 
      (SERVER = DEDICATED)
      (SERVICE_NAME =ORACS133PDB1)
    ) 
  )
#LISTENER_ORACS133 =(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.197.133)(PORT = 1521)))
~