TECHNOLOGY TODAY

Oracle BI Scheduler Error: [nqSError:76015]. The active Oracle BI Scheduler instance in the cluster could not be determined This solution applies to Oracle Business Intelligence Server Enterprise Edition - Version 11.1.1.7 and later The above error appears when a user is unable to save and edit an iBOT/Agent job This is because the data source details are incorrect and not matching with the data connection from tnsnames.ora file To resolve the error, 1.        Log in to Enterprise Manager 2.        Navigate to coreapplication 3.        Open the Deployment tab and navigate to scheduler 4.        Lock and Edit configuration 5.        Copy connection details from tnsnames.ora file NB Don’t include the TNS alias, only copy the connection string after the equal (=) sign. Spaces are OK: For example: (DESCRIPTION=(ADDRES...

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             ...