sqlplus /nolog connect sys/passwd as sysdba select * from v$version; select SYSDATE from dual;
SQL>shutdown immediate
SQL>startup
SQL>select * from dual;
SQL>select username from dba_users;
ORA-01081: cannot start already-running ORACLE - shut it down first
ORA-01507: database not mounted
ORA-00205: error in identifying control file, check alert log for more info
ORA-12560: TNS:protocol adapter error
Python
cx_Oracle-5.1.3.tar.gz/etc/ld.so.confinstantclient-basic-linux.x64-12.1.0.2.0.zip
instantclient-sdk-linux.x64-12.1.0.2.0.zip
cd instantclient_12_1
ln -s libclntsh.so.12.1 libclntsh.so
export ORACLE_HOME=$HOME/instantclient_12_1 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOMEcd cx_Oracle-5.1.3 python setup.py build
#python setup.py install
/home/uchida/data_base/oracle/instantclient/instantclient_12_1# ldconfig Ruby
$ gem install ruby-oci8JavaError Message: '/usr/lib/sdk/include/oci.h' does not exist. Install 'Instant Client SDK'.
java.security.AccessControlException: access denied (java.util.PropertyPermission oracle.net.wallet_location read)C#
libmono-oracle4.0-cilArch Linux
/usr/lib/mono/4.0/System.Data.OracleClient.dll
Oracle client /etc/pacman.confFedora へのサーバーのインストール
[oracle]export LD_LIBRARY_PATH=/usr/lib/mono/4.0/System.Data.OracleClient.dll
SigLevel = Optional TrustAll
Server = http://linux.shikadi.net/arch/$repo/$arch/
# rpm -i oracle-xe-11.2.0-1.0.x86_64.rpm # /etc/init.d/oracle-xe configureClientSpecify a password to be used for database accounts. Note that the same password will be used for SYS and SYSTEM. Oracle recommends the use of different passwords for each database account. This can be done after initial configuration:$ . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh $ sqlplus systemユーザーの作成SQL> CREATE USER scott IDENTIFIED BY "tiger" DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; SQL> grant DBA to scott; SQL> grant UNLIMITED TABLESPACE TO scott;ユーザーの削除SQL> drop user scott cascade;
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for Linux: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production