Aven的专栏

1、打开cmd2、输入 sqlplus /nolog 回车3、输入 conn / as sysdba 回车4、查看用户天数限制SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';5、更改为无限制ALTER PROF

SQL> conn /as sysdba SQL> shutdown immediate; SQL> startup mount SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQL> ALTER SYSTEM SET AQ_TM_PROCESS

1、下载“instantclient-basic-nt-11.2.0.3.0” 下载地址：http://pan.baidu.com/s/1hqp6dGK2、解压instantclient-basic-nt-11.2.0.3.0到任意目录，例如：D:\app\oracle_client\instantclient_11_23、在环境变量的path里面添加刚刚