Nokia Codes..

• *3370# This Nokia code activates Enhanced Full Rate Codec (EFR) - Your Nokia cell phone uses the best sound quality but talk time is reduced my approx. 5%
• #3370# Deactivate Enhanced Full Rate Codec (EFR) .
• *#4720# Activate Half Rate Codec - Your phone uses a lower quality sound but you should gain approx 30% more Talk Time.
• *#4720# With this Nokia code you can deactivate the Half Rate Codec.
• *#0000# Displays your phones software version, 1st Line : Software Version, 2nd Line : Software Release Date, 3rd Line : Compression Type .
• *#9999# Phones software version if *#0000# does not work.
• *#06# For checking the International Mobile Equipment Identity (IMEI Number) .
• #pw+1234567890+1# Provider Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
• #pw+1234567890+2# Network Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols) .
• #pw+1234567890+3# Country Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
• #pw+1234567890+4# SIM Card Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols) .
• *#147# This lets you know who called you last (Only vodofone).
• *#1471# Last call (Only vodofone) .
• *#21# This phone code allows you to check the number that "All Calls" are diverted to.
• *#2640# Displays phone security code in use .
• *#30# Lets you see the private number.
• *#43# Allows you to check the "Call Waiting" status of your cell phone.
• *#61# Allows you to check the number that "On No Reply" calls are diverted to .
• *#62# Allows you to check the number that "Divert If Unreachable (no service)" calls are diverted to .
• *#67# Allows you to check the number that "On Busy Calls" are diverted to
• *#67705646# Phone code that removes operator logo on 3310 & 3330
• *#73# Reset phone timers and game scores.
• *#746025625# Displays the SIM Clock status, if your phone supports this power saving feature "SIM Clock Stop Allowed", it means you will get the best standby time possible .
• *#7760# Manufactures code.
• *#7780# Restore factory settings.
• *#8110# Software version for the nokia 8110.
• *#92702689# Displays - 1.Serial Number, 2.Date Made, 3.Purchase Date, 4.Date of last repair (0000 for no repairs), 5.Transfer User Data. To exit this mode you need to switch your phone off then on again.
• *#94870345123456789# Deactivate the PWM-Mem.
• **21*number# Turn on "All Calls" diverting to the phone number entered.
• **61*number# Turn on "No Reply" diverting to the phone number entered .
• **67*number# Turn on "On Busy" diverting to the phone number entered .
• 12345 This is the default security code .
• press and hold # Lets you switch between lines.

 

Cold backup in Oracle
Making a Cold Backup
A cold backup requires the database to be shut down. That means, as opposed to a hot backup, users cannot do anything on the database. So, first, SHUTDOWN the database (not a shutdown abort). Then copy all necessary files to a safe place. Those files are: The datafiles:
select name from v$datafile
The control files:
select name from v$controlfile
The online redo logs: Note, the online redo logs need not be backed up.
select member from v$logfile
The parameter file init.ora or spfile (The parameter file cannot be found using dynamic performance views) and the password file (if used). Also, some network configuration files such as the listener.ora, tnsnames.ora and sqlnet.ora might be backed up. Some might also want to backup the Oracle Software along with the inventory, the oratab file and startup scripts. Here is a shell script that shuts down the database, copies the files of the database to a safe place and then starts up the database again. After we have copied these files to a safe place, we can safely delete the archived redo log files.
Simulating Media Failure
create some tables, and insert something into the tables. And then delete the datafiles
create table after_backup (a number, b varchar2(40));
insert into after_backup values (1, 'before commit');
insert into after_backup values (2, 'also before commit');
commit;
insert into after_backup values (3, 'after commit');
Make sure to not commit this session until you delete the datafiles. Open another session instead and create a user or something.
create user user_after_backup identified by pw;
grant dba to user_after_backup;
Now, crash the instance and delete the database. Open the init.ora file at the backuped place and modify its control_file initializtion parameter to point to the backed up control files. Then startup mount pfile=c:\oracle\ora81\admin\backup\initadpdb.ora the database. Note, I am using the backed up initadpdb.ora file. After you've mounted the database, rename the datafile (so that they point to the new files):
alter database rename file 'C:\ORACLE\ORA81\ADMIN\ADPDB\SYSTEM01.DBF'
to 'C:\ORACLE\ORA81\ADMIN\backup\SYSTEM01.DBF';
Note: Online redo log files should never be backed up

Data guard

When you configure your database for datagaurd the start the database only with that pfile which has the configuration. Then you can work smooth in the database or else it will hangs unnecessary.