Oracle Net Services is the Communications and Network Component for Oracle Databases. It forms the glue that bonds the Oracle network together, it handles all the negotiations between the Client and Server or between multiple Oracle servers.

The Five Categories of networking solutions that Oracle Net Services address are:

Connectivity
Manageability
Scalability
Security
Accessibility

Connecting the Client to the Server
The main files used for configuring Net Services are:
Listener.Ora - Configure the Listeners
Tnsnames.Ora - Configure Remote Access and Name Resolution
SQLNet.Ora - Configure Network Connection Profiles

Host Naming
(No Client Configuration Required)
The user will supply their user id, password and the name of the host they wish to connect to. The requirements for Host Naming are as follows:
                TCP/IP Only
                External Resolution Service Required, i.e.: HOSTS / DNS
                The Listener must have it’s GLOBAL_DBNAME parameter set to the Machine Name
                No Advanced Features are available.

Oracle attempts to use Host Naming only after it fails to connect using Local Naming. This behavior can be overridden in the Sqlnet.Ora file, by altering the NAMES.DIRECTORY_PATH parameter. Below is an example of connecting using Host Naming:

                >SQLPLUS steve/letmein@myoracleserver

Easy Connect Naming
(No Client Configuration Required)
Connect to Oracle without using a configuration file by using a connection string in this format:

                CONNECT username/password@Hostname

There is an optional port number and service name that can be added to the end of this string. As with Host Naming this is TCP/IP only and advanced features are not available. By default this is the method configured when Oracle Net is installed. Below is an example of connecting using Easy Connect Naming:

                >SQL>CONNECT steve/letmein@myoracleserver:1522/testservice.com

Easy Connect naming was introduced with Oracle 10g. This resolution method is automatically configured when Oracle Net is installed.

Local Naming
(Requires Client Configuration)
The configuration exists in the TNSNAMES.ORA file on the client machine in the location pointed to by the environment variable TNS_ADMIN. This is traditionally the most used method of connecting to an Oracle database.

External Naming
(No Client Configuration Required)
This is where you use a non Oracle facility to manage and resolve the Oracle Service Names. NIS (Network Information Services) is one such external name resolution service. This is then accessed by the client to resolve service names.

Oracle Internet Directory
(No Client Configuration Required)
If you are dealing with complex networks with many Oracle servers then OID is the method you should use. All Net Service Names and Connect Descriptors are configured in one central location. OID is a Lightweight Directory Access Protocol (LDAP) compliant server.

Oracle Connection Manager - A middleware solution for:
                                Multiplexing
                                Network Access
                                Cross Protocol Connectivity

Oracle Advanced Security:
                                Encryption / Checksums
                                Authentication
                                Single Sign On
                                Kerberos (Sharing of a Single Secret Key)

Configuration Files:
                                Profile:                        sqlnet.ora
                                Service Naming:        tnsnames.ora
                                Listeners:                        listener.ora
Listeners
There can be multiple listeners, but only one LISTENER.ORA
Multiple listeners are used for failover and load balancing purposes.
The default listener name is LISTENER.
Listeners can be configured by Oracle Net Manager.
When the listener is on the same server as the instance the connection is called a DIRECT HANDOFF or BEQUEATH CONNECTION.
Listeners must have unique names and listen on different ports.
Listener Trace Levels:
        Off
        User
        Support
        Admin
To refresh the changes made to LISTENER.ORA the listeners must be reloaded:

        >LSNRCTL RELOAD

You can use the keywords SHOW and SET at the LSNRCTL command line.

Transparent Application Failover:
        List 2 x Hosts
        FAILOVER=ON
        (Both in TNSNAMES.ORA)

Load Balancing:
        LOAD_BALANCE=ON
        (TNSNAMES.ORA)

Common Time-out errors when connecting to the host:
        ORA-12535
        ORA-12547
        (Try setting INBOUND_CONNECT_TIMEOUT to a higher value)

FAILOVER:
Try each address in order until one succeeds
FAILOVER LOAD BALANCING:
Try each address randomly until one succeeds
LOAD BALANCING:
Try one address, selected at random
SOURCE ROUTING:
Use each address in order until the destination is reached

RSS Feed: http://feeds2.feedburner.com/Lonelyhacker

Tags: Oracle, Technical

Today Arten Science announced it’s R10Office CRM and Productivity Suite designed specifically for Individuals, Clubs, Groups and Small Businesses. The R10Office Suite will let you Store, View, Interact and Communicate with your Contacts, Customers, Prospects, Network and Suppliers more easily and efficiently than ever before.

The R10Office CRM and Productivity Suite consists of four applications that cover Contacts, Todo/Task Management and Digital Filing, Bulk/Batch Email Marketing and Award Winning Encryption. Each of the four R10Office applications are available separately but really come into their own when used as a suite. The suite consists of:

ContaX CRM: Build Relationships. Reap the Rewards. Effective CRM.
ooSooM: The Todo Manager You've Been Waiting For.
R10BatchMail: Bulk Email. Done Right.
R10Cipher: Security For Everyone.

System Features:
* Supplied as Universal Binaries for Mac OSX including Snow Leopard
* Windows Version works on XP, Vista, 2003 and 7
* Easy to use, Modern, Clean Interface
* Requires No Installation
* No Modifications made to your computer outside of the R10Office folder
* To 'uninstall' - Just delete the R10Office folder
* Requires no additional Runtime installation
* Can be run from a USB drive
* Online Help System
* Support Forum
* Sync the Databases with iDisk, DropBox or Similar

Benefits:
* More Effective Sales Calls
* Increased Sales through Repeat Business from Past Customers
* Improved Ability to Provide a Higher Level of Customer Service
* Greater Customer Satisfaction because you Understand their Unique Needs
* Enhanced Communication
* View your Contact History
* See your Contacts by Geographical Spread
* Visual Relationship Views
* Graphs and Charts show your Contact Database Visually
* Accurate Contact Records
* Keep your Contacts up to date with targeted eMail
* Send Encrypted Email, for example Staff Reviews
* Transfer and Store Encrypted Documents, for example Financial Information
* Use for Backup, Zip your files then Encrypt the Zip with R10Cipher
* Secure Peer to Peer, End to End Encryption
* Store information and files safely on your Laptop
* Store Patients Records and Health Data
* Archive Research Documents

Testimonials:
"R10BatchMail is brilliant - easy to use, intuitive and very useful - you can make targeted email campaigns with ease in whatever html editor you find easiest - it's a MUST for all web designers who want to add extra marketing thrust to their portfolio of products. I can't wait to see how the product develops in the future." - Mitch Stone IDM Design

"Our custom ArtenSUITE module is fantastic for our company needs - Arten Science not only create our software, they maintain our data - always available and reliable. I could not recommend them more highly." - Chris Fanthom Managing Director, TMS Limited

"R10Cipher is a fantastic cross platform tool which has given us the peace of mind that our patient sensitive research data can be transmitted electronically in a secure manner on site or with collaborators around the world. The ability to encrypt and attach files to emails or simply encrypt the email text between Apple Macs and Windows PCs without the need for complicated software installations means that our users are happy to use this great bit of software. The developer's proactive approach to their software development requesting and rapidly incorporating users feedback has turned a good encryption tool into and excellent one." - Paul McGrath, Computer Manager, Cancer Research UK Clinical Centre

Minimum Requirements:
* Mac OS X Version 10.4 or higher
* Windows XP / Vista / Window 7
* Universal Binary for PowerPC and Intel
* G4 Processor, 1GHz or faster
* 140 MB Hard Drive space

Pricing and Availability:
R10Office is available now at the introductory price of £79GBP ($135USD) for a Single User license. Corporation Site Licenses and Educational licenses are available, contact us for further details. A 30 Day Trial version of ContaX, with no functionality restrictions can be downloaded. Any data entered during the trial period can be carried forward into the full version if purchased.


R10Office
30 Day Trial
Purchase R10Office
Movie
Screenshot

Steven Cholerton
Arten Science

Subscribe to our RSS Feed: http://feeds.feedburner.com/ArtenScienceRssFeed

Tags: R10Office, Productivity, CrM, R10BatchMail, R10Cipher, OoSooM, ContaX, Software News, Software Release