Oracle部署第一部曲;

    技术2022-05-18  9

    (1)无法用所有默认用户登录SQL Plus :

         解决方案:运行->cmd-> 键入命令:sqlplus / as sysdba

    (2)查询数据库中所有用户:select username from dba_users;

    (3)查询数据库中所有表空间:select * from sys.dba_tablespaces;

    (4)创建用户:

          create user dcuser default tablespace users

                                         tamporary tablespace temp;

          alter user dcuser indentified by dvtecc;

         

    (5)遇到如下错误:

        5.1 ORA-28000:账户已被锁定

        5.2 ORA-01045

              SP2-0640:为连接

        解决方案:

             授权:Grant resource,conect to dcuser;

                      Grant create session to dcuser;

      


    最新回复(0)