One of the requirements for upgrading to Enterprise Manager Cloud Control 13c Release 2, is to apply. Database patch set update 160419 While trying to apply the patch to Oracle GI + DB, it will error out with non existing files (more below…). opatchauto apply 22899531 System initialization log file is /u01/app/grid/12.1.0.1/grid/cfgtoollogs/opatchautodb/systemconfig2016-10-06_02-29-43PM.log. Session log file …
sqlite> .mode csv sqlite> .output test.csv sqlite> select * from tbl1; sqlite> .output stdout
How to recover from an Oracle DB if the disk/file system for archive logs gets full Note: if DB is hung at shutdown i.e. shu immediate, then force a shutdown, like below SQL> shutdown abort; SQL> startup nomount; SQL> alter database mount SQL> exit Get size used for if needed SQL> col name format A50 …
How to recover from an Oracle DB archivelog full error Read More »
To add new disk array / lun sqlplus / as sysasm ALTER DISKGROUP DATA ADD DISK ‘/dev/rdsk/c1d1s0’ REBALANCE POWER 5; # Fastest ALTER DISKGROUP DATA ADD DISK ‘/dev/rdsk/c1d1s0’ REBALANCE POWER 11; To verify SQL> select path,name,header_status from v$asm_disk; To Check where the rebalnce is up to select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES …
<?xml version='1.0'?> <!DOCTYPE service_bundle SYSTEM '/usr/share/lib/xml/dtd/service_bundle.dtd.1'> <service_bundle type='manifest' name='export'> <service name='application/informix' type='service' version='0'> <create_default_instance enabled='true'/> <single_instance/> <dependency name='multi-user-server' grouping='require_any' restart_on='error' type='service'> <service_fmri value='svc:/milestone/multi-user-server:default'/> </dependency> <exec_method name='start' type='method' exec='/usr/informix/bin/oninit -v' timeout_seconds='600'> <method_context> <method_credential user='informix' group='informix'/> <method_environment> <envvar name='INFORMIXDIR' value='/usr/informix' /> <envvar name='INFORMIXSERVER' value='devtech101prod4' /> …
srvctl add network -netnum 2 -subnet 10.10.10.0/255.255.255.0/aggrpub1 -nettype static srvctl add scan -scanname 12cdb1-pub-scan.domain.com -netnum 2 srvctl start scan -netnum 2 srvctl status scan -netnum 2 srvctl add scan_listener -netnum 2 -endpoints TCP:1521 -listener listener2 srvctl start scan_listener -netnum 2 srvctl add vip -node 12cdb1 -address 10.10.10.111/255.255.255.0 -netnum 2 srvctl add vip -node 12cdb2 -address …
Creating, Adding Additional SCAN Addresses in Oracle Database 11g Read More »
create table ifxload(id integer primary key autoincrement, time varchar(10), load varchar(5)); select * from ifxload where id = (select max(id) from ifxload);
To display Informix Startup progress when many devices on a system. Just run onstat -d look at the active number at the end of the row – it will display Displays information for chunks in each storage space
Example 1 echo exit | sqlplus / as sysdba @/var/tmp/usera/foo.sh |egrep “COUNT|3|Elapsed:” >>/var/tmp/db_timing.out Example 2 while :; do echo exit | sqlplus / as sysdba @/var/tmp/usera/foo.sh |egrep “COUNT|3|Elapsed:” >>/var/tmp/db_timing.out; sleep 2; done Example 3 while :; do sqlplus eli/eli @/var/tmp/usera/foo.sh >>/var/tmp/db_timing.out ; sleep 2; done
Change pga size, set the pga to at least 32gb >Set to the number of cores show parameter gcs_server – 16; Change DB options to filesystemio_options setall To change listner to SDP crsctl modify resource ora.LISTENER.lsnr -attr “ENDPOINTS=SDP:1521” crsctl modify resource ora.LISTENER_SCAN1.lsnr -attr “ENDPOINTS=SDP:1521” crsctl modify resource ora.LISTENER_SCAN2.lsnr -attr “ENDPOINTS=SDP:1521” crsctl modify resource ora.LISTENER_SCAN3.lsnr -attr …