ORACLE 설치 / 계정만들기

다운로드 링크 

: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

64비트 윈도우 버전 : https://drive.google.com/file/d/0BysmzgE-DemJMkVCcDJtUXU3STQ/view?usp=sharing

32비트 윈도우 버전 : https://drive.google.com/file/d/0BysmzgE-DemJNk5xTE1Ld1ZGYkE/view?usp=sharing

 

 

 

 

C:\Users\Administrator.Sc-201803021643>sqlplus system

 

SQL*Plus: Release 11.2.0.2.0 Production on 목 3월 8 19:55:24 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> alter user hr account unlock;

User altered.

SQL> alter user hr identified by hr;

User altered.

SQL> create user ans identified by ans;     //사용자 계정을 부여하는 것은 관리자 권한만 가능하다.

User created.

SQL> grant connect, resource to ans;      // 권한을 부여한다.

Grant succeeded.

SQL>