CentOS 7 – 오라클 18c XE 설치

패키지 업데이트

# yum update
# yum install wget

패키지 업데이트를 먼저한다

다운로드

# cd /usr/local/src
# wget https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
# wget https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm

설치파일 다운로드는 아래 링크에서 한다.
https://www.oracle.com/database/technologies/xe-downloads.html

설치 진행

# yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
# yum -y localinstall oracle-database-xe-18c-1.0-1.x86_64.rpm

설치 사이즈가 커서 오래걸린다

초기설정

# /etc/init.d/oracle-xe-18c configure

Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
 Confirm the password:
 Configuring Oracle Listener.
 Listener configuration succeeded.
 Configuring Oracle Database XE.
 Enter SYS user password:                                                                                                           
 Enter SYSTEM user password:
 
 Enter PDBADMIN User Password:
 
 Prepare for db operation
 7% complete
 Copying database files
 29% complete
 Creating and starting Oracle instance
 30% complete
 31% complete
 34% complete
 38% complete
 41% complete
 43% complete
 Completing Database Creation
 47% complete
 50% complete
 Creating Pluggable Databases
 54% complete
 71% complete
 Executing Post Configuration Actions
 93% complete
 Running Custom Scripts
 100% complete
 Database creation complete. For details check the logfiles at:
  /opt/oracle/cfgtoollogs/dbca/XE.
 Database Information:
 Global Database Name:XE
 System Identifier(SID):XE
 Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE1.log" for further details.
 Connect to Oracle Database using one of the connect strings:
      Pluggable database: localhost.localdomain/XEPDB1
      Multitenant container database: localhost.localdomain
 Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE

비밀번호는 최소 1개의 대문자와 소문자, 숫자를 조합해서 8자이상 입력해야 한다.

환경설정 추가

# vi ~/.bash_profile

export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_SID=XE
export ORAENV_ASK=NO
export PATH=$PATH:$ORACLE_HOME/bin

.bash_profile 파일 하단에 환경설정을 추가

리스너 확인

# lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 01-FEB-2021 11:02:03
 Copyright (c) 1991, 2018, Oracle.  All rights reserved.
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
 STATUS of the LISTENER
 Alias                     LISTENER
 Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
 Start Date                01-FEB-2021 11:01:04
 Uptime                    0 days 0 hr. 0 min. 58 sec
 Trace Level               off
 Security                  ON: Local OS Authentication
 SNMP                      OFF
 Default Service           XE
 Listener Parameter File   /opt/oracle/product/18c/dbhomeXE/network/admin/listener.ora
 Listener Log File         /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
 Listening Endpoints Summary…
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=localhost)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/product/18c/dbhomeXE/admin/XE/xdb_wallet))(Presentation=HTTP)(Session=RAW))
 Services Summary…
 Service "XE" has 1 instance(s).
   Instance "XE", status READY, has 1 handler(s) for this service…
 Service "XEXDB" has 1 instance(s).
   Instance "XE", status READY, has 1 handler(s) for this service…
 Service "ba3db2e4206012dde055000000000001" has 1 instance(s).
   Instance "XE", status READY, has 1 handler(s) for this service…
 Service "xepdb1" has 1 instance(s).
   Instance "XE", status READY, has 1 handler(s) for this service…
 The command completed successfully

listener.ora

[root@localhost admin]# cat listener.ora
 listener.ora Network Configuration File: /opt/oracle/product/18c/dbhomeXE/network/admin/listener.ora
 Generated by Oracle configuration tools.
 DEFAULT_SERVICE_LISTENER = XE
 LISTENER =
   (DESCRIPTION_LIST =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
     )
   )

tnsnames.ora

[root@localhost admin]# cat tnsnames.ora
 tnsnames.ora Network Configuration File: /opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora
 Generated by Oracle configuration tools.
 XE =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = XE)
     )
   )
 LISTENER_XE =
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

포트번호가 바뀐경우가 있었는데, 그럴경우에 1521로 변경해서 저장하고 재시작 해준다

데이터베이스 접속확인

# sqlplus
SQL*Plus: Release 18.0.0.0.0 - Production on Mon Feb 1 12:59:38 2021
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Enter user-name: system
Enter password:
Last Successful login time: Mon Feb 01 2021 11:23:03 +09:00
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SQL>

데이터베이스 Start/Stop

# /etc/init.d/oracle-xe-18c start
# /etc/init.d/oracle-xe-18c stop

Android SDK Tools Setup :: JDK not found

Java SE Development Kit (JDK) not found.

Android SDK relies on the Java SE Development Kit (JDK).
Go to http://java.sun.com > Downloads > Java SE > JDK to download adn install a JDK before continuing.

Note: A Java Runtime (JRE) is not enough to develop for Android.

Visit java.sun.com

==================================================================

안드로이드 SDK 설치시,
JDK가 설치되어 있음에도 Next 가 안되는 상황발생

해결방법(1)
http://codearetoy.wordpress.com/2010/12/23/jdk-not-found-on-installing-android-sdk/
위 링크로 이동해서 따라하면 된다
32bit로 설치하든지 zip 파일로 설치해 보길 권하고 있다.

해결방법(2)
Next > 버튼이 비활성화 되어 있다면 < Back 한번 눌렀다가 다시 와보면 Next >가 활성화 되어 있다.
설치를 진행하면 된다…. -_-;;;;;;;;;

사용자 삽입 이미지

CentOS 5.5 네트워크 설치

CentOS 5.5 네트워크 설치방법입니다.
VMware Wrokstation 에서 설치하는 것을 기준으로 합니다.

1. http://ftp.daum.net/centos/5.5/isos/x86_64/

CentOs-5.5-x86_64-netinstall.iso 를 다운로드한다.



2. VMware CD-ROM 설정에서 다운받은 iso 파일을 마운트 시킨다



3. VMware 를 시작해준다



[F2-Options] 를 선택한다




네트워크 설치를 위해서
linux askmethod 를 입력한뒤 엔터를 눌러준다






언어/키보드 설정을 한다



네트워크 설치이므로 HTTP를 선택한다



각 환경에 맞게 값을 입력한다
공유기를 사용중이므로 DHCP에서 할당되는 값을 지정해줬다

192.168.123.190 / 255.255.255.0



Web site name : ftp.daum.net
CentOs directory : /centos/5.5/os/x86_64 (/os/ 부분을 주의!!!)

이후 진행은 별다른게 없다~



이클립스 3.4 Ganymede + Spring IDE 설치방법

이클립스 새로운 버전인 3.4 Ganymede 와 스프링IDE 설치를 진행하는 과정에서
Dependencies 때문에 설치가 진행이 안된다면 참고

Spring IDE 2.0.6 will be the last version that supports Mylyn 2.3. The port to Mylyn 3.0 APIs has already been finished and will be available in the next few days. This migration is required to make installing Spring IDE into the Ganymede packages possible. If you want to use 2.0.6 with Ganymede please don’t install the Mylyn integration.

참조 : http://springide.org/blog/2008/06/24/spring-ide-206-available/

http://www.eclipse.org/downloads/ 에서
Eclipse IDE for Java EE Developers(163MB) 다운로드 후 압축해제하여 설치

이클립스를 실행하고 Menu > Help > Software Updates… > Available Software >
Add Site 버튼 클릭하고 Location에 http://springide.org/updatesite 입력하고 OK 클릭

사용자 삽입 이미지
Spring IDE Update Site 에서 Dependencies 체크해제후 오른쪽 상단의 Install.. 클릭

사용자 삽입 이미지
위 두곳의 체크를 해제하고 설치를 진행합니다.