我以sys登录pl/sql创建空间和用户:
CREATE TABLESPACE "tllhryjy"
LOGGING
DATAFILE 'F:\oracle\product\10.2.0\oradata\jincheng\tonlin.ora' SIZE 200M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE USER "tlsb" PROFILE "DEFAULT"
IDENTIFIED BY "111111" DEFAULT TABLESPACE "tllhryjy"
TEMPORARY TABLESPACE "Temp"--------------------------------------------这步正确吗?
ACCOUNT UNLOCK
GRANT "CONNECT" TO "tlsb";
GRANT "RESOURCE" TO "tlsb"
在Net Manager里创建了本地服务tonlin连接本地数据库在登录pl/sql的时候
用户名:tlsb
口令:111111
数据库:tonlin
连接为:normal
时报错invalid username/password;login denied!
求救!
CREATE TABLESPACE "tllhryjy"
LOGGING
DATAFILE 'F:\oracle\product\10.2.0\oradata\jincheng\tonlin.ora' SIZE 200M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
CREATE USER "tlsb" PROFILE "DEFAULT"
IDENTIFIED BY "111111" DEFAULT TABLESPACE "tllhryjy"
TEMPORARY TABLESPACE "Temp"--------------------------------------------这步正确吗?
ACCOUNT UNLOCK
GRANT "CONNECT" TO "tlsb";
GRANT "RESOURCE" TO "tlsb"
在Net Manager里创建了本地服务tonlin连接本地数据库在登录pl/sql的时候
用户名:tlsb
口令:111111
数据库:tonlin
连接为:normal
时报错invalid username/password;login denied!
求救!
=============================================
测试连接串成功了吗?
另外用户名和密码也不要加双引号,那样就会区分大小写,所以报密码错误