Category Oracle İntroduction

Solaris 11 javac: command not found


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 […]

Upgrade Exadata ibswitches


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 […]

ORA-30372: fine grain access policy conflicts with materialized view ISSUE :


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 […]

Putting a RAC database in ARCHIVELOG


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 […]

ORA-02085: database link connects to


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 […]

Two days in Istanbul TROUG (The Turkish Oracle User Group )


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 […]

Process Familiarization Exadata 1/8


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


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 […]

ORA-16025: parameter LOG_ARCHIVE_DEST contains repeated or conflicting attributes


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)’ […]

Creating a Flashback Data Archive


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 […]

Exadata default passwords


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

How can update Java tzdate2016c


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 […]

Exadata ILOM – How to Disable Daylight Savings Time (DST) (


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 […]

User Creation and Remove commands in solaris 10


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 […]

Immediate Kill Session#: 1, Serial#: 3 Immediate Kill Session: sess: 6fa39d608 OS pid: 6419


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 […]

How to grant “SELECT” privilege to v$session .


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 ————– —————————— […]

ORA-38500: USING CURRENT LOGFILE option not available without standby redo logs


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


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 […]

IF YOU LOST ALL CONTROLFILE(RECOVER CONTROLFILE)


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 […]

IF YOU LOST ALL CONTROLFILE(CREATE CONTROLFILE COMMAND)


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 […]