Configuring Naming Methods. This chapter describes how to configure connectivity information for client connections to the database server.
This chapter contains the following topics: 8.1 Using the Easy Connect Naming Method The Easy Connect naming method eliminates the need for service name lookup in the tnsnames.ora files for TCP/IP environments. In fact, no naming or directory system is required if you use this method. This naming method provides out-of-the-box TCP/IP connectivity to databases. CONNECT username@[//]host[:port][/[service_name][:server]][/instance_name]] Enter password: password The connect identifier converts to the following connect descriptor: (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=host)(PORT=port)) (CONNECT_DATA= (SERVICE_NAME=service_name) (SERVER=server) (INSTANCE_NAME=instance_name))) If you installed Oracle Database in Typical mode, then the default service name used by the oracle instance is ORCL, and the following Easy Connect syntax can be used to connect to that instance: Note: Oracle Express Edition - Plip's Weblog. Well, I started on my learning journey, and the first victim of my learning was Oracle.
I opted for the Express Edition, mainly because it's free (well I'm not paying to learn it!). This post is in the guise of me learning, so much of my assumptions may not be true and I emplore those of you that know better to correct me. Also it's coming from a chap who's only ever used SQL Server, so look at is as Oracle Eye for the SQL Guy (as it were - not sure that show would really take off!). Aims Installation and Configuration. Installation and Configuration After downloading the OracleXE (Express Edition - oh how the Marketing Department must have cheered when they came up with that name), I dragged it across onto a specific Virual Machine (Windows XP Professional) I'd created just for Oracle.
Once installed a new entry had appeared in my Program Files and a Desktop shortcut to Get Started with Oracle 10g Express Edition had appeared on the desktop. Understaning Oracle's Terminology Can I hell. Creating an Oracle (XE) database manually on XP. There are two ways for creating an Oracle database, one is using Oracle Database Configuration Assistant and the other is manually, I'll provide a small step by step guide for the latter on windows XP.
This are the main steps: 1. Create the directory structure2. Declare an oracle SID name.3. Create a windows service and password file4. 1. Under the admin directory C:\oraclexe\app\oracle\admin\) Using the this command we declare the variable for oracle SID. Set ORACLE_SID=oraXE 3. Every instance on windows requires a windows service which can be created using oradim tool, the created service can be checked in the services list: type services.msc in the console or a link can be found in the control panel -> admin tools -> Services.
Oradim -new -sid %ORACLE_SID% -intpwd passwordhere -startmode M 4. Database 10g Express Edition. Free to develop, deploy, and distribute Oracle Database 11g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base.
It's free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database for: Developers working on PHP, Java, .NET, XML, and Open Source applications DBAs who need a free, starter database for training and deployment Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge Educational institutions and students who need a free database for their curriculum With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations. Support is provided through a free Oracle Discussion Forum monitored by Oracle employees as well as community experts.