« Oracle Forcing Start »
Sometimes oracle is starting with some datbases not running, we can force the start :
[oracle@vmlin64ora02 ~]export ORACLE_SID=databasetest
[oracle@vmlin64ora02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 20 15:11:06 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2217952 bytes
Variable Size 2483030048 bytes
Database Buffers 838860800 bytes
Redo Buffers 16343040 bytes
Database mounted.
Database opened.
SQL> exit
~
[oracle@vmlin64ora02 ~]$ export ORACLE_SID=mydata
[oracle@vmlin64ora02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 28 12:33:32 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 1006635120 bytes
Database Buffers 587202560 bytes
Redo Buffers 7360512 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@vmlin64ora02 ~]$
[oracle@vmlin64ora02 ~]$ cat .bashrc
# .bashrc
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
# User specific aliases and functions
export ORACLE_SID=mydata
export ORACLE_HOME="/home/oracle/app/oracle/product/11.2.0/dbhome_1"
export ORACLE_HOME_LISTNER=$ORACLE_HOME
export LD_LIBRARY_PATH="/usr/lib:/home/oracle/app/oracle_client/product/11.2.0_v32/dbhome_1"
export TNS_ADMIN="/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin"
export PATH=$PATH:./:/home/oracle/app/oracle_client/product/11.2.0_v32:/home/oracle/app/oracle_client/product/11.2.0_v32:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin
# ======================================================
# ALIAS
# ======================================================
#Util
alias v='ps -ufx'
alias verif='ps -ufx'
alias la='ls -la'
alias bin='cd ../bin'
alias conf='cd ../conf'
alias log='cd ../log'
alias tmp='cd ../tmp'
Écrire commentaire
gBqsPxAZ (mardi, 04 octobre 2022 15:48)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:49)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:53)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:54)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:54)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:55)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:55)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:56)
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
gBqsPxAZ (mardi, 04 octobre 2022 15:56)
57LYwn8G'; waitfor delay '0:0:15' --
gBqsPxAZ (mardi, 04 octobre 2022 15:57)
bWGtNIUL') OR 656=(SELECT 656 FROM PG_SLEEP(15))--
gBqsPxAZ (mardi, 04 octobre 2022 15:58)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:58)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:59)
20
gBqsPxAZ (mardi, 04 octobre 2022 15:59)
20
gBqsPxAZ (mardi, 04 octobre 2022 16:00)
20
gBqsPxAZ (mardi, 04 octobre 2022 16:00)
20
gBqsPxAZ (mardi, 04 octobre 2022 16:01)
20
gBqsPxAZ (mardi, 04 octobre 2022 16:03)
20
wPmTdyOx'; waitfor delay '0:0:15' -- (mardi, 04 octobre 2022 16:03)
20
gBqsPxAZ (mardi, 04 octobre 2022 16:04)
20
gBqsPxAZ (mardi, 04 octobre 2022 16:04)
20
gBqsPxAZ (mardi, 04 octobre 2022 16:05)
20
gBqsPxAZ (mardi, 04 octobre 2022 16:05)
20
gBqsPxAZ (mardi, 04 octobre 2022 16:06)
20
lxbfYeaa (mardi, 05 décembre 2023 06:02)
20
lxbfYeaa (mardi, 05 décembre 2023 06:03)
20