Oracle

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

instantclient-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_HOME
cd cx_Oracle-5.1.3

python setup.py build
#python setup.py install

/etc/ld.so.conf
/home/uchida/data_base/oracle/instantclient/instantclient_12_1

# ldconfig

Ruby

$ gem install ruby-oci8

Error Message:
  '/usr/lib/sdk/include/oci.h' does not exist.
  Install 'Instant Client SDK'.
Java

java.security.AccessControlException:
 access denied (java.util.PropertyPermission oracle.net.wallet_location read)

C#

libmono-oracle4.0-cil
/usr/lib/mono/4.0/System.Data.OracleClient.dll
Arch Linux

Oracle client

/etc/pacman.conf

[oracle]
SigLevel = Optional TrustAll
Server = http://linux.shikadi.net/arch/$repo/$arch/
export LD_LIBRARY_PATH=/usr/lib/mono/4.0/System.Data.OracleClient.dll

Fedora へのサーバーのインストール

# rpm -i oracle-xe-11.2.0-1.0.x86_64.rpm

# /etc/init.d/oracle-xe configure

	Specify 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:
	
Client

$ . /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

result_aa

outarea_aa
outarea_bb
outarea_cc
outarea_dd
outarea_ee
outarea_ff
outarea_gg
outarea_hh

Return

May/09/2023 AM 08:15