TECHNOLOGY TODAY

Database creation using dbca is preferred by most Oracle DBAs, because it is a more automated approach, and your database is ready to use when   DBCA  completes.  DBCA  can be launched by the Oracle Universal Installer (OUI), depending upon the type of install that you select. It can also be used to delete a database or configure other options of a database. Sometimes when working remotely, you may not have access to a GUI, or simply using GUI may be annoyingly slow for example when exporting display for a server installed in the cloud, as was my case. In such situations and others, you can use dbca in silent mode to create your instance. In this article we will look at how we can create a database using a non-interactive silent mode. Creating Database Using DBCA Silent Mode The “silent” argument is passed to DBCA to achieve this. Other options like password for SYS and SYSTEM users, which template to use and where to put datafiles are ...

  I initiated a  Datapump Import job at 11am.It took almost 30minutes to load all the tables but 8 hours later, the import log file shows that it's doing " Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX ",  so it means the import job has been hanging for almost 7.5 hours. Check dba_resumable view to see when the suspension happened SQL>select user_id,session_id, status, start_time, suspend_time,resume_time, error_msg from dba_resumable;  Check the error message. My error message was; ORA-01691: unable to extend lob segment XXXXXXXX by value in tablespace XXX   Solution:   SQL> alter tablespace XXX add datafile '/YOUR_PATH/XXX02.dbf' size 20M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED; You are good to go.  

When a client device tries to join a new network for the very first time, it must have a valid IP address to communicate. It first transmits a DHCPDISCOVER message on its local subnet. Because the client has no way of knowing the subnet to which it belongs, the DHCPDISCOVER is an all-subnets broadcast (destination IP address of 255.255.255.255, a layer 3 broadcast address) and a destination MAC address of FF-FF-FF-FF-FF-FF (a layer 2 broadcast address). The client does not have a configured IP address, so the source IP address of 0.0.0.0 is used. The purpose of  DHCPDISCOVER message is to try to find out a DHCP Server. After receiving the discover message, the DHCP Server dynamically picks up an unassigned IP address from its IP pool and broadcasts a DHCPOFFER message to the client device. DHCPOFFER message could contain other information such as subnet mask, default gateway, IP address lease time, and domain name server (DNS). In fact, the DHCPOFFER is...

Over the past two decades, the demand for wireless service has grown at an extraordinary pace. The industry has grown from pagers, and  cellular phones  to Personal Communication Systems (PCS) and wireless local area networks (WLANs), providing services that deliver voice, data, and video in real time.  For some time, wireless communications have been evolving from voice and low data rate services towards high bit rate services like video-telephony and multimedia). In addition, wireless-in-house communications with a high degree of mobility are also emerging rapidly. Wi-Fi Access Points are being installed in almost every conceivable location from public areas such as airports, coffee bars to private homes and even on the masts of boats. The performance of wireless communication systems depends on the radio wave transmission path between the transmitter and the receiver. Unlike their wired counterparts whose distance limitations and data rates are fully understood due ...

So you are running an impdp job and would like to monitor the progress,running this sql statement does the trick SQL>select t.username,t.TIME_REMAINING,t.ELAPSED_SECONDS,t.opname,t.target_desc,t.sofar,t.totalwork,t.message from V$SESSION_LONGOPS t where t.TIME_REMAINING !=0 ; USERNAME                       TIME_REMAINING ELAPSED_SECONDS ------------------------------ -------------- --------------- OPNAME ---------------------------------------------------------------- TARGET_DESC                           SOFAR  TOTALWORK -------------------------------- ---------- ---------- MESSAGE -------------------------------------------------------------------------------- SYSTEM           ...

sql> startup ORA-00845: MEMORY_TARGET not supported on this system Reason: /dev/shm   also known as tmpfs i.e. temporary file system which keeps all the file system in virtual memory to speed up several processes. Solution: Increase the size of /dev/shm Check the size of /dev/shm # df -h tmpfs         512M   76K   512M  1%     /dev/shm To increase the size # mount -o remount,size=3G /dev/shm Verify the size # df -h tmpfs       3G      1007M  2.1G   33%   /dev/shm To make these changes permanent, edit your /etc/fstab file # vi /etc/fstab tmpfs  /dev/shm  tmpfs  defaults,size=3G  0 0 Update the new fstab file # mount -a Startup the oracle instance SQL> startup ORACLE instance started. Total System Global Area  535662592 bytes Fixed Size             ...

Most of us use AVG, the third most popular antivirus product in the world according to expert market analysis. The antivirus company boasts about 9 percent share of the global market, 6 percent behind Avast and 13 percent behind Microsoft which stakes 23 percent of the market.[Source: OPSWAT] Recently, the company has announced a change in its privacy policy in which it boldly and openly admits that it will collect user details and sell them to online advertisers for the purpose of continuing to fund its free antivirus products. This new privacy policy is expected to come into effect as from 15 th October 2015 . Information expected to be collected includes: §   ID associated with user device §   Browsing and search history, including metadata; data that describes other data §   User internet service provider and/or mobile network §   Information regarding other user installed applications and how they are used The antivirus company stated that it would not sell per...