Everytime asking for Admin Password whenever trying to install any software in the Windows7 Machine

I have face this many times and I want to share the solution of it . Sometimes you have also the same problem i.e asking or prompt for enter the admin password, every time you are going to install anything in your system even if audio and video installer and it's very frustrate.

I am telling you the instruction which will solve your problem.

I am sure after disable the User Access Control (UAC), you won't ask for permission for install the software in the system.

1. Open the User Account Control Settings by clicking the start button

2. Click on Control Panel . You will find a search box on the right top side of the window page.

3. Type uac in the search box as shown in the below picture and it will generate the Action Center page for you.


4. Click on Change User  Account Control Settings and it will take you the " Change when to be notified about changes to your computer" page .Now you can see in the below picture it is in the Always notify position and check the status of it (Program try to install software or make changes to my computer needs the admin credentials)
 

5. You need to make it Never Notify.

Do one of the following:

    1) To turn off UAC, move the slider to the Never notify position, and then click OK. If you're prompted for an administrator password  confirmation, type the password provide confirmation. You will need to restart your computer for UAC to be turned off.

2) To turn on UAC, move the slider to choose when you want to be notified, and then click OK. If you're prompted for an administrator password confirmation, type the password  provide confirmation.

How to disable voicerite client from the IBM Lotus notes.

If you are a user of IBM Lotus notes as your mail server then might be many times you got an message " Voicerite Client is Logging off,please wait to close the Notes" .

Or whenever you get logined into the Notes the Voicerite is also get logedin with it automatically.

Then how to get escape from it.

Here are the steps need to follow to disable it manully.

1. In your Lotus Notes go to File ---> Application-----> Application Management

2.  Expand the Path: C\notes\framework\shared\eclipse from the mentioned paths

3. Scroll down and select the VoiceRite entry(entries) and then click Disable link under Available Tasks.

If not (if you are not found the VoiceRite entry )

4.  Disable the Voicerite Entries from the below two in the available Tasks

   - VoiceRite Client Features 3.8.17

   -  VoiceRite Client VoiceSuite Features 1.0.7

5. Restart the system to see the effects.

You are done.


Thanks and have fun....

 

What is DB LINK and How To create the DB Link in the Oracle

A DATABASE  LINK is a schema object in one database which helps to access the object on another database. The other database may be other than the Oracle Database.  In another definition it can also be said that , it is a media to communicate with the databases not in in the same database really(It may be also different too). The only condition here is to access the non-Oracle Database System you need to have the Oracle Heterogeneous Services.

It's like on logical database. You can do all kind of database activities  (DDL,DML,TCL.TQL) on the database.

Once you have created a database link, you can use it to refer to tables and views on the other database. In SQL statements, you can refer to a table or view on the other database by appending @dblink to the table or view name. You can query a table or view on the other database with the SELECT statement. You can also access remote tables and views using any INSERT, UPDATE, DELETE, or LOCK TABLE statement.
Also creates a connection between a local database and a remote database. You might want to create a database link, for instance, if you want the data in a remote database updated when the local database is updated.

Division of the Database Link:

Private Database Link: It can be used by the owner of the database link and can be limited to some specific databases only.

Public Database Link: All user in the database can use it.

Global Database Link: Defined in an OID and Any other in network can use it.


 Basic requirment need be there before you are going to create a DB Link.

1. You need to have the previleges to create the DB Link. Usually DBA's are have this previleges. Same for Public Database Link we need to have the previleges otherwise you cann't .

Action1:
Creation of the DBLINK:


                      
Where other_db is the other database to which you might want to connect from the oracle database.
scott/tiger - The schema and password respectively.

You can check also whether the datalink has created or not by writting the below command :




 Action2:  Dropping a DB Link

DROP DATABASE LINK link_name;

Action3: Viewing inforamtion about database link

DBA_DB_LINKS: It will list all the database link in the database.
ALL_DB_LINKS: It will list out all those accesible datalink to the connected users.
UAER_DB_LINK: Database links owned by the connected users.

Action4: Close the DB Link


  


Refer For more knoweledge

Important link:     http://searchoracle.techtarget.com/tip/How-to-create-a-database-link-in-Oracle

What is SID and TNSN names.ora in Oracle

SID stands for System Identifier and which is unique for each database ,to which we are connecting and also unique in the TNS.ora File.

TNS Stands for Transparent Network Substrate. via wchich system connects to the database. It hepls to distribute the communication media between the databases. It's the tnsnames.ora which governs the TNS.

TNS File contails the following Information:

1. TCP( Transmission Control Protocol)
2.  Port Number ( 1521: Mostly used by the oracle)
3. HOST IP Address ( where the database gets  resided)
4. SID
5. SERVER NAME.

TNS is  used whenever there are hetergenous colection of protocol in the network.

 The locaton of the .ora file is .....\oracle...\Network\admin

The Parameters like SDU( The session data unit) and TDU(Transport Data Unit) are located in the tnsname.ora file.  SDU defines the size of the packet can be send in the network but not from the Maximum Transmission Unit(MTU). Therefore it is always recommend that SDU shoud be set equal to the size of the MTU because we don't want to waste network resources by transport wasted spaces in each packet.

All the below neccesary things need to be configure in the tnsnames.ora file to connect the system with the database.



The tnsnnames.ora file is located in both client and server systems. And need to configure in both the sides.



Thanks.....Have Fun..