Accessing the Oracle Database from Linux
This section describes how to use SQL*Plus and the easy connect naming method to connect to an Oracle database from a client computer. SQL*Plus is typically installed when you install Oracle Database client software. The easy connect naming method provides TCP/IP connectivity to databases without requiring you to configure Oracle Net Services. To connect to Oracle Database from SQL*Plus: If you are on a Windows system, display a Windows command prompt. At the command prompt, type sqlplus and press the key Enter. SQL*Plus starts and prompts you for your user name.
At the command prompt, type sqlplus and press the key Enter. User input is bold. This section assumes that SQL Developer is installed on your system, and shows how to start it and connect to Oracle Database. The what does cva stand for in medicine time you start SQL Developer on your system, you must provide the full path to java. If this is the first time you have started SQL Developer on your system, you are prompted to enter the full path to java.
Either type the full path after the prompt or browse to it, and then press the key Enter. Near the Password field is the check box Save Acccess.
By default, it is deselected. Oracle recommends accepting the default. The connection is tested. If the connection succeeds, the Status indicator changes from blank to Success. The Connections pane shows the connection whose name you entered in the Connection Name field in step 7. This section shows how to unlock the HR account and connect to Oracle Database as the user HRwho owns the HR sample schema that the examples and tutorials in this document use.
To do the tutorials and examples in this document, and create the sample orscle, you must connect to Oracle Database as the user HR from SQL Developer. The HR sample schema is the development environment for the sample application. By default, when the HR schema is installed, the HR account is locked and its password is expired. To unlock the HR account and reset its how to access oracle database from client. The HR account is unlocked and its password is password.
Now you can connect to Oracle Database as user HR with the password how did george washinton die. Skip Headers. Note: For clkent 3 and 4 of the following procedure, you need a user name and password. Note: For security, your password is not c,ient on your screen.
All rights reserved. Note: For the following procedure: The first time you start SQL Developer on your system, you must provide the full path to java. For step 7you need a user name and password. For step 9you need a host name and port. The next time you start SQL Developer, the connection you created using the preceding procedure still exists. SQL Developer prompts you for the password that you supplied in step 7 unless you selected the check box Save Password.
Caution: Choose a how to access oracle database from client password. For guidelines for securing passwords, see Oracle Database Security Guide. Note: For the following procedure, you need the password for the HR account. Book List. Master Index. Contact Us. Legal Notices.
To connect to Oracle Database from SQL*Plus: If you are on a Windows system, display a Windows command prompt. At the command prompt, type sqlplus and then press the key Enter. At the user name prompt, type your user name and then press the key Enter. To connect to an Oracle Database, a client application must identify the database and present appropriate credentials. The connection mechanism depends on the type of client and whether it is running locally or remotely. Some connections require the installation of Oracle Client software. There are several methods for specifying login credentials. The connection you have configured appears in the Connections pane at the left of the SQL Developer window. Click on the + alongside the name to connect to the database. You will need to enter your Oracle account password to complete the connection. A .
This chapter explains how to connect to a database to use Oracle Data Mining. It contains the following sections:. Be sure to select the appropriate one. Enter the name of a user ID that has data mining privileges, as described in Chapter 4.
You will be prompted to enter the password. The first time you run SQL Developer, you may be prompted to provide the path to the Java executable.
For the installation described in Chapter 2 , the path would be:. For Connection Name , specify a meaningful name that you will remember. The user must have data mining privileges as described in Chapter 4. For Hostname , specify localhost to indicate that the database is hosted on the local computer.
For Port , specify the port where the database will listen to requests from the client. The default port is This is the first component of the global database name described in the installation instructions in Chapter 2. Click Connect to connect to the database using the specified credentials. A separate connection to the database is required for each user that will use the tool.
Instructions for creating these connections are provided in the Oracle Data Miner Help. To connect to an Oracle Database, a client application must identify the database and present appropriate credentials. The connection mechanism depends on the type of client and whether it is running locally or remotely. Some connections require the installation of Oracle Client software. There are several methods for specifying login credentials.
For example, a client may present login credentials at the time of the connection, as shown below. The system will prompt for a password and establish a connection. Use the following steps to install Oracle Client on a Windows platform:. Find the service names that start with "Oracle". Choose Stop for each one. Log on to your computer as a member of the Administrator's group. In the Download Software Updates page, provide your My Oracle Support credentials if you want to automatically download software updates.
Click Next. See "Install Oracle Database" step 8. This will be the home directory of the Oracle client that you are installing Oracle home. If this directory does not exist, the Installer will create it. If the directory does exist, make sure that it is empty. Click Install to complete the set up process and begin the installation.
A Net Service Name is not needed. Simply click Next. Oracle Net Configuration Assistant displays summary information about the connection configuration. Click the Password Management button at the bottom of the page to unlock any schemas that you plan.
If you wish, you can also reset the system passwords. If you will use the Oracle Data Mining sample programs and you did not unlock the SH schema when you installed the database, you should do so now. See "Install Oracle Database". If you stopped any Oracle services before running Oracle Universal Installer, you can restart them at this time.
Choose Start for each one. The instructions in this section explain how to create a Net Service Name. On the next page, choose Add to add a new Net Service Name. Then click Next. On the next page, choose Yes, perform a test to test the new connection. If the user name and password were the only problem with the connection, Oracle Net Configuration Assistant makes a successful test connection. Oracle Net Configuration Assistant reports that the connection configuration was successful.
When you click Next , you are returned to the Welcome page, where you have the opportunity to perform additional configuration. Whether the data is stored in Excel or in the database, the Spreadsheet Add—In requires a database connection. It uses a Net Service Name to connect to the database. From the list of predefined Net Service Names, choose the connection you want to use.
Provide a user name and password and click Connect to activate the Spreadsheet Add—In. Description of the illustration sqlplus. Description of the illustration sqldev. Description of the illustration sqldevodmr. Oracle Client and Oracle Net To connect to an Oracle Database, a client application must identify the database and present appropriate credentials. Use the following steps to install Oracle Client on a Windows platform: Note: The following instructions are not intended as a replacement for Oracle Client and Net Management documentation.
Note: The following instructions are not intended as a replacement for Oracle Client and Net Management documentation. From the Add—In menu, choose Connect. Description of the illustration addin2. Description of the illustration addin3.