Oracle Applications Dba Covers 11i And R12 Pdf Download UPDATED

Oracle Applications Dba Covers 11i And R12 Pdf Download

Concerned about risks and want to lock down your Oracle client for end user Windows PCs?

Have a demand for the 'cantankerous connection query' feature of Toad Data Betoken? The solution is within your grasp!

Allow'south get straight to it. You lot need an Oracle client to access an Oracle database from Toad Data Point. Let me share my stride past step didactics in an easy-peasy-lemon-squeezy fashion!

Note one:  Oracle customer is needed to admission multiple data sources from Toad Data Point referred to as a 'cross connection query'.

Note ii:  This example will detail an Oracle 12c 64 scrap install on Windows ten for an Oracle 12c example with a PDB.

Notation 3:  The Oracle 11g client install is about exactly the same every bit the Oracle 12c client install.

here are five steps to this process which include:

i)      Pick your Oracle client

2)      Install the Oracle client

three)      Disable sqlplus

4)      Review registry entries

5)      Configure Toad Data Indicate Oracle Connection

Recommendation is to review all steps before proceeding.  In particular, Footstep 4 Review registry entries consisting of earlier and after screen shots.  Trust me, you lot volition feel better, empowered, and more than confident in the cease!

Step 1 – Option your Oracle client

Your options within the scope of this article are an Oracle 11g or Oracle 12c customer for 32 or 64 chip architecture. Consult the Oracle website for other client versions as needed.

Oracle 12c client (32 and 64 fleck) can be found hither:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html

Oracle 11g 32 bit client can be found here:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

Oracle 11g 64 bit client can exist found hither:

http://world wide web.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Pay Attention Note 1:  Be careful which Oracle client you lot choose. If the intent is to use the Oracle client for other uses besides Toad Data Point, BE FOREWARNED some legacy systems volition merely piece of work with a 32 bit Oracle client. Please understand your environment before choosing an Oracle customer.

Toad Data Point volition work seamlessly with either the 32 or 64 fleck Oracle 11g or Oracle 12 customer.

Pace 2 – Install the Oracle client

Locate the downloaded Oracle 12c 64 scrap client goose egg file.

Right click on file and extract into a directory.

Enter a directory to excerpt files.

Click Excerpt. Notation:  This could accept a few minutes.

Working…

Oracle 12c 64 bit client has now been extracted

Double click 'setup.exe'.

This may exam your patience, permit it piece of work! (Sometimes a minute or less tin seem like an eternity).

Don't touch anything!

Pay Attention Note 2: Critical decision time now! The default is the 'Instant Client' which will allow for Oracle connections to one Oracle database at a time. If your users demand the Toad Information Point 'cross connectedness query' feature (almost will) DO Not install the 'Instant client'.

Pay Attention Note three: Choosing the 'Runtime' option will eliminate whatsoever Oracle client Administrator tools enabling LOCKDOWN and saving 0.4 GB of local finish user Windows PC deejay space. Toad Information Signal 'cross connectedness query' characteristic will nevertheless work. Stay with me and continue to follow the instructions.

Choose the 'Runtime' option.

Click Next.

Cull language.

Click Next.

Accept the defaults – my preference.

Or change to reverberate your own environment.

Click Next.

Working…

Relax, the Prerequisite Cheque should complete successfully momentarily. If non, check the log files and right as directed.

Accept the default Windows Congenital-in Business relationship – my preference.

Click Adjacent.

Verify Global Settings. No changes should be required at this point.

My preference is to not save the response file.

Option:  Click 'Salve Response File'. A screen will appear to enter a filename to record the install responses.  Utilize this choice if you are having issues installing the Oracle Client. Response file log entries volition aid in debugging any bug that may occur. Rarely have I seen any issues during this office of the Oracle 11g/12c client install.

Click Install.

Be patient, the process is working.

Pay Attention Notation four: The default is 'Public networks, such every bit those in airports and coffee shops …'.  Depending on your local JAVA implementation, y'all may or may non get this message. If you practice, it is HIGHLY RECOMMENDED to Modify the default to 'Private networks, such as my home or work network'.

Click Permit Access.

Success!!  Political party time!

You have now just installed the Oracle 12c 64 bit client!

Click Close!

Step 3 – Disable sqlplus

The sqlplus.exe installed with the Oracle client opens the door for admission to Oracle databases.

To reduce risk exposure delete or rename the sqlplus.exe file in the directory where the Oracle 12c client was installed.

This is the final LOCKDOWN step in this article.

Let'due south review.

1. The Oracle 12c client has been installed with the 'Runtime' option thus eliminating any Administrator tools.
2. The sqlplus.exe file has been deleted or renamed from the client figurer.
3. The Oracle 12 client has now been installed lightweight and securely but still providing all the functionality required for connecting to Oracle databases.
4. Toad Information Point users tin can at present use the 'cantankerous connectedness query' characteristic when connected to an Oracle database.

Yous have past the one-half way point, simply two steps go!!!

Pace iv – Review registry entries

Start the Windows registry editor.

Purpose of reviewing registry entries is to empathise the centre of where the Oracle client is setup for Windows.  It is highly recommended non to alter any registry entry values for the Oracle client.

                          BEFORE                        Oracle Client Install
            HKEY_LOCAL_MACHINE                        -->                          SOFTWARE -->                          ODBC                      

                          Earlier                        Oracle Client Install
            HKEY_LOCAL_MACHINE -->             SOFTWARE -->            Oracle                      

This PC has an Oracle database instance running.  This would be highly unusual for an end user. The KEY_OraDB12Home1 is the Oracle database home.

                          AFTER                                      Oracle Client Install            
HKEY_LOCAL_MACHINE -->SOFTWARE -->            ODBC          

                          Afterward                        Oracle Client Install
            HKEY_LOCAL_MACHINE -->             SOFTWARE                        -->                                          Oracle                      

Step five – Configure Toad Data Point Oracle Connection

After installing the Oracle client, setting upward a TNS entry is recommended. It'due south easy – permit me show you!

Ooooh, the magic TNS_ADMIN surround variable.  Many people forget this footstep which can cause chaos and mayhem.

Start, create the tnsnames.ora file which tin can be placed anywhere on a customer Windows PC.

My preference is to identify the file in the Oracle 12c customer directory structure every bit shown below.

Create a file called tnsnames.ora with your specific database connection information similar to the examples below. There are many dissimilar and right means to specify a tnsnames.ora entry. Consult with your Oracle DBA for TNS entry information specific to your Oracle environment.

Oracle 12c with CDB/PDB configuration

PDB2 =
  (DESCRIPTION=
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA=
      (SERVER = dedicated)
      (SERVICE_NAME = pdborcl)
    )
  )

Note:  The CDB/PDB tnsnames entry volition require an entry into the listener.ora file like to this:

    (SID_DESC =
      (GLOBAL_DBNAME = pdborcl)
      (SID_NAME = pdborcl)
    )

Oracle 11g or Oracle 12c (No CDB/PDB) standalone database

DEV.ABC.NETWORK=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=server01.abc.network)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SERVER=dedicated)
      (SID=dev)
    )
  )

Instance of a tnsnames.ora file and location

C:Usersgrego>cd C:appclientgregoproduct.i.0client_1networkadmin              
 C:appclientgregoproduct.1.0client_1networkadmin>
C:appclientgregoproduct.one.0client_1networkadmin>type tnsnames.ora                
PDB2 =
  (Description=
    (Address = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA=
      (SERVER = defended)
      (SERVICE_NAME = pdborcl)
    )
  )
C:appclientgregoproduct.1.0client_1networkadmin>
            

Now let's go create the TNS_ADMIN environment variable!!

Click 'Advanced system settings'.

Click 'Environment Variables'.

In this instance, the TNS_ADMIN environment variable does not exist in the list above. We demand to create a TNS_ADMIN variable and betoken it to the tnsnames.ora file created before.

If the TNS_ADMIN surroundings variable already exists the PC has already been configured. Consult with a DBA before modifying to ensure other applications will not exist affected.

My preference is to put this variable at the organisation level in the event another user account on this Windows PC requires access to Toad Data Point via the Oracle client.

Click 'New' in the 'Organization variables' box equally shown above by red arrow.

Enter the Variable Proper name as TNS_ADMIN.

Enter the path to the tnsnames.ora file every bit

              C:appclientgregoproduct.1.0client_1networkadmintnsnames.ora.

Click OK.

Awesome!  TNS_ADMIN variable has been created!

Click OK and leave all the mode out of 'Advanced system settings'

Now all the effort volition pay off!

Launch Toad Information Bespeak and we will at present create a Toad Data Signal Oracle connexion!!!

There are several ways to fix an Oracle connection. This is one of the most straight forwards methods.

ane-Click on the 'Connection' card icon. A screen with many connectedness types volition announced.

2-Choose 'Oracle' as indicated above.

From the dropdown list choose the entry of the database you desire to connect to.

Choosing PDB2 in this example.

Enter User, for case hr.

Enter Password.

Click 'Save Password' box – my preference for simplicity merely could be a security risk.

Click the Advanced tab – my preference simply optional.

There is no requirement to specify a 'Category' of the connection. Information technology is perfectly fine to 'Click Connect' from either the 'Advanced' or 'Login' tab.

Click on the 'Category' dropdown and choose appropriate surroundings.  'Development' – my preference.

Optionally – Click 'Connect on Startup', my preference is NOT to check this box. Unnecessary open connections eat valuable resource.

Click 'Connect'.

Yous did information technology!!!

Congratulations on completing an Oracle 12c client install and setting up a Toad Data Signal Oracle connection!

All done. Q.Eastward.D.

Celebration time now!!!

TOAD World Maven

Gregory P. Martin

Elevation Racing Equipment

Email Piece of work: gmartin@summitracing.com

E-mail Dwelling house:  gregory.x.martin@gmail.com

Most Fortune 500 companies choose Toad

Tool for Oracle Application Developers, more widely known as Toad®, was designed by Oracle developer, Jim McDaniel, to make his job easier. It was so helpful that Jim decided to share it. Fast forwards to more than than 20 years later on, Toad is a trusted tool used in most Fortune 500 companies and across the globe.

In that location are many reasons why people buy Toad rather than staying with the "costless" SQL Developer tool Oracle offers. 1 main reason developers and DBAs choose Toad for Oracle is to reduce time and effort to develop and manage Oracle databases. But did you know that with Toad for Oracle you can automate administration tasks and proactively manage your databases while embracing operation optimization and risk mitigation? Did you lot know Toad tin can now find and control sensitive data across all your Oracle databases? What else can Toad do that you didn't know about? Which edition will do good you the most?

We're so confident that you will beloved Toad, we're offering our top 2 editions to y'all to endeavor for complimentary for 30 days.

DOWNLOAD HERE

Posted by: hillexacce.blogspot.com