Categories
DATABASE

[memo] docker : wnameless/oracle-xe-11g , create database tsdb steps

… docker run \ –name ora11xe -d \ -p 49160:22 \ -p 49161:1521 \ -v //mnt/data:/data \ -v /etc/localtime:/etc/localtime:ro \ -e ORACLE_ALLOW_REMOTE=true \ wnameless/oracle-xe-11g

Categories
DATABASE JOB

在 gentoo 裝 oracle sqlplus package

去 Oracle 那邊 download 那個 instantclient-sqlplus-linux32-11.1.0.7.zip 放到 /usr/portage/distfiles 下 emerge -av dev-db/oracle-instantclient-sqlplus

Categories
DATABASE

筆記 oracle sqlplus 連線 不用 tnsname 檔案的方法 / syntax

sqlplus account/password@172.25.0.18x/service_name sqlplus sys/password@172.30.0.48/oradb as sysdba 或 sqlplus /nolog conn account/password@172.25.0.18x/service_name

Categories
DATABASE JOB

Oracle 小筆記

— Create sequence create sequence TEST_SQ minvalue 1 maxvalue 9999999999 start with 21 increment by 1 cache 20; select test_sq.nextval from dual select test_sq.currval from dual https://172.20.10.6:5500/em/console/logon/logon https://172.20.10.6:5500/em/console/aboutApplication sqlplus sysman/sysman sqlplus sysman/oracle sqlplus system@”(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DB1)))” lsnrctl status sqlplus /nolog emctl status emctl start dbconsole emctl stop dbconsole /etc/init.d/vmware-tools status /etc/init.d/vmware-tools lsnrctl start [oracle@localhost ~]$ sqlplus /nolog […]