Oracle 11g 설치 및 환경 구성
DB/Oracle 11g 2019. 4. 10. 09:12
비밀번호 재 설정
https://m.blog.naver.com/baekmg1988/221298569322
SQL Plus한글 깨짐
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 10 16:41:35 2019
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: system
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: system
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter user scott account unlock;
User altered.
SQL> conn
Enter user-name: scott
Enter password:
ERROR:
ORA-28001: the password has expired
Changing password for scott
New password:
Retype new password:
Password changed
Connected.
SQL> conn
Enter user-name: scott
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> conn
Enter user-name: scott
Enter password:
Connected.
SQL> show user
USER is "SCOTT"
SQL> conn
Enter user-name: sys as sysdba
Enter password:
Connected.
SQL> alter user system identified by 1234
2 ;
User altered.
SQL> alter user hr identified by 1234;
User altered.
SQL> conn system/1234
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
SQL> conn sys as sysdba/1234
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
SQL> conn
Enter user-name: sys as sysdba
Enter password:
Connected.
SQL> alter user system account unlock;
User altered.
SQL> alter user hr account unlock;
User altered.
SQL> conn
Enter user-name: hr
Enter password:
Connected.
SQL> show user;
USER is "HR"
SQL> select status from V$instance;
select status from V$instance
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>
|
'DB > Oracle 11g' 카테고리의 다른 글
mac sqldeveloper vender code 17176 (0) | 2019.05.09 |
---|---|
mac oracle 11g xe vender code 17002 (0) | 2019.05.09 |
오라클 삭제후 재설치 (0) | 2019.05.01 |