Sunday, November 8, 2020

Cara Menghidupkan TNS dan Database Oracle

Menghidupkan TNS service

lsnrctl status;  -- cek status

lsnrctl start; -- menghidupkan

lsnrctl stop;  -- mematikan


Starting Up and Shutting Down

sqlplus sys as sysdba atau sqlplus / as sysdba

startup -- menyalakn database

kalau ada masalah : listerner : bloked

#shutdown abort

shutdown immediate


untuk menghidupkan EBS

sesuai kan dengan folder yang ada pada masing2 server

contoh : 

192.168.2.214

u : oraprod

p : oraprod

masuk ke server linux dengan user dan password hak yang diberikan akses ke program


jika minta login app 

u : sysadmin

p : sysadmin

yg dikasih tanda --

u : system

p : manager


bisa juga untuk login ke aplikasi ebs

u : apps

p : apps

untuk mengecek status server jalan apa ndak, sesuaikan dengan user dan password pada ebs

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adcmctl.sh status apps/apps


mematikan

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/jtffmctl.sh stop

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adcmctl.sh stop apps/apps

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adoafmctl.sh stop

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adformsctl.sh stop

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adoacorectl.sh stop

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adapcctl.sh stop

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adalnctl.sh stop

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adopmnctl.sh stop


menghidupkan

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adopmnctl.sh start

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adalnctl.sh start

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adapcctl.sh start

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adoacorectl.sh start

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adformsctl.sh start

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adoafmctl.sh start

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/adcmctl.sh start apps/apps

/u01/PROD/inst/apps/PROD_ifa-db/admin/scripts/jtffmctl.sh start



Memunculkan Simbol & Emoji Pada OS Mac

  Memunculkan Simbol & Emoji  1. Buka aplikasi Pages / Notes pada Macbook. 2. Klik pada Menubar Edit --> Pilih Emoji and Symbols a...