Category Oracle Database

Oracle Database commands

Login auf Commandline

PS C:\Users\ov1adm.TESTDEV> sqlplus
	SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 15 08:46:22 2011
	Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: ov1adm as sysdba
Enter password:

	Connected to:
	Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
	With the Partitioning, OLAP, Data Mining and Real Application Testing options
	
ARCHIVE LOG LIST = zeigt DB Archive Infos an
ALTER SYSTEM ARCHIVE LOG STOP; = Stopp das archivieren
alter system set log_archive_start=false scope=spfile; = stoppt das automatische archivieren. Benötigt neustart der Datenbank.
SHUTDOWN NORMAL = Datenbank Instance runterfahren
STARTUP = Datenbank Instance hochfahren...
Read More

Oracle Database Upgrade von 11.2.04 auf 12.1.02 (SAP technisch)

Oracle Upgrade von 11.2.04 auf 12.1.02
###########
Zuvor unbedingt ein DB Fullbackup erstellen (offline und online_cons)
###########
"oracle" user anlegen und DB umswitchen

Auf dem Oracle DB Server: 

groupadd oinstall
useradd -g oinstall -G dba,oper -c "Oracle Software Owner" -m -s "/bin/sh" oracle 
passwd oracle
su - oracle -c "id; pwd"
su - oracle
echo $PATH 
	sollte vorhanden sein ":/usr/local/bin:"
su - al2adm -c "id; pwd"

als "root"
mkdir -p /home/oraal2
chown oraal2:dba /home/oraal2
usermod -d /home/oraal2 oraal2
usermod -g dba -G oper,oinstall oraal2
cd /oracle/AL2
cp -frv .profile .login .bashrc .cshrc .sap* .dbenv* ...
Read More

Oracle 11 DB für SAP Solution Manager Installation

Die Datenbank via SWPM 700 installieren.

user: "sapadm" via Yast anlegen 

SWPN 700 -> SAP Solution Manager 7.1 Support Release 1 -> SAP Systems -> Oracle -> Distributed system -> Based on AS ABAP and AS Java -> Database Instance
Wizard folgen:
	Custom
	Kernel NW 7.20 / 7.21
	Profile Directroy angeben
	Pass: Test1234
	SAP System Administrator -> default
	SAP System Domain Name -> FQDN deactivate
	Database Identification
		SID: <SAPSID>
		Single Instance on Filesystem
	Ins Exp 1
	Ins Exp 2
	Java Comp...
Read More

Oracle 12c Restore (point in time) mit Brtools und Commvault

Datenbank muss gestartet sein.


export SAPDATA_HOME=/oracle/HR3


5


2


ln -s /oracle/HR3/sapbackup /oracle/HR3/12102/sapbackup

ln -s /oracle/HR3/saparch /oracle/HR3/12102/saparch

ln -s /oracle/HR3/sapcheck /oracle/HR3/12102/sapcheck

ln -s /oracle/HR3/sapreorg /oracle/HR3/12102/sapreorg

ln -s /oracle/HR3/sapdata1/ /oracle/HR3/12102/sapdata1

ln -s /oracle/HR3/sapdata2/ /oracle/HR3/12102/sapdata2

ln -s /oracle/HR3/sapdata3/ /oracle/HR3/12102/sapdata3

ln -s /oracle/HR3/sapdata4/ /oracle/HR3/12102/sapdata4

ln -s /oracle/HR3/sapdata5/ /oracle/HR3/12102/sapdata5

c


1


tail /oracle/HR3/saparch/archHR3.log


4


C


2



1


3


5


6


C


C


C


C


C




8


C


C


C


C


C


C




C


Y


Y


C


C


Y


C


Read More

Oracle Upgrade von 11 auf 12. Migration des Software-Eigentümers zu ‘oracle’

Oracle Upgrade

OS technisch

	fstab
	hosts
	ggf. hostname (bleibt)
	resolv.conf
	/oracle/HR3/112_64/network/admin/listener.ora (/oracle/HR3/121_64/network/admin)
	ifconfig(yast)
	nsswitch
		#hosts:          files dns
		#networks:       files dns
		hosts:         files
		networks:      files
	crontab -e
	ggf. /etc/init.d/postfix stop
	Database log mode              No Archive Mode
	
SAP technisch vorbeitungen.
	ggf. IPtables damit die Server IP technisch nicht nach außen Kommunizieren.
	Batch Prozess Anzahl auf 0 ("vi /usr/sap/HR3/SYS/profile/HR3_DVEBMGS00_sles14" -> rdisp/wp_no_btc = 0 )
	RFC angepasst (/nsm59)
	Std...
Read More

Oracle BRtools Table Space erweitern

Table Space Erweitern

"brtools"
	2 - Space management
	1 = Extend tablespace
	c
	c
	c	
	Anzeige der Tabellen. Hier 95,03 % Belegung
		1 - PSAPSR3         103/0       395411456     95.03    19645696    395411456

	1	(Tabelle 1 auswählen)
		Darauf Achten. wichtig "autoextend off"
		alle prüfen:
		 Options for extension of tablespace PSAPSR3 (1. file)

		 1 * Last added file name (lastfile) ....... [/oracle/PR1/sapdata5/sr3_103/sr3.data103]
		 2 * Last added file size in MB (lastsize) . [4000]
		 3 - New file to be added (file) ........... [/oracle/PR1/sapdata5/sr3_104/sr3.data104]
		 4 ~ Raw disk / link target (rawlink) ...... []
		 5 - Size of the new file in MB (size) ..... [4000]
		 6 - File autoextend mode (autoextend) .......
Read More