Æí¸®ÇÑ È£½ºÆà ¹Ì¼ÒIDC

   
 
 
 

      1Â÷ ³×ÀÓ¼­¹ö :
      ns1.misoidc.com
      101.79.73.101

      2Â÷ ³×ÀÓ¼­¹ö :
      ns2.misoidc.com
      101.79.73.105

      ¾îÁ¦ : 304 ,¿À´Ã : 407
      Àüü : 1,151,453


     

 

 
ÀÛ¼ºÀÏ : 12-12-17 17:40
centos 6.2 oracle 10g ¼³Ä¡
 ±Û¾´ÀÌ : ½ÑÀ¥È£½ºÆÃ
Á¶È¸ : 333,042  

1) °¢Á¾ ȯ°æº¯¼ö °ª ¼³Á¤ ( ²À ¿À¶óŬ ¼³Ä¡¸¦ À§Çؼ­¸¸ ÇÊ¿äÇÑ °ÍÀÌ ¾Æ´Ñ ±âº»Àû ¼³Á¤µé )

< ÇÑ±Û manpages ¼³Ä¡ >
yum -y install man-pages-ko.noarch

< /etc/hosts >
127.0.0.1 mycent localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.200.3 mycent

< /etc/sysconfig/network >
NETWORKING=yes
HOSTNAME=mycent

< /etc/sysconfig/i18n >
LANG="ko_KR.UTF-8"
SYSFonT="en_US.UTF-8:en_US:en:ko_KR.eucKR:ko_KR:ko"

< /etc/redhat-release >
[root@mycent ]# cp /etc/redhat-release /etc/redhat-release.backup
[root@mycent ]# vi /etc/redhat-release
"CentOS release 6.2 (Final)" -> "redhat-4"·Î º¯°æ

< /etc/sysctl.conf >
[root@mycent ]# cp /etc/sysctl.conf /etc/sysctl.conf.backup
[root@mycent ]# vi /etc/sysctl.conf
ÀÖ´Â Ç׸ñÀº °ª ¼öÁ¤
kernel.shmall = 2097152
kernel.shmmax = 536870912
¾ø´Â Ç׸ñÀº °ª Ãß°¡
kernel.shmmni = 4096
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
Ä¿³Î ¸Å°³º¯¼ö Àû¿ë
[root@mycent ]# /sbin/sysctl -p

< /etc/security/limits.conf >
[root@mycent ]# cp /etc/security/limits.conf /etc/security/limits.conf.backup
[root@mycent ]# vi /etc/security/limits.conf
¾Æ·¡³»¿ë Ãß°¡
#@student - maxlogins 4
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
# End of file

< /etc/selinux/config >
[root@mycent ]# cp /etc/selinux/config /etc/selinux/config.backup
[root@mycent ]# vi /etc/selinux/config
"SELINUX=enforcing" -> "SELINUX=disabled"·Î º¯°æ

< /etc/pam.d/login >
[root@mycent ]# cp /etc/pam.d/login /etc/pam.d/login.backup
[root@mycent ]# vi /etc/pam.d/login
¾Æ·¡³»¿ë Ãß°¡
session required pam_limits.so

2) Çʼö ÆÐÅ°Áö ¼³Ä¡

[root@mycent ]# yum install binutils-2* compat-libstdc++-33* elfutils-libelf* gcc-4.* gcc-c++-4.* glibc-2.* glibc-common-2.* glibc-devel-2.* glibc-headers-2.* ksh* libaio-0.* libaio-devel-0.* libgomp-4.* libgcc-4.* libstdc++-4.* libstdc++-devel-4.* make-3.* sysstat-7.* unixODBC-2.* unixODBC-devel-2.* pdksh* libXp

3) ¿À¶óŬ °èÁ¤ ¹× ±×·ì »ý¼º

[root@mycent ]# groupadd oinstall
[root@mycent ]# groupadd dba
[root@mycent ]# useradd -g oinstall -G dba oracle
[root@mycent ]# passwd oracle
[root@mycent ]# mkdir -p /opt/oracle/product/10.2.0/db_1 (¼³Ä¡´ë»ó°æ·Î)
[root@mycent ]# chown -R oracle:oinstall /opt/oracle
[root@mycent ]# chmod -R 775 /opt/oracle

4) ¿À¶óŬ °èÁ¤ ȯ°æº¯¼ö ¼³Á¤

[root@mycent ]# su - oracle
[oracle@mycent ]$ vi .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
export PATH=$PATH:$HOME/bin

export TMP=/tmp;
export TMPDIR=$TMP;
export ORACLE_HOSTNAME=mycent;
export ORACLE_BASE=/opt/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
export ORACLE_SID=orcl;
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export ORACLE_TERM=xterm;
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:.:$PATH;
export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib:/lib:/usr/local/lib;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/lib:/usr/local/lib;

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

5) ¿À¶óŬ ¼³Ä¡ ÇÁ·Î±×·¥ ±¸µ¿

oralce °èÁ¤À¸·Î X-window ·Î±ä
- Å͹̳Π¿­°í export LANG=c ¼öÇà (¾È±×·¯¸é ¼³Ä¡ ÇÁ·Î±×·¥ ±ÛÀÚ°¡ ´Ù ±úÁü)
- ¿À¶óŬ ¼³Ä¡ ÇÁ·Î±×·¥ °æ·Î¿¡¼­ ./runInstaller ½ÇÇà
- "Installation Method"¿¡¼­ "Advanced Installation" ¼±ÅÃ
- "Inventory directory and credentials"¿¡¼­ "Operating System group name"¿¡ oinstall ¼±ÅÃ
- "Installation Type"¿¡¼­ "Product Language"¿¡¼­ Korean Ãß°¡ (¿µ¾î´Â ±âº»¼±ÅÃ)
- "Installation Type"¿¡¼­ "Standard Edition" ¼±ÅÃ
- "Home Details"¿¡¼­ °æ·Î È®ÀÎ
- "Prerequisite Checks"¿¡¼­ ¸ðµÎ SucceededÀÎÁö È®ÀÎ
- "Configuration Option"¿¡¼­ "Create a database" ¼±ÅÃ
- "Database Configuration"¿¡¼­ "General Purpose" ¼±ÅÃ
- "Database Configuration Options"¿¡¼­ "Character set"¿¡¼­ UTF-8 AL32UTF8 ¼±ÅÃ
- "Database Configuration Options"¿¡¼­ "Create database with sample schemas" ¼±ÅÃ
- "Database Storage Option"¿¡¼­ "File System" ¼±Åà ¹× DB ÀúÀå¼Ò °æ·Î È®ÀÎ
- "Backup and Recovery Options"¿¡¼­ "Do not enable Automated backups" ¼±ÅÃ
- "Database Schema Passwords"¿¡¼­ "Use the same password for all the accounts" ¼±ÅÃ
- "Summary"¿¡¼­ Ãâ·Â ³»¿ë Àüü È®ÀÎ
- ¼³Ä¡ ¸¶¹«¸® ´Ü°è¿¡¼­ ¾Æ·¡ µÎ°³ÀÇ ½© ½ºÅ©¸³Æ®¸¦ root±ÇÇÑÀ¸·Î ¼öµ¿ ½ÇÇà(È­¸é¿¡ ¾È³» ³ª¿È)
/opt/oracle/oraInventory/orainstRoot.sh
/opt/oracle/product/10.2.0/db_1/root.sh
- X-window »ó¿¡¼­ÀÇ ¼³Ä¡°úÁ¤ ¿Ï·á

6) ¿À¶óŬ ÀÚµ¿ ½ÃÀÛ/Á¾·á ¼³Á¤

oracle °èÁ¤À¸·Î ¼öÁ¤
< /etc/oratab >
orcl:/opt/oracle/product/10.2.0/db_1:Y

root °èÁ¤À¸·Î ¼öÁ¤
< /etc/rc.d/rc.local >
#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local
su - oracle -c /opt/oracle/product/10.2.0/db_1/bin/dbstart
su - oracle -c /opt/oracle/product/10.2.0/db_1/bin/"lsnrctl start"


7) ¿À¶óŬ »ç¿ë ÀÏ¹Ý »ç¿ëÀÚ °èÁ¤ ȯ°æ¼³Á¤

[userid@mycent ]$ vi .bash_profile
# ORACLE 10g Env
export TMP=/tmp;
export TMPDIR=$TMP;
export ORACLE_HOSTNAME=mycent;
export ORACLE_BASE=/opt/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
export ORACLE_SID=orcl;
export ORACLE_OWNER=oracle
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export ORACLE_TERM=xterm;
export NLS_LANG=KOREAN_KOREA.AL32UTF8
export PATH=$HOME/bin:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:.:$PATH;
export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib:/lib:/usr/local/lib;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/lib:/usr/local/lib;


8) ¿À¶óŬ ±âµ¿

oracle °èÁ¤À» ÀÌ¿ëÇÏ¿© ½ÇÇà
< ¿À¶óŬ ¸®½º³Ê ±¸µ¿ >
[oracle@mycent ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 27-JAN-2012 12:27:46

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /opt/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DEscRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DEscRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mycent)(PORT=1521)))

Connecting to (DEscRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 27-JAN-2012 12:27:48
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DEscRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DEscRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mycent)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

< ¿À¶óŬ DBMS ±¸µ¿ ¹× Á¾·á >
[root@mycent ]# sqlplus /nolog
SQL> connect orcl as sysdba
SQL> startup ( ¿À¶óŬ ±¸µ¿ )
SQL> shutdown immediate ( ¿À¶óŬ Á¾·á )

* ÀϹݰèÁ¤¿¡¼­ sqlplus ½ÇÇà ¾ÈµÇ´Â Çö»ó ¹ß»ý½Ã ±ÇÇÑ ¼³Á¤

< ¿¡·¯ ¸Þ½ÃÁö >
[userid@mycent ]$ sqlplus /nolog
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

< ÇØ°áÃ¥ >
root ±ÇÇÑÀ» ÀÌ¿ëÇÏ¿© ¼öÇà
[root@mycent ]# chmod -R a+rX /opt/oracle/product/10.2.0/db_1

9) Ŭ¶óÀ̾ðÆ®ÀÇ tnsnames.ora ³»¿ë Ãß°¡

ORCL =
(DEscRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ¿À¶óŬ ¼­¹ö IPÁÖ¼Ò)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)


10) ¿À¶óŬ ¼­¹ö Á¢¼Ó ÈÄ ±âº»µ¿ÀÛ È®ÀÎ

< scott °èÁ¤À¸·Î Á¢¼Ó ÈÄ »ùÇà Å×À̺í È®ÀÎ >
select * from all_tab_columns
where owner not in ('XDB')
and owner not like '%SYS%'
;
=> BONUS, DEPT, EMP, SALGRADE Å×À̺íÀÌ º¸ÀÌ´ÂÁö È®ÀÎ

< ÇÑ±Û ÀÔÃâ·Â Å×½ºÆ® >
create table test_table (
num number
, id varchar2(20)
, name varchar2(50)
, address varchar2(100)
);
insert into test_table values(1, 'userid1', 'È«±æµ¿', '¼­¿ï');
insert into test_table values(2, 'userid2', '½ÉÇü·¡', 'ºÎ»ê');
insert into test_table values(3, 'userid3', 'ÄáÁã', '´ëÀü');
insert into test_table values(4, 'userid4', 'ÈïºÎ', '±¤ÁÖ');
commit;
select * from test_table;


* ÇÑ±Û ÀÔÃâ·ÂÀ» À§ÇÑ Á¶Ä¡

[oracle@mycent ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 27 15:09:21 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn orcl as sysdba
Enter password:
Connected.
SQL> select userenv('LANGUAGE') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P1

SQL> update props$ set value$='KO16KSC5601' where name='NLS_CHARACTERSET';
1 row updated.

SQL> commit;
Commit complete.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 360710144 bytes
Fixed Size 1219424 bytes
Variable Size 113247392 bytes
Database Buffers 243269632 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.

SQL> select userenv('LANGUAGE') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.KO16KSC5601


* ¿À¶óŬ Ŭ¶óÀ̾ðÆ® ÇÁ·Î±×·¥¿¡¼­ ij¸¯Åͼ ºÒÀÏÄ¡ ¿¡·¯ ¹ß»ý½Ã Á¶Ä¡

< ¿À¶óŬ Ŭ¶óÀ̾ðÆ® ÇÁ·Î±×·¥(Åäµå or GoldenView) ÀÇ ¿¡·¯ ¸Þ½ÃÁö >
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized

< ¹®Á¦ È®ÀÎ >
¾Æ·¡ Äõ¸® Á¶È¸½Ã µ¿ÀÏ Å¸ÀÔ¿¡ ´ëÇÏ¿© 2°³ ÀÌ»óÀÇ Ä³¸¯ÅͼÂÀÌ Á¶È¸µÇ´ÂÁö È®ÀÎ

select distinct(nls_charset_name(charsetid)) CHARACTERSET,
decode(type#, 1, decode(charsetform, 1, 'VARCHAR2', 2, 'NVARCHAR2','UNKOWN'),
9, decode(charsetform, 1, 'VARCHAR', 2, 'NCHAR VARYING', 'UNKOWN'),
96, decode(charsetform, 1, 'CHAR', 2, 'NCHAR', 'UNKOWN'),
112, decode(charsetform, 1, 'CLOB', 2, 'NCLOB', 'UNKOWN')) TYPES_USED_IN
from sys.col$ where charsetform in (1,2) and type# in (1, 9, 96, 112);

CHARACTERSET TYPES_USED_IN
----------------- -------------
WE8ISO8859P1 VARCHAR2
KO16KSC5601 VARCHAR2
KO16KSC5601 CHAR
WE8ISO8859P1 CHAR
AL16UTF16 NCLOB
KO16KSC5601 CLOB
AL16UTF16 NVARCHAR2
KO16KSC5601 NVARCHAR2
WE8ISO8859P1 CLOB
AL16UTF16 NCHAR

< ¹®Á¦ Á¶Ä¡ >
- Make sure the parallel_server parameter in INIT.ORA is set to false or it is not set at all.
parallel_server °ªÀÌ falseÀ̰ųª ¶Ç´Â ÇØ´ç ÆĶó¸ÞÅÍ°¡ ¾Æ¿¹ ¼³Á¤µÇ¾î ÀÖÁö ¾Ê¾Æ¾ß ÇÔ.

SQL> show parameter parallel_server;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_server boolean FALSE

- Run the next script in SQLPLUS connected "as sysdba"
sysdba·Î ¿À¶óŬ Á¢¼ÓÇÏ¿© ¾Æ·¡ ±¸¹®µéÀ» ¼öÇàÇÑ´Ù.

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP MOUNT;

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL> ALTER DATABASE OPEN;

SQL> COL VALUE NEW_VALUE CHARSET
SELECT VALUE FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER='NLS_CHARACTERSET';

SQL> COL VALUE NEW_VALUE NCHARSET
SELECT VALUE FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER='NLS_NCHAR_CHARACTERSET';

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE &CHARSET;

SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE &NCHARSET;
-----------------------------------------------------------------------------------------
( ¸¸¾à ¿©±â¼­ ORA-12714: invalid national character set specified ¿¡·¯°¡ ¹ß»ýÇÑ´Ù¸é ¾Æ·¡ ÀÛ¾÷ ¼öÇà, ÇØ´ç ¿¡·¯°¡ ¹ß»ýÇÏ´Â ÀÌÀ¯´Â ¿À¶óŬ 9iÀÌÈÄ¿¡´Â NATIONAL CHARACTER SET Àº UTF8°ú AL16UTF16 ¸¸ Á¦°øÇϱ⠶§¹® )

¾Æ·¡ Äõ¸® Á¶È¸½Ã ÀÌ·±½ÄÀ¸·Î Áö¿øµÇÁö ¾Ê´Â °ªÀÌ Á¶È¸µÇ¸é

SELECT PARAMETER, VALUE FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER in ('NLS_NCHAR_CHARACTERSET','NLS_CHARACTERSET');

PARAMETER VALUE
---------------------------------- ---------------
NLS_CHARACTERSET KO16KSC5601
NLS_NCHAR_CHARACTERSET KO16KSC5601

UPDATE sys.props$ SET VALUE$='AL16UTF16' WHERE NAME='NLS_NCHAR_CHARACTERSET';
ÀÌÈÄ ´Ù½Ã ½ÇÇàÇϸé Á¤»óÀûÀ¸·Î µÉ °ÍÀÌ´Ù.
-----------------------------------------------------------------------------------------

SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
-- yes, 2 times startup/shutdown . This is not a typo
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

´Ù½Ã ¾Æ·¡ Äõ¸®¸¦ Á¶È¸ÇßÀ» ¶§ ÁßøµÇ´Â ij¸¯ÅͼÂÀÌ Á¶È¸µÇÁö ¾ÊÀ¸¸é Á¤»ó

select distinct(nls_charset_name(charsetid)) CHARACTERSET,
decode(type#, 1, decode(charsetform, 1, 'VARCHAR2', 2, 'NVARCHAR2','UNKOWN'),
9, decode(charsetform, 1, 'VARCHAR', 2, 'NCHAR VARYING', 'UNKOWN'),
96, decode(charsetform, 1, 'CHAR', 2, 'NCHAR', 'UNKOWN'),
112, decode(charsetform, 1, 'CLOB', 2, 'NCLOB', 'UNKOWN')) TYPES_USED_IN
from sys.col$ where charsetform in (1,2) and type# in (1, 9, 96, 112);

CHARACTERSET TYPES_USED_IN
----------------- -------------
KO16KSC5601 VARCHAR2
KO16KSC5601 CHAR
KO16KSC5601 CLOB
AL16UTF16 NCLOB
AL16UTF16 NVARCHAR2
AL16UTF16 NCHAR

¸¸¾à parallel_server ÆĶó¸ÞÅ͸¦ ¼öÁ¤Çß´Ù¸é ´Ù½Ã ¿øº¹½ÃŲ´Ù.
À§¿¡¼­ ¼öÇàÇÑ ½ºÅ©¸³Æ®µéÀº ÀÌ¹Ì ÀúÀåµÇ¾î ÀÖ´Â µ¥ÀÌÅ͵éÀ» ¹Ù²Ù´Â °ÍÀº ¾Æ´Ï°í, ´ÜÁö DBÀÇ Ä³¸¯ÅͼÂÀ» ÀúÀåµÈ ¸ðµç Àå¼Ò¿¡¼­ °­Á¦ÀûÀ¸·Î ´Ù½Ã ¼¼ÆÃÇÏ´Â °ÍÀÌ´Ù.


12) VMware ³×Æ®¿öÅ© ¼³Á¤

VMwareÀÇ °Ô½ºÆ® OS¿¡ ¸®´ª½º&¿À¶óŬ ¼³Ä¡ ÈÄ NAT »ç¿ë½Ã
³×Æ®¿öÅ© NAT ¼³Á¤¿¡¼­ Æ÷Æ® Æ÷¿öµù ¼³Á¤
sshd : 22 ¹ø
tnslsnr : 1521 ¹ø


* ¿À¶óŬ ¼³Ä¡ ÈÄ ±âŸÁ¤º¸

Server Parameter Filename :
/opt/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora

DB Control URL :
http://mycent:1158/em

The following J2EE Applications have been deployed and are accessible at the URLs listed below.
iSQL*Plus URL:
http://mycent:5560/isqlplus

iSQL*Plus DBA URL:
http://mycent:5560/isqlplus/dba

Enterprise Manager 10g Database Control URL:
http://mycent:1158/em


½ÑÀ¥È£½ºÆà 12-12-17 17:40
 
½ÑÀ¥È£½ºÆà 12-12-17 17:41
 
¼ÂÆÃÀº ÇØ ºÁ¾ß ÇÔ.
 
 

Total 78
¹øÈ£ Á¦   ¸ñ ±Û¾´ÀÌ ³¯Â¥ Á¶È¸
78 ¿ø°Ý¼­¹ö¿¡¼­ authorized_keys ·Î ÀÎÁõ¾ÈµÉ¶§ ½ÑÀ¥È£½ºÆà 07-31 24153
77 pptp vpn ¿¬°á¼­ 711 ¿À·ù ½ÑÀ¥È£½ºÆà 01-13 24786
76 ¹Ì¼ÒÄÉÀ̽º ½ÑÀ¥È£½ºÆà 07-30 25724
75 MS-SQL ¸®Çø®ÄÉÀÌ¼Ç (º´ÇÕº¹Á¦) Å×À̺í Ãß°¡ ¹æ¹ý ½ÑÀ¥È£½ºÆà 05-09 28189
74 [Linux] Çϵå¿þ¾î Á¤º¸ È®ÀÎÇϱâ - dmidecode, lshw ½ÑÀ¥È£½ºÆà 03-06 222563
73 The 5 minute DBA: Default My.cnf File ½ÑÀ¥È£½ºÆà 03-06 27357
72 [Àåºñ] OmniSwitch 6850-24x L2/L3 ½ºÀ§Ä¡ ¼³Á¤ ½ÑÀ¥È£½ºÆà 03-05 158110
71 MSSQL _Log.LDF ÆÄÀÏ »çÀÌÆ® Ä¿Á³À»¶§ Á¤¸®ÇÏ´Â ¹æ¹ý ½ÑÀ¥È£½ºÆà 02-20 22507
70 MSSQL¿¡¼­ DB º¹¿ø ÈÄ »ç¿ëÀÚ¿¡ ·Î±×ÀÎÀ̸§ÀÌ ¾ø¾î ¿À·ù°¡ ³ª´Â ¡¦ ½ÑÀ¥È£½ºÆà 02-19 23615
69 centos 6.2 oracle 10g ¼³Ä¡ (2) ½ÑÀ¥È£½ºÆà 12-17 333043
68 mysql Replicating ½ÑÀ¥È£½ºÆà 10-31 30306
67 PHP ¿Í MongoDB »ç¿ë¹ý ½ÑÀ¥È£½ºÆà 07-27 100431
66 ·¹À̾î Æ˾÷ - ´Ý±â&¿À´Ã ÇÏ·ç ¿­Áö ¾Ê±â ½ÑÀ¥È£½ºÆà 06-12 45220
65 backuppc ¼Ò½º¼³Ä¡ Çϱâ (1) ½ÑÀ¥È£½ºÆà 06-11 62296
64 rsyslog + LogAnalyzer ½ÑÀ¥È£½ºÆà 05-21 55973
 1  2  3  4  5  6