ͻ񻣼
1¡¢lsnrctl status È·±£PDBÈÝÆ÷¼àÌýÕý³£ 2¡¢È·±£PDBÈÝÆ÷¶ÁдÕý³£ sqlplus / as sysdba show pdbs; 3¡¢ÐÞ¸Ä tnsname.oraÎļþ cd /opt/oracle/product/19c/dbhome_1/network/admin vi tnsn ÔĶÁÈ«ÎÄ
ͻ񻣼
Ïêϸ¹ý³Ì²»×¸ÊöÁË¡£°Ù¶ÈÁ˺ܶà°ì·¨¶¼²»¿ÉÓã¬È»ºó³¢ÊÔÖØ×°k8s ºÃ¶à´a56爆大奖在线娱乐²²»¹ÜÓᣠ×îºó½â¾ö¡£ kubectl edit deployment coredns -n kube-system apiVersion: apps/v1 kind: Deployment metadata: annotation ÔĶÁÈ«ÎÄ
ͻ񻣼
1¡¢PG 2¡¢SQLServer 3¡¢Oracle SELECT * FROM NLS_DATABASE_PARAMETERS where parameter = 'NLS_CHARACTERSET'; 4¡¢DM select SF_GET_UNICODE_FLAG(); 0 a56爆大奖在线娱乐 GB18030£¬ ÔĶÁÈ«ÎÄ
ͻ񻣼
show variables like '%timeout%'; select * from nls_database_parameters; select table_name from user_tables; set global ob_trx_timeout = 86400000000; s ÔĶÁÈ«ÎÄ
ͻ񻣼
(1)Ëø±í²éѯµÄ´úÂëÓÐÒÔϵÄÐÎʽ£º select count(*) from v$locked_object;select * from v$locked_object; (2)²é¿´Äĸö±í±»Ëø select b.owner,b.object_name,a.session_id,a.locked_mo ÔĶÁÈ«ÎÄ
ͻ񻣼
fdisk -l²é¿´ÐÂÔöÓ²ÅÌ Ò»°ãÐÂÔöΪ /dev/sdb /dev/sdc Èç´Ë˳ÑÓ fdisk /dev/sdb pvcreate /dev/sdb pvdisplay vgextend centos /dev/sdb vgdisplay centos df -h lvresize --exte ÔĶÁÈ«ÎÄ
ͻ񻣼
1¡¢ useradd highgo su highgo 2¡¢ÉÏ´«°²×°Îļþ chown -R highgo:highgo xxx chmod -R 700 xxx 3¡¢°²×° ./hgdb-install_linux.x86_64_20230314.bin 4¡¢ÉèÖû·¾³±äÁ¿ vi ~/.bash_pro ÔĶÁÈ«ÎÄ
ͻ񻣼
Ìí¼ÓÐÂÍø¿¨ nmcli connection add con-name eth66 type ethernet ifname eth66 ipv4.addresses 10.110.137.76/24 ipv4.gateway 10.110.139.254 ipv4.dns 10.100.1.58 ÔĶÁÈ«ÎÄ
ͻ񻣼
cd /usr/lib/systemd/system vi oscardb.service [Unit]Description=oscarAfter=network.target [Service]Type=forkingExecStart=/opt/ShenTong/admin/oscardb_O ÔĶÁÈ«ÎÄ
ͻ񻣼
mkdir -p /opt/GBase/data/dn1_1 mkdir -p /opt/GBase/gbase_package mkdir -p /opt/GBase/gbase_db mkdir -p /mnt/sdb/data groupadd gbase useradd -m -d /hom ÔĶÁÈ«ÎÄ