oracle客户端下新建 /network/admin 文件路径,然后将D:\app\orcl\product\12.1.0\dbhome_1\NETWORK\ADMIN下的tnsnames.ora文件复制到你新建的路径下。
方法一:
sqlplus sys/dwh as sysdba;
create user c##test identified by test;
alter session set container=PDBORCL;
show con_name;
startup;
create user test identified by test default tablespace users temporary tablespace temp;
grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to test ;
不清楚12C创建用户为什么要加c##
用plsql登录人时候用户名用c##test,否则会报错01017
方法二:
打开plsql,不登录
1、配置OracleHome和OCI Library,打开PLSQL Developer,选择Tools -> perference -> Connection,设置OracleHome=D:\app\orcl\product\12.1.0\instantclient_12_1; OCI Library=D:\app\orcl\product\12.1.0\instantclient_12_1\oci.dll. 参考第一步,你复制进去的路径