#!/bin/ksh #set -x # ######################################################## # Create export dump file as unix pipe. # # Be sure to test thoroughly before using. # Change the directory structures and names to match # your system. # # Author: M. Finn ########################################################
if [ -p /tmp/EXPORT/export.dmp ]; then true else /etc/mknod /tmp/EXPORT/export.dmp p fi # ######################################################## # CHANGE THE DIRECTORY PATH TO WHERE YOU CREATED PIPE. ######################################################## # compress </tmp/EXPORT/export.dmp >/tmp/EXPORT/export`date '+%m%d%y'`.dmp.Z & # ######################################################## # CHANGE THE DIRECTORY TO WHERE YOUR PARFILE EXISTS. # CHANGE THE DIRECTORY TO WHERE YOUR COMPRESSED EXPORT # FILE IS TO BE CREATED. ######################################################## # exp FILE=/tmp/EXPORT/export.dmp PARFILE=/tmp/EXPORT/test.par 2> /tmp/EXPORT/export`date '+%m%d%y'`.log
Run post script (root로) export GI_HOME=/u01/app/19.3.0.0/grid $GI_HOME/rdbms/install/rootadd_rdbms.sh $GI_HOME/crs/install/rootcrs.sh -postpatch -rollback
[PCA 2.x] How to Set Passwordless SSH Connection to Compute Node ILOM's from Management Nodes (Doc ID 2869125.1)
- 설정
set /SP/users/root/ssh/keys/2 load_uri=scp://root:Welcome1@192.168.4.4/root/.ssh/id_rsa.pub set /SP/users/root/ssh/keys/1 load_uri=scp://root:Welcome1@192.168.4.3/root/.ssh/id_rsa.pub
인증서만 복사해주면 됨. 끝!!
- 확인 show /SP/users/root/ssh/keys/2 show /SP/users/root/ssh/keys/1
- 원복 set /SP/users/root/ssh/keys/1 clear_action=true set /SP/users/root/ssh/keys/2 clear_action=true
- 해당 값의 의미 /SP/users/user/ssh/keys/n where n is the number of the ssh key you want to configure. • transfer_method can be tftp, ftp, sftp, scp, http, or https. • username is the name of the user account on the remote system. (username is required for scp, sftp, and ftp. username is not used for tftp, and is optional for http and https.) • password is the password for the user account on the remote system. (password is required for scp, sftp, and ftp. password is not used for tftp, and is optional for http and https.) • ipaddress_or_hostname is the IP address or the host name of the remote system. • directorypath is the location of the SSH key on the remote system. • filename is the name assigned to the SSH key file.
Run post script (root로) export GI_HOME=/u01/app/19.3.0.0/grid $GI_HOME/rdbms/install/rootadd_rdbms.sh $GI_HOME/crs/install/rootcrs.sh -postpatch -rollback
Oracle Grid Infrastructure Patch Set Update 19.19.0.0.230418 ----------------------------------------------------------------------------------- GI_HOME, ORACLE_HOME 을 개별로 각각 할때
Run post script (root로) export GI_HOME=/u01/app/19.3.0.0/grid $GI_HOME/rdbms/install/rootadd_rdbms.sh $GI_HOME/crs/install/rootcrs.sh -postpatch -rollback
sys@TEST> alter session set "_enable_rename_user" = true;
Session altered.
Elapsed: 00:00:00.00 sys@TEST> alter system enable restricted session;
System altered.
Elapsed: 00:00:04.16 sys@TEST> alter user test1 rename to test2 identified by test2; alter user test1 rename to test2 identified by test2 * ERROR at line 1: ORA-03001: unimplemented feature
테스트 결론
-> 11g/12c 는 아래와 같은 꼼수로 user명 변경이 가능함. alter session set "_enable_rename_user" = true; alter system enable restricted session;
-> 19c 에서는 되지 않는다. export의 fromuser,touser 또는 datapump의 remap_schema 옵션으로 넘겨야 할듯...
