root@exadata02:~# cd /u01/staging/SOLARIS11.2/ root@exadata02:/u01/staging/SOLARIS11.2# ls -ltrh total 21828629 -rw-r–r– 1 root root 1.7G Aug 22 11:02 p19298012_1100_Solaris86-64_1of4.zip -rw-r–r– 1 root root 1.2G Aug 22 11:04 p21518848_1100_Solaris86-64_2of3.zip -rw-r–r– 1 root root 1.8G Aug 22 11:04 p19298012_1100_Solaris86-64_2of4.zip -rw-r–r– 1 root root 1.8G Aug 22 11:05 p19298012_1100_Solaris86-64_3of4.zip -rw-r–r– 1 root root 1.7G Aug 22 11:06 p19298012_1100_Solaris86-64_4of4.zip -rw-r–r– 1 […]


bash-3.2$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 5 11:06:43 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 2.0583E+10 bytes Fixed Size 2168240 bytes Variable Size 5167385168 bytes Database Buffers 1.5368E+10 bytes Redo Buffers 45907968 […]


$ cd $ORACLE_HOME/rdbms/admin bash-4.1$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 25 09:20:00 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options […]


bash-4.1$ cd $ORACLE_HOME/rdbms/admin bash-4.1$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 25 09:20:00 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options […]


Dba_registry shows ‘Packages and Types’ as invalid. How it can be validated. SQL> select comp_name, version, status from dba_registry; COMP_NAME VERSION STATUS —————————————- ———- ———- Oracle XML Database 10.2.0.1.0 VALID Oracle Database Catalog Views 10.2.0.1.0 VALID Oracle Database Packages and Types 10.2.0.1.0 INVALID JServer JAVA Virtual Machine 10.2.0.1.0 VALID Oracle XDK 10.2.0.1.0 VALID Oracle Database […]


hen I checked the Exadata cell storage log Alert seen such an error : MS process is not alive. Pid is missing. Exadata Cell Storage Alert log: [root@anarexaceladm03 trace]# cat rstrc_15083_mmt.trc Trace file /opt/oracle/cell/log/diag/asm/cell/anarexaceladm03/trace/rstrc_15083_mmt.trc ORACLE_HOME = /opt/oracle/cell System name: Linux Node name: anarexaceladm03.kfsaz.local Release: 2.6.39-400.264.6.el6uek.x86_64 Version: #1 SMP Tue Dec 1 16:41:42 PST 2015 Machine: […]


Issue  ======  Getting frequent errors as below Mon Jun 20 18:58:09 2016  Errors in file /u01/app/oracle/diag/rdbms/ANARTEST/ANARTEST1/trace/ANARTEST1_ora_16361.trc:  ORA-15025: could not open disk “/dev/rdsk/emcpower2a”  ORA-27041: unable to open file  SVR4 Error: 13: Permission denied  Additional information: 3  WARNING: failed to read mirror side 1 of virtual extent 23 logical extent 0 of file 259 in group [1.443862875] […]


root@anaruatdb1:/u02/app/11.2.0/grid > su – grid Password: Oracle Corporation      SunOS 5.11      11.3    September 2015 -bash-4.1$ bash bash-4.1$ . .profile_asm bash-4.1$ srvctl stop database -d ANARTEST -o immediate root@anaruatdb1:~# su – oracle Oracle Corporation      SunOS 5.11      11.3    September 2015 You have mail. bash-4.1$ . .profile_ANARTEST bash-4.1$ cd $ORACLE_HOME/bin bash-4.1$ ls -ltr oracle -rwsr-s–x   1 oracle   asmadmin 258286384 […]


1. Login to sqlplus as sysdba and execute below script : oradba@ANARDB:~$ export ORACLE_SID=ANARDB oradba@ANARDB:~$ sqlplus SQL> select name from v$database; NAME ——— ANARDB 2. Open the set server output on to get the result from below query. SQL> set serveroutput on; 3. Execute the query to get the information of datafiles, control files and […]


PROBLEM : Connecting with sqlplus you get: bash-3.2$ sqlplus / as sysdba; SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 21 15:42:49 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> conn […]


select ‘ alter table ‘||table_name|| ‘ enable novalidate constraint ‘ ||constraint_name ||’;’ from user_constraints where table_name =’TABLE_NAME’


set pages 0 feed off veri off lines 500 accept oldname prompt “Enter user to model new user to: ” accept newname prompt “Enter new user name: ” — accept psw prompt “Enter new user’s password: ” — Create user… select ‘create user &&newname identified by values ”’||password||””|| — select ‘create user &&newname identified by […]


root@bakuabsutdb:~# cd /tmp/ root@bakuabsutdb:/tmp# ls Baku Baku.solaris hmptemp hsperfdata_root root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# ls Baku Baku.solaris hmptemp hsperfdata_root Java_Timezone root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# cd Java_Timezone/ root@bakuabsutdb:/tmp/Java_Timezone# root@bakuabsutdb:/tmp/Java_Timezone# ls azerbaycan.zip once sonra TimeZoneTest.class tzdata2016c.tar.gz tzupdater.jar verify.bat deneme1 once_anar1 sonra_anar TimeZoneTest.java tzdata2016c.tar.gz.sha512 tzupdater.jar_backup verify.sh java once_yeni sonra_anar1 tzdata2016b.tar.gz tzupdater-2_0_3-2015b.zip update.bat New_Java_Timezone once_yeni2 sonra_yeni tzdata2016b.tar.gz.sha512 tzupdater-2.0.3-2015b update.sh […]


root@anarexadatatest02:~# /u01/app/11.2.0.3/grid/bin/crsctl stat res -t ——————————————————————————– NAME TARGET STATE SERVER STATE_DETAILS ——————————————————————————– Local Resources ——————————————————————————– ora.DATAC1.dg ONLINE ONLINE anarexadatatest01 ONLINE ONLINE anarexadatatest02 ora.DBFS_DG.dg ONLINE ONLINE anarexadatatest01 ONLINE ONLINE anarexadatatest02 ora.LISTENER.lsnr ONLINE ONLINE anarexadatatest01 ONLINE ONLINE anarexadatatest02 ora.RECOC1.dg ONLINE ONLINE anarexadatatest01 ONLINE ONLINE anarexadatatest02 ora.asm ONLINE ONLINE anarexadatatest01 Started ONLINE ONLINE anarexadatatest02 Started ora.gsd OFFLINE OFFLINE […]


Receiving the following error when trying to create the materialize view oracle@bakuexa1dbadm01:~$ echo $ORACLE_SID MISUAT1 oracle@bakuexa1dbadm01:~$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 6 09:55:05 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With the Partitioning, Real Application […]


bash-4.1$ su – oracle Password: Oracle Corporation SunOS 5.11 11.3 September 2015 -bash-4.1$ -bash-4.1$ -bash-4.1$ -bash-4.1$ . .profile_ANARTEST bash-4.1$ bash-4.1$ bash-4.1$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.4.0 Production on Tue May 31 11:46:12 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production […]


oracle@anarexadatatest01:/u01/app/oracle/product/11.2.0.3/dbhome_1/network/admin$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.3.0 Production on Thu May 12 16:26:23 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select name […]


TROUG / The Turkish Oracle User Group did its annual conference in the rooms of the Istanbul Technical University with local and international speakers. You can see ajanda from here I delivered my presentation “DataSecurity and Database Vault” Many thanks to the organizers  inviting us speakers to dinner. Some frames of the speakers: Thanks again […]


In this practice, I will examine the Exadata cell software processes. Tasks 1.Establish a terminal connection to qr01cel01 as the celladmin user. 2.Restart Server (RS) is used to start up and shut down the Cell Server (CELLSRV) and Management Server (MS). It also onitors these services to check whether they need to be restarted. Locate […]


ORA-39181: Only partial table data may be exported due to fine grain access control . . exported “APEX_030200″.”WWV_FLOW_CLICKTHRU_LOG_NUMBER$” 4.914 KB 1 rows . . exported “APEX_030200″.”WWV_FLOW_COMPANIES” 5.625 KB 3 rows . . exported “KOCAZER”.”CPM_PACKAGE_DEPOSIT_RATES” 5.734 KB 4 rows ORA-39181: Only partial table data may be exported due to fine grain access control on “KOCAZER”.”USERS” the […]


alter system set log_archive_dest_2=’service=”(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db5.anar.az)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db1.anar.az)(SERVER=DEDICATED)))”‘,’LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=”db1″ net_timeout=15, valid_for=(all_logfiles,primary_role)’ scope=both; ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes Solution: Remove “net_timeout” alter system set log_archive_dest_2=’service=”(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db5.anar.az)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db1.anar.az)(SERVER=DEDICATED)))”‘,’LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=”db1″, valid_for=(all_logfiles,primary_role)’ […]


Melumatin tehlukesizliyi meqsedile gorulen lazimi isler eyni zamanda sebeke, emeliyyat sistemleri seviyyesindeki kimi verilenler bazasi seviyyesinde de nezere alinmalidir. Umumen gotursek, sirketler sadece firewall mehsulu alir ve bele dusunurler ki, tehlukesizliye aid olan problemleri artiq hell edibler. Tedqiqatcilar gosterir ki, baxmayaraq bu mehsullardan istifade etmekle xaricden gelen hucumlara qarsi qorunmaq mumkundur, daxilden gelen hucumlari def […]


select blocking_session,blocked_session,script from ( select distinct s1.username || ‘@’ || s1.machine || ‘ ( INST=’ || s1.inst_id || ‘ SID=’ || s1.sid || ‘ ET=’ || s1.last_call_et || ‘sn. STATUS=’ || s1.status || ‘ EVENT=’ || s1.event || ‘ ACTION= ‘ || s1.action || ‘ PROGRAM=’ || s1.program || ‘ MODULE=’ || s1.module || ‘)’ […]


Create a new tablespace or use existing tablespace – tablespace needs to be ASSM Specify the FBDA as the default (optional) Assign a quota for the FBDA (optional) Assign a retention period for the FBDA Retention period integer denoting days,months or years Enable flashback archive for a specific table via the CREATE TABLE or ALTER […]


FDA’nın kullanılabilmesi için önceden tanımlanan işlemler bulunmaktadır. Bunlar; 1) FDA tablespace’leri mutlaka automatic segment space management (ASSM) ile yönetilmelidir. Elle yönetilenleri FDA için kabul edilmemektedir. 2) Automatic undo management mutlaka aktif olmalıdır. Aksi halde FBDA arka plan görevi işlevlerini yerine getiremez. FDA’yı kullanmak için isterseniz yeni bir tablespace yaratabilir ya da daha önceden var olanını […]


Database Server root/welcome1 oracle/welcome1 grid/welcome1 grub/sos1Exadata Database server ILOMs root/welcome1 Exadata Storage Cell Server root/welcome1 celladmin/welcome1 cellmonitor/welcome1 Exadata Storage Cell Server ILOMs root/welcome1 InfiniBand switches root/welcome1 nm2user/changeme InfiniBand ILOMs ilom-admin/ilom-admin ilom-operator/ilom-operator Ethernet switches admin/welcome1 Power distribution units (PDUs) admin/welcome1 root/welcome1 Keyboard, video, mouse (KVM) if available admin/welcome1


bash-3.2$ cd /data/ bash-3.2$ ls Baku.solaris Java_Timezone arch anardb.ctl anardb.yed cd control datafile initANARDB.ora lost+found orapwANARDB1 patch stnd.ctl trace bash-3.2$ bash-3.2$ ls -la total 17902902 drwxr-xr-x 10 oracle oinstall 512 Mar 24 19:14 . dr-xr-xr-x 35 root bin 1024 Jul 8 2015 .. -rw-r–r– 1 root root 512 Mar 21 17:19 Baku.solaris drwxr-xr-x 4 root […]


Oracle(R) Integrated Lights Out Manager Version 3.1.2.32.b r86441 Copyright (c) 2014, Oracle and/or its affiliates. All rights reserved. -> start /SP/console Are you sure you want to start /SP/console (y/n)? y Serial console started. To stop, type ESC ( [root@bakuexa1celadm01 ~]# [root@bakuexa1celadm01 ~]# uname -a Linux bakuexa1celadm01.kfsaz.local 2.6.39-400.128.17.el5uek #1 SMP Tue May 27 13:20:24 PDT […]


Creating User Accounts To create a user account: # useradd -u 100 -g other -d /export/home/newuser1 -m -s /bin/ksh -c “Regular User Account” newuser1 # passwd newuser1 # /usr/sadm/bin/smuser add — -n newuser2 -u 500 -g other -d /export/home/newuser2 -c “Regular User Account 2” -s /bin/ksh -x autohome=N # passwd newuser2 Modifying User Accounts To […]


I am pretty sure that many of us come across of situations when a killed session by ‘alter system kill session’ command did put the session in ‘KILLED’ status and never released the session for a long time on the database. It could be due to the fact that the session would be rolling back […]


SQL> GRANT SELECT ON v$session TO scott; grant select on v$session to test * ERROR at line 1: ORA-02030: can only select from fixed tables/views SQL> SELECT owner, object_type FROM dba_objects WHERE object_name = ‘V$SESSION’; OWNER OBJECT_TYPE ———————— ——————- PUBLIC SYNONYM SQL> select table_owner, table_name FROM dba_synonyms where synonym_name = ‘V$SESSION’; TABLE_OWNER TABLE_NAME ————– —————————— […]


prompt set feed off prompt Auto tasks (11G) prompt accept x_days prompt “Days [1] : ” default 1 prompt select decode( b.instance_number, a.inst_id, ‘–>’, null ) “Current”, a.instance_name, a.host_name, a.version, a.startup_time, a.status, a.parallel, a.thread#, a.archiver, a.log_switch_wait, a.logins, a.shutdown_pending, a.database_status, a.instance_role, a.active_state, a.blocked, a.instance_number from gv$instance a, v$instance b where b.instance_number (+)= a.inst_id order by a.inst_id; […]


bash-3.2$ sqll SQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 28 01:04:13 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> SQL> SQL> SQL> SQL> SQL> STARTUP NOMOUNT ORACLE instance started. Total System Global Area 2.0583E+10 bytes Fixed Size 2190488 bytes Variable Size 3087012712 bytes Database Buffers 1.7448E+10 bytes Redo […]


Warning: lost write detection is not enabled on the standby while it is enabled on the primary The above error is caused because of the following parameter set to NONE in standby whereas it has been set to TYPICAL in primary database. So we have altered the below parameter to TYPICAL in standby and the […]


bash-3.00$ pwd /export/anar/oradata/ANARDB bash-3.00$ cp /export/anar/oradata/ANARDB/backup/control01.ctl . bash-3.00$ cp control01.ctl control02.ctl bash-3.00$ cp control01.ctl control03.ctl bash-3.00$ ls *.ctl control01.ctl control02.ctl control03.ctl bash-3.00$ rm *.dbf bash-3.00$ bash-3.00$ bash-3.00$ ls arch control01.ctl control02.ctl control03.ctl redo01.log redo02.log redo03.log backup bash-3.00$ rm *.ctl bash-3.00$ cp ./backup/*.dbf . bash-3.00$ cp /export/anar/oradata/ANARDB/backup/control01.ctl . bash-3.00$ cp control01.ctl control02.ctl bash-3.00$ cp control01.ctl control03.ctl […]


bash-3.00$ ls -lrt total 3720312 -rw-r—– 1 oracle oinstall 69214208 Nov 27 17:41 temp02.dbf -rw-r—– 1 oracle oinstall 10493952 Nov 27 17:41 ttstest.dbf -rw-r—– 1 oracle oinstall 52429312 Nov 27 17:45 redo02.log -rw-r—– 1 oracle oinstall 52429312 Nov 27 18:14 redo03.log drwxr-xr-x 2 oracle oinstall 1024 Nov 27 18:14 arch -rw-r—– 1 oracle oinstall 5251072 […]


SQL> show parameter control_file NAME TYPE VALUE ———————————— ———– —————————— control_files string /export/anar/oradata/ANARDB/control01.ctl, /export/anar/oradata/ANARDB/control02.ctl, /export/anar/oradata/ANARDB/control03.ctl SQL> shu abort ORACLE instance shut down. SQL> SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 – 64bit Production With the Partitioning, OLAP and Data Mining options bash-3.00$ ls arch control02.ctl cooldata01.dbf redo01.log redo03.log system01.dbf ttstest.dbf users01.dbf […]


Sqlplus “/ as sysdba”; Shut immediate startup nomount RMAN> @@ANARTEST-72.tmp 2> connect target *; 3> **end-of-file** 4> run { 5> allocate channel c0 type sbt PARMS=”SBT_LIBRARY=/opt/AVMRclnt/lib/libobk_avamar64.so” format ‘%d_%U’; 6> send channel ‘c0’ ‘”–libport=45603″ “–cacheprefix=ANARTEST_c0” “–sysdir=/opt/AVMRclnt/etc” “–bindir=/opt/AVMRclnt/bin” “–vardir=/opt/AVMRclnt/var/clientlogs” “–logfile=/opt/AVMRclnt/var/clientlogs/MOD-1455616226902-2002-OracleANARTEST-avtar.log0” “–ctlcallport=45201″‘; 7> set until scn 884703403597; 8> restore database; 9> recover database; 10> } 11> alter database […]


In alert log: Tue Feb 16 11:51:02 2016 alter database mount Tue Feb 16 11:51:07 2016 Successful mount of redo thread 1, with mount id 958201638 Database mounted in Exclusive Mode Lost write protection disabled Completed: alter database mount Tue Feb 16 11:54:26 2016 Errors in file /u01/app/oracle/diag/rdbms/ANARTEST/ANARTEST/trace/ANARTEST_ora_10509.trc: ORA-19930: file /u01/app/oracle/fast_recovery_area/ANARTEST/control02.ctl has invalid checkpoint SCN […]


To create a normal restore point, we require either one of the following privileges. SELECT ANY DICTIONARY FLASHBACK ANY TABLE For example: SQL> CREATE TABLE t (x,y,z) 2 ENABLE ROW MOVEMENT 3 AS 4 SELECT object_id 5 , object_name 6 , object_type 7 FROM all_objects 8 WHERE ROWNUM <= 5; Table created. SQL> SELECT * […]


SQL> select text from dba_source where name=’ANAR_UPD_SALES’ order by line; TEXT ——————————————————————————– procedure ANAR_UPD_SALES as begin for i in 1..10000 loop update sales set amount_sold=amount_sold*1 where rownum<2; commit; end loop; end; 7 rows selected. SQL> drop procedure ANAR_UPD_SALES; Procedure dropped. SQL> connect / as sysdba Connected. SQL> select text from dba_source as of timestamp systimestamp […]


Target CDB = ANAR_CDB12C1 Auxiliary CDB = ANAR_CDB12C3 PDB to duplicate = Only ANAR_PDB1 [bash-3.2$ ]$ rman target sys/<password>@ANAR_CDB12C1 auxiliary sys/<password>@ANAR_CDB12C3 Recovery Manager: Release 12.1.0.1.0 – Production on Sat Jul 20 13:15:57 2016 Copyright (c) 1982, 2016, Oracle and/or its affiliates. All rights reserved. connected to target database: ANAR_CDB12C1 (DBID=2076797181) connected to auxiliary database: ANAR_CDB12C3 […]


echo “—————————————————————————-” echo Report by Anar Godjaev Oracle 9i/10g/11g OCA,OCP,SQL Expert, PL/SQL Prof,RAC echo “—————————————————————————-” #!/bin/ksh # This shell script performs the following steps # shutdown the database with immediate mode # log file ORACLE_HOME=/data1/oracle/product/8.1.7 ; export ORACLE_HOME ORACLE_SID=ORCL export ORACLE_SID LOGFILE=/data1/oracle/admin/ORCL/log/anar.log clear echo “Obase-1 the database is closed.” echo ” Are you sure you? […]


Practical: D:\ORACLE_HOME\BIN> Impdp -help D:\ORACLE_HOME\BIN> Expdp -help Table Level: E:>EXPDP  system/oracle TABLES=anar.test1,anar.test2 DIRECTORY=DAILY_BK_DIR  DUMPFILE=test1_test2.dmp  LOGFILE=test1_test2.log E:>EXPDP  system/oracle TABLES=hr.test1 DIRECTORY=DAILY_BK_DIR  DUMPFILE=test1_backup_%date:~7,2%%date:~4,2%%date:~10,4%_%time:~0,2%%time:~3,2%%time:~6,2%.dmp  LOGFILE=test1_backup_logfile%date:~7,2%%date:~4,2%%date:~10,4%_%time:~0,2%%time:~3,2%%time:~6,2%.log Day     (DD) = %date:~7,2% Month (MM)=%date:~4,2% Year    (YY)=%date:~10,4% Hour   (HH)=%time:~0.2% Minutes(MM)=%time:~3,2% Seconds(SS)=%time:~6,2% E:>IMPDP  TABLES=anar.test1 DIRECTORY=DAILY_BK_DIR  DUMPFILE=test1_test2.DMP LOGFILE=imp_test1test2.log OR E:>IMPDP  schemas_name/password      DIRECTORY=DAILY_BK_DIR  DUMPFILE= test1_test2.DMP LOGFILE= imp_test1test2.log OR E:>IMPDP  FULL=Y           DIRECTORY=DAILY_BK_DIR  DUMPFILE=anar_test1.DMP LOGFILE=imp_test1test2.log Note: If the […]


startup.sh/Shutdown.sh   /  Script is useful for you !!!!!!!!! #!/bin/sh # —————————————————————————– # Stop script for the CATALINA Server # # $Id: shutdown.sh,v 1.3 2002/08/04 18:19:43 patrickl Exp $ # —————————————————————————– # resolve links – $0 may be a softlink PRG=”$0″ while [ -h “$PRG” ] ; do   ls=`ls -ld “$PRG”`   link=`expr “$ls” : […]


RMAN> restore controlfile from autobackup; Starting restore at 19-FEB-15 using channel ORA_DISK_1 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150219 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150218 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150217 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150216 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150215 channel ORA_DISK_1: looking […]


C:\Documents and Settings\oracle>rman target / Recovery Manager: Release 11.2.0.1.0 – Production on Sat Feb 18 00:02:33 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: PROD (DBID=183876134) RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name PROD are: […]


ORAchk replaces the popular RACcheck tool, extending the coverage based on prioritization of top issues reported by users, to proactively scan for known problems within the area of: +Oracle Database +Enterprise Manager Cloud Control (12c only) +E-Business Suite +Oracle Hardware Systems +Oracle Identity and Access Management +Oracle Siebel +Oracle PeopleSoft ORAchk features: Proactively scans for […]


[oracle@anardbrac1 ~]$ sqlplus ‘/as sysdba’ SQL> CREATE TABLESPACE transport_test_ts_1 DATAFILE ‘tt_ts1.dbf’ SIZE 128K AUTOEXTEND ON NEXT 128K; SQL> CREATE TABLESPACE transport_test_ts_2 DATAFILE ‘tt_ts2.dbf’ SIZE 128K AUTOEXTEND ON NEXT 128K; SQL> ALTER USER test QUOTA UNLIMITED ON transport_test_ts_1 QUOTA UNLIMITED ON transport_test_ts_2; SQL> CONN test/test SQL> CREATE TABLE transport_test_tab ( id NUMBER NOT NULL, code VARCHAR2(10) […]


bash-3.2$ uname -a SunOS bakudbtstora1 5.10 Generic_150400-11 sun4v sparc sun4v bash-3.2$ ftp -inv <<-EOD > open bakudbtstora1 > user oracle ora123 > cd ftproot > binary > mput test*.txt > bye > EOD Connected to localhost. 220 vmx01 FTP server ready. 331 Password required for oracle. 230 User oracle logged in. 250 CWD command successful. […]


Exadata Storage Sever X4-2


Exadata Database Machine X4-2


Exadata Storage Expansion Rack X3


Exadata Storage Sever X3-2


Exadata Storage Expansion Rack X2


Exadata Storage Sever X2-2


Exadata Database Machine X2-8


Exadata Database Machine X2-2