plsqldeveloperxx

1、sqlplus /nolog 2、conn / as sysdba; 3、创建用户 create user scott identified by tiger; GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER; 4、取消区分大小写 alter system set sec_case_sensitive_logon=false; 5、导入scott.sql @D:\database\app\oracle\product\11.2.0\server\rdbms\admin\scott.sql 6、查询所有用户 select username from all_users; 7、登陆 conn scott/tiger; 8、在上述成功的前提下 conn scott/tiger@xe; 如果连接不上 1)、C:\Windows\System32\drivers\etc\hosts 2)、更改 D:\database\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) 3)、更改 D:\database\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) ) 4)、重启两个服务 OracleServiceXE OracleXETNSListener lsnrctl start