Archive for the ‘TEChNoLoGY’ Category

Mobily Telecom Services : Credit Transfer

March 27th, 2017, posted in Kingdom, MOBiLE
FacebookTwitterGoogle+Share

Mobily was the trade name of the brand which was launched initially on May 2005 by the second largest telecommunications company in Saudi Arabia, Etihad – Etisalat Consortium. Mobily Telecommunication Company was the winning bidder for the second GSM license in Saudi Arabia in 2004. The company has been aimed to provide mobile telecommunications serviced around the country, which caused the monopoly of telecom companies in the wireless business in the Kingdom of Saudi Arabia to break. Mobily Telecom Company had launched their 3.5G and 4G services in 2006 and 2011 respectively.

Mobily Telecom Services Credit Transfer,Mobily Telecom Services,Credit Transfer,Mobily,stc,Saudi Arab,KSA,Mobile Credit Transfer

Since a high number of people in the Kingdom use Mobily telecom services, we have given below, the complete step by step procedure to transfer Credit (Balance) from one Mobily user account over to another Mobily user account. Firstly we will discuss what actually Transfer of Credit (Balance) is. All of the active prepaid subscribers to the Mobily telecom services are able to independently transfer a certain amount of Credit (Balance) or balance to other prepaid customers on the Mobily Telecom network. With the help of the Credit (Balance) transfer service offered by Mobily Telecom, you can also now show to your family and friends that you do care about them when they happen to run out of Credit (Balance), by transferring some over to them, in a moment’s notice. Below are different methods in which prepaid Mobily users can send Credit (Balance) to other users:

 

  1. First Method – Dial *123# and press dial. The call will be connected to an automated interactive menu which will guide you to enter the mobile number of that recipient who you wish to transfer the Credit (Balance) to, and also the amount of Credit (Balance) which you want to transfer to the other user. After this is done, the recipient of the Credit (Balance) transfer will receive an SMS of confirmation in which they must enter their ID numbers and send to 611311 in order for the transaction to be completed.
  2. Second Method – Dial *123* followed by the mobile number, followed by another * and then the amount of the Credit (Balance) transfer and finally # and press dial. The recipient of the Credit (Balance) will have to enter their ID number within a time period of 24 hours after receiving the notification; otherwise the transaction will be cancelled. When the transaction is complete both parties will receive a confirmation message of the transaction.

There are some rules and regulations which must be followed :

  1. The sender of the Credit (Balance) must have enough Credit (Balance) to transfer to others.
  2. Currently the service is only available to prepaid users.
  3. No limit has been set on number of transfers per day
  4. The maximum amount per transaction is set at SAR 20, while the minimum is set at SAR 5.
  5. The amount of the Credit (Balance) transfer must be in multiples of 5, i.e. 5, 10, 15 and 20 SAR.
  6. Recipients have three tries within the 24 hour period to enter their accurate ID number in order to access the funds. In case of non compliance, the Credit (Balance) will be transferred back to the sender.
FacebookTwitterGoogle+Share

How To Upload Excel/Text File Data Into Oracle Table Using TOAD

February 27th, 2017, posted in Oracle
FacebookTwitterGoogle+Share

n this we will explain how to put Excel or text file data into an Oracle table. You can do this easily in SQL Server with a Copy (Ctrl+C) of the data from Excel then open the target table into edit mode and Paste (Ctrl+V). Done.

But this will not work in Oracle.

In an Oracle database you can do it using the import command. I will show you each and every step with snapshots.

Step 1 : Open TOAD.

Step 2 : Write the following query to create a test table:

  1. Create table TESTTABLE
  2. (
  3. NAME varchar2(20),
  4. Address varchar2(100),
  5. RollNo integer
  6. )

Step 3 : Now my table is ready. It’s time to create the data in an Excel file.

Step 4 : Go to Database -> Import -> Table Data.

Step 5 : Select the table you want to import the Excel data to.

Step 6 : Click on show data. Now execute the data button to enable the use. Click on that.

Step 7 : After clicking on Execute Wizard the following screen will open:

Next ->

Step 8 : Now, browse to your Excel file – > Next ->

Next ->

Step 9 : Choose the sheet and click on AutoMap. The AutoMap button will automatically bind your Excel sheet column data with the Oracle table column.

Next ->

Next ->

Here your Excel data has been bound with the table columns. Next ->

Step 10 : Click on Execute to finish the process. It may ask for sheet selection. Click on Okay with the desired sheet.

Here is your uploaded data:

Step 11 : Commit the Task by clicking on the commit button.

Using the preceding procedure you can easily import Excel data. You can also import text flat files data. All steps are nearly the same. The only change is the following step. In this import I need to choose the separator for the flat file. Apart from any separators you can use fixed width. In the attached example I used a comma separator.

I think the procedure is very clear with snapshots. If you have found any mistake in concept, please do comment.

Your comments will make me perfect in the future.

Thanks for reading.

 

FacebookTwitterGoogle+Share

Refresh Materialized View

February 16th, 2017, posted in Oracle
FacebookTwitterGoogle+Share

Problem sys@standby> startup mount; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2217952 bytes Variable Size 490735648 bytes Database Buffers 335544320 bytes Redo Buffers 6606848 bytes Database mounted. sys@standby> alter database recover managed standby database using current logfile disconnect; alter database recover managed standby database using current logfile disconnect * ERROR at line 1: ORA-01153: an incompatible media recovery is active Cause This indicates a currently running media recovery process. Action sys@standby> alter database recover managed standby database cancel; sys@standby> alter database recover managed standby database using current logfile disconnect; Note When shutting down physical standby database, firstly turn off media recovery process. Otherwise the next time when starting up redo apply again, you will encounter error ORA-01153.

Refresh Materialized View

NAME: Refresh Materialized View
SHORT CODE: OZFEARNMV
MODULE: Oracle Trade Management

Description: Refresh Materialized Views for Promotional Payments and Indirect Inventorty Tracking
Navigation: Oracle Trade Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • mv_name : Name of the Materialized View
FacebookTwitterGoogle+Share

Replacing MacBook Batteries

February 4th, 2017, posted in Apple
FacebookTwitterGoogle+Share

Replacing MacBook Batteries

The battery life of an Apple MacBook is something that PC laptop users dream about. It’s normal for MacBook Air users to get 12 hours on a single charge, and MacBook Pro users should get several hours, even if the laptop is a few years old. But, the battery life will get worse over time. There is nothing that anybody can do to prevent that. The issue comes when it is time to replace the battery. They are not designed to be replaceable by members of the public, which makes some people think that they are not replaceable at all.

That’s not true. The battery in a MacBook, whether it’s a MacBook Pro or Air, can be replaced with a new model and many more years use can be had.


How to tell if you need a new Mac battery

The fastest way to check if your MacBook is in need of a new battery is to open System Profiler. This is located in Applications > Utilities and can also be accessed by going to the Apple menu > About This Mac > More Info. Click on the Power section in the list and you’ll find information like the cycle count and condition rating. The condition rating can be “Normal”, “Replace Soon”, “Replace Now”, or “Service Battery”. If your battery is listed as anything except, Condition: Normal, then you should replace your battery.


How to access information about your Mac battery:

  1. Your first step will vary depending on which version of Mac OS X you are using:
    • OS X Snow Leopard v10.6.8 or earlier: Open Apple System Profiler by choosing “About this Mac” from the Apple Menu. Then, click More Info.
    • OS X Lion v10.7 or later: Open System Information by choosing “About this Mac” from the Apple Menu. Click System Report.
  2. Click Power in the Contents list (under the Hardware section as shown below).


Battery Cycles

Use of your MacBook battery is counted in the form of charge cycles. A charge cycle means using all of the battery’s power, but that doesn’t necessarily mean a single charge. For instance, you could use your MacBook for an hour or more one day, using half its charge, and then recharge it fully. If you did the same thing the next day, it would count as one charge cycle, not two, so it may take several days to complete a cycle.

Batteries have a limited amount of charge cycles before they are considered to be consumed. Once consumed, a replacement battery is recommended. You can use your battery after it reaches its maximum cycle count, but you may notice a reduction in your battery life. Knowing how many charge cycles are on your battery and how many are left can help you determine when a battery replacement is required. For optimal performance, replace your battery before you reach the maximum cycle count.


Computer

Maximum Cycle Count

MacBook

MacBook (13-inch, Mid 2010)
MacBook (13-inch, Late 2009)
1000
MacBook (13-inch Aluminium, Late 2008) 500
MacBook (Mid 2009)
MacBook (Early 2009)
MacBook (Late 2008)
MacBook (Early 2008)
MacBook (Late 2007)
MacBook (Mid 2007)
MacBook (Late 2006)
MacBook (13-inch)
300

MacBook Pro

MacBook Pro (Retina, 13-inch, Late 2013)
MacBook Pro (Retina, 13-inch, Early 2013)
MacBook Pro (Retina, 13-inch, Late 2012)
MacBook Pro (13-inch, Mid 2012)
MacBook Pro (13-inch, Late 2011)
MacBook Pro (13-inch, Early 2011)
MacBook Pro (13-inch, Mid 2010)
MacBook Pro (13-inch, Mid 2009)
MacBook Pro (Retina, 15-inch, Late 2013)
MacBook Pro (Retina, 15-inch, Early 2013)
MacBook Pro (Retina, Mid 2012)
MacBook pro (15-inch, Mid 2012)
MacBook Pro (15-inch, Late 2011)
MacBook Pro (15-inch, Early 2011)
MacBook Pro (15-inch, Mid 2010)
MacBook Pro (15-inch, 2.53 GHz, Mid 2009)
MacBook Pro (15-inch Mid 2009)
MacBook Pro (17-inch, Late 2011)
MacBook Pro (17-inch, Early 2011)
MacBook Pro (17-inch, Mid 2010)
MacBook Pro (17-inch, Mid 2009)
MacBook Pro (17-inch, Early 2009)
1000
MacBook Pro (15-inch Late 2008) 500
MacBook Pro (15-inch, Early 2008)
MacBook Pro (15-inch, 2.4/2.2GHz)
MacBook Pro (15-inch, Core 2 Duo)
MacBook Pro (15-inch Glossy)
MacBook Pro (15-inch)
MacBook Pro (17-inch, Late 2008)
MacBook Pro (17-inch, Early 2008)
MacBook Pro (17-inch, 2.4GHz)
MacBook Pro (17-inch Core 2 Duo)
MacBook Pro (17-inch)
300

MacBook Air

MacBook Air (11-inch, Early 2014)
MacBook Air (11-inch, Mid 2013)
MacBook Air (11-inch, Mid 2012)
MacBook Air (11-inch, Mid 2011)
MacBook Air (11-inch, Late 2010)
MacBook Air (13-inch, Early 2014)
MacBook Air (13-inch, Mid 2013)
MacBook Air (13-inch, Mid 2012)
MacBook Air (13-inch, Mid 2011)
MacBook Air (13-inch, Late 2010)
1000
MacBook Air (Mid 2009) 500
MacBook Air (Late 2008)
MacBook Air
300
FacebookTwitterGoogle+Share

ORA-0131 Insufficient privileges

December 11th, 2016, posted in Oracle
FacebookTwitterGoogle+Share

ORA-0131: Insufficient privileges,ORA-0131,Insufficient privileges,ORA 0131,ORA Error, Insufficient, privileges,DEBUG CONNECT SESSION,system privilege,Debugging requires the DEBUG CONNECT,ORA Debugging,ORA Debugging,ORA Debugging requires,Oracle APPS DBA,ORACLE DBA,ORACLE DB,
Title :
Getting “ORA-01031: insufficient privileges” error when trying to Debug.

Description :
When trying to debug a procedure, package, etc., the following error messages are received:

ORA-01031: insufficient privileges

Cause :
The Oracle user or schema account does not have the required Oracle rights to debug an object.

Resolution :
Ensure the User or Schema has all the required Oracle privileges granted for debugging objects on that database.

1. connect as sysdba
2. exec the sql:
 grant debug connect session to XXXXXX;

or
grant DEBUG ANY PROCEDURE to XXXXXX;;

FacebookTwitterGoogle+Share