부족하지만 함께 나누는 System 엔지니어링

version: Microsoft SQL Server 2012 (SP3)

! 사용 중인 프로시저가 있을 경우 detach가 진행 되지 않는다.
! 운영 서비스에 영향이 있는지 확인해보고 오프라인 전환 후 진행.

! If the procedure is running or using DB, you can't detach the Database. 
! First, you have to check the Service in operation. After that, switching the database offline.

use master;
GO
EXEC sp_detach_db @dbname = N'mydb';
GO

! detach 후, mdf 및 ldf 파일 복사 진행.
! After detach the databse, you can copy the mdf and ldf file.

! 복사가 완료 된 후, Attach 진행.
! if the file copy is finished normally, you can attach the DB with new path.

USE master;
GO
CREATE DATABASE PlatformService
    ON (FILENAME = 'H:\SQL_DATA3\mydb.mdf'),
    (FILENAME = 'H:\SQL_DATA3\mydb_log.ldf')
    FOR ATTACH;
GO

! attach 후 정상 작동 여부 확인. DB를 오프라인으로 전환했을 경우, 온라인 전환.

! When the tasks are completed successfully, Check that the DB is working properly. 
! If you switched the database offline, you have to switching the db status to online.

version: Microsoft SQL Server 2012 (SP3)

! If the procedure is running or using DB, you can't detach the Database.
! First, you have to check the Service in operation. After that, switching the database offline.

use master;
GO
EXEC sp_detach_db @dbname = N'mydb';
GO

! After detach the databse, you can copy the mdf and ldf file.

! if the file copy is finished normally, you can attach the DB with new path.

USE master;
GO
CREATE DATABASE PlatformService
    ON (FILENAME = 'H:\SQL_DATA3\mydb.mdf'),
    (FILENAME = 'H:\SQL_DATA3\mydb_log.ldf')
    FOR ATTACH;
GO

! When the tasks are completed successfully, Check that the DB is working properly.
! If you switched the database offline, you have to switching the db status to online.

IP변경

/etc/sysconfig/network-scripts/<인터페이스>
　IPADDR="<IP>" 

# ifup <인터페이스> 

history 타임스탬프

/etc/profile 
  HISTTIMEFORMAT="[%F %T] " 
  export HISTTIMEFORMAT 

or

# sed -i '10a\\export HISTTIMEFORMAT\n' /etc/profile 
# sed -i '10a\\HISTTIMEFORMAT="[%F %T] "' /etc/profile 

ssh root 접근 차단

/etc/ssh/sshd_config 
　PermitRootLogin no 

# sed -i "s/tLogin yes/tLogin no/g" /etc/ssh/sshd_config 

# systemctl restart sshd 

TimeZone 변경

# timedatectl set-timezone Asia/Seoul 

Prompt 전체 경로 표시

# echo 'export PS1="[\u@\h \w]\\$ "' > /etc/profile.d/prompt.sh

httpd version: 2.2.15

If you put the httpd module to be used in the 'modules/' directory, it will works.

But for 'mod_dnssd', you need to install the package of the module.

When I just added the module file in 'modules/', the error occurred like under.

Cannot load /etc/httpd/modules/mod_dnssd.so into server: libavahi-common.so.3: cannot open shared object file: No such file or directory

In this case, you can easily solve the problem like this.

# yum install mod_dnssd -y

And maybe a httpd reboot will be required.

# service httpd restart

IIS 웹 서버에서 BonCode 버전 업그레이드를 진행하던 중 다음과 같은 오류가 발생했다.

그래서 BonCodeAJP13.dll 의 런타임을 확인해 보았다.

PS > $path = "D:\BonCodeAJP13.dll"
PS > [Reflection.Assembly]::ReflectionOnlyLoadFrom($path).ImageRuntimeVersion

이제 IIS 응용 프로그램 풀에서 해당 사이트의 풀을 dll의 런타임과 동일한 버전으로 변경해주면 된다.

서비스 재시작 필요없이 바로 정상작동 하는 것을 확인할 수 있다.