May 10, 2020 While Oracle is not natively available on a Mac computer, it’s possible to run Oracle or Oracle Express on a Mac using a virtual machine. This article describes the steps you need to take to set up the existing Oracle Developer VM and VirtualBox on your Mac to get it up and running. I want to install SqlPlus client on my Mac, which is 64-bit. Firstly, I installed sqlplus for 64-bit, but I had error: 'Segmentation fault: 11' Then I installed sqlplus for 32-bit, but still have a. Apr 08, 2020 oracle sql.plus free download. Sqlmap sqlmap is a powerful, feature-filled, open source penetration testing tool. It makes detecting and e. Choosing the SQL.Plus Instant Client to Install. SQL.Plus Instant Client can be installed in two ways: Download the packages from the Oracle Technology Network (OTN). Copy the same files that are in the packages from an Oracle Database 10 g Client Administrator installation.
SQL*Plus Instant Client is a standalone product with all the functionality of SQL*Plus command-line. It connects to existing remote Oracle databases, but does not include its own database. It is easy to install and uses significantly less disk space than the full Oracle Database Client installation required to use SQL*Plus command-line.
SQL*Plus Instant Client is available on platforms that support the OCI Instant Client. See About OCI Instant Client for more information on the OCI Instant Client.
To install SQL*Plus Instant Client, you need two packages:
D.1 About Choosing the SQL*Plus Instant Client to Install
SQL*Plus Instant Client can be installed in two ways:
Both the SQL*Plus and OCI packages must be from the same Oracle Database version, for example, 12.2.0.0.0.
D.1.1 Basic Instant Client
SQL*Plus Instant Client using the Basic OCI package works with any NLS_LANG setting supported by the Oracle Database. It supports all character sets and language settings available in the Oracle Database.
D.1.2 Lightweight Instant Client
SQL*Plus Instant Client using the lightweight OCI package displays error messages in English only and supports only specific character sets. It is significantly smaller than SQL*Plus Instant Client using the Basic OCI package.
Valid values for NLS_LANG parameters with the lightweight Instant Client are: Forescout secure connector mac download.
For example:
See Setting Up a Globalization Support Environment, and NLS_LANG Environment Variable for more information about NLS settings.
D.1.2.1 Lightweight SQL*Plus Instant Client Error with Unsupported Character Set
Attempting to start SQL*Plus Instant Client with an unsupported character set will fail with the following error:
D.2 About Installing SQL*Plus Instant Client by Downloading from OTN
The OTN downloads for Linux are RPM packages. The OTN downloads for UNIX and Windows are zip files.
The SQL*Plus Instant Client package should never be installed on an ORACLE_HOME.
D.2.1 Installing SQL*Plus Instant Client from Linux RPM Packages
D.2.2 Installing SQL*Plus Instant Client from the UNIX or Windows Zip Files
D.2.3 List of Files Required for SQL*Plus Instant Client
Tables E-1, E-2 and E-3 list the required files from each of the SQL*Plus and OCI packages. The files from only one of the OCI packages are required. Other files installed that are not listed here can be ignored, or can be removed to save disk space.
Table D-1 Instant Client Files in the SQL*Plus Package
Table D-2 Instant Client Files in the Basic OCI Package
Table D-3 Instant Client Files in the Lightweight OCI Package
![]()
D.3 Installing SQL*Plus Instant Client from the 12c Client Release Media
D.3.1 Installing SQL*Plus Instant Client on UNIX or Linux
To install SQL*Plus Instant Client using the Basic OCI package on UNIX and Linux, copy the following files: https://militaryhigh-power820.weebly.com/blog/free-career-portfolio-template-download.
To install SQL*Plus Instant Client using the lightweight OCI package on UNIX and Linux, copy the following files:
D.3.2 Installing SQL*Plus Instant Client on Windows
To install SQL*Plus Instant Client using the Basic OCI package on Windows, copy the following files:
To install SQL*Plus Instant Client using the lightweight OCI package on Windows, copy the following files:
D.4 About Configuring SQL*Plus Instant Client
The SQL*Plus Instant Client executable should only be used with the matching version of the OCI Instant Client.
Note that no ORACLE_HOME or ORACLE_SID environment variables need to be set.
D.4.1 Configuring SQL*Plus Instant Client on Linux (from RPMs)
The RPMs downloaded from OTN install into Oracle specific sub-directories in the /usr file system. The sub-directory structure enables multiple versions of Instant Client to be available.
D.4.2 Configuring SQL*Plus Instant Client on Linux (from Client Media or Zip File) and UNIX
D.4.3 Configuring SQL*Plus Instant Client on Windows
The environment may be configured using SET commands in a Windows command prompt or made permanent by setting Environment Variables in System Properties.
For example, to set environment variables in Windows 2000 using System Properties, open System from the Control Panel, click the Advanced tab and then click Environment Variables.
D.5 About Connecting to a Database with SQL*Plus Instant Client
SQL*Plus Instant Client is always 'remote' from any database server. To connect to a database you must specify the database using an Oracle Net connection identifier.
An example using an Easy Connection identifier to connect to the HR schema in the MYDB database running on mymachine is: Guitar pro mac os x download.
Alternatively you can use a Net Service Name:
Net Service Names can be stored in a number of places, including LDAP. The use of LDAP is recommended to take advantage of the new features of Oracle Database 12c. See Local Naming Parameters in the tnsnames.ora Filefor more information.
If you want to use Net Service Names configured in a local Oracle Net tnsnames.ora file, then set the environment variable TNS_ADMIN to the directory containing the tnsnames.ora file. For example, on UNIX, if your tnsnames.ora file is in /home/user1 and it defines the Net Service Name MYDB2:
If TNS_ADMIN is not set, then an operating system dependent set of directories is examined to find tnsnames.ora. This search path includes looking in the directory specified by the ORACLE_HOME environment variable for network/admin/tnsnames.ora. This is the only reason to set the ORACLE_HOME environment variable for SQL*Plus Instant Client. If ORACLE_HOME is set when running Instant Client applications, it must be set to a directory that exists.
This example assumes the ORACLE_HOME environment variable is set, and the $ORACLE_HOME/network/admin/tnsnames.ora or ORACLE_HOMEnetworkadmintnsnames.ora file defines the Net Service Name MYDB3:
The TWO_TASK (on UNIX) or LOCAL (on Windows) environment variable can be set to a connection identifier. This removes the need to explicitly enter the connection identifier whenever a connection is made in SQL*Plus or SQL*Plus Instant Client. This UNIX example connects to the database known as MYDB4:
On Windows, TNS_ADMIN and LOCAL may be set in the System Properties. See Configuring SQL*Plus Instant Client on Windows.
D.6 AS SYSDBA or AS SYSOPER Connections with SQL*Plus Instant Client
To connect AS SYSDBA or AS SYSOPER to perform DBA tasks, you need to set up an Oracle password file on the database server using the database's orapwd utility. Once this is configured, your SQL*Plus Instant Client connection string might look something like:
See Using Password File Authenticationfor information on Oracle password files.
Oracle Sql Plus Download Mac OsD.7 About Uninstalling Instant ClientInstall Sql Plus
The SQL*Plus Instant Client package can be removed separately from the OCI Instant Client. After uninstalling the SQL*Plus Instant Client package, the remaining OCI Instant Client libraries enable custom written OCI programs or third party database utilities to connect to a database.
D.7.1 Uninstalling SQL*Plus Instant Client
D.7.2 Uninstalling the Complete Instant ClientOracle Sql Plus Download Free
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |