oracle : the password has expried to unlimited Hint

Conn as sysdba $ sqlplus /nolog SQL> conn /as sysdba Change password first! SQL> ALTER USER [USERID] IDENTIFIED by [PASSWORD]; Check password life time SQL> select * from dba_profiles where profile=’DEFAULT’ and resource_name=’PASSWORD_LIFE_TIME’; PROFILE        RESOURCE_NAME RESOURCE —————————— ——————————– ——– LIMIT —————————————- DEFAULT        PASSWORD_LIFE_TIME PASSWORD 180 Set password life time to […]

Read More

oracle : change charset test => csscan

$ sqlplus /nolog SQL> conn /as sysdba SQL> @/home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/csminst.sql $ csscan $ csscan Character Set Scanner v2.2 : Release 11.2.0.1.0 - Production on 일 9월 13 23:11:54 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: derp Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With […]

Read More

oracle : impdb : dbms_metadata_util

Import: Release 11.2.0.1.0 – Production on Thu May 28 06:46:52 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. 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 ORA-39006: internal error ORA-39213: Metadata processing is not available connect […]

Read More

oracle : ALTER DATABASE CHARACTER SET INTERNAL_USE

[oracle@owl110]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Thu May 28 06:38:32 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> SQL> SQL> conn /as sysdba Connected. SQL> SHUTDOWN IMMEDIATE; Database closed. Database dismounted. ORACLE instance shut down. SQL> STARTUP MOUNT; ORACLE instance started. Total System Global Area 6.3068E+10 bytes Fixed Size 2219392 bytes […]

Read More
12