< 1 2 3 4 5 6 7 > >>   Sort: Rank

Change System Global Area (SGA) in Oracle
How To Change System Global Area (SGA) in Oracle? Your 10g XE server has a default setting for System Global Area (SGA) of 140MB. The SGA size can be changed to a new value depending on how many concurrent sessions connecting to your server. If you are running this server just for yourself to improv...
2020-09-30, 847👍, 0💬

SGA Setting Is Too Low in Oracle
What Happens If You Set the SGA Too Low in Oracle? Let's you made a mistake and changed to SGA to 16MB from the SYSTEM admin home page. When you run the batch file StartDB.bat, it will return a message saying server stated. However, if you try to connect to your server home page: http://localhost:80...
2020-09-30, 826👍, 0💬

Unlock the Sample User Account in Oracle
How To Unlock the Sample User Account in Oracle? Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it: Log into the server home page as SYSTEM. Click the Administration icon, and then click Database Users. Click ...
2020-09-30, 719👍, 0💬

Show the Server Version in Oracle
How To Check the Server Version in Oracle? Oracle server version information is stored in a table called: PRODUCT_COMPONENT_VERSION. You can use a simple SELECT statement to view the version information like this: &gt;.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SYSDBA Connected to an idle...
2020-09-15, 880👍, 0💬

Change Settings in Binary SPFile in Oracle
What To Do If the Binary SPFile Is Wrong for the Default Instance in Oracle? Let's say the SPFile for the default instance is a binary file, and some settings are wrong in the SPFile, like SGA setting is bellow 20MB, how do you change a setting in the binary file? This seems to be a hard task, becau...
2020-09-15, 874👍, 0💬

Start the Default Instance in Oracle
How To Use "startup" Command to Start Default Instance in Oracle? If you logged in to the server as a SYSDBA, you start the default instance with the "startup" command. Here is how to start the default instance in SQL*Plus in SYSDBA mode: &gt;.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SY...
2020-09-15, 827👍, 0💬

Login to Server without an Instance in Oracle
How To Login to the Server without an Instance in Oracle? If your default instance is in trouble, and you can not use the normal login process to reach the server, you can use a special login to log into the server without any instance. Here is how to use SQL*Plus to log in as a system BDA: &gt;...
2020-09-15, 788👍, 0💬

Instance Settings Stored in SPFile in Oracle
Where Are the Settings Stored for Each Instance in Oracle? Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files should be located in $ORACLE_HOME\database directory. A paramete...
2020-09-15, 766👍, 0💬

Introduction to Command-Line SQL*Plus Client Tool
Where to find answers to frequently asked questions on Command-Line SQL*Plus Client Tool? I want to learn simple ways to run commands on Oracle database server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Command-Line SQL*Plus Client Tool. Cle...
2020-08-25, 996👍, 0💬

Requirements for SQL*Plus Connection in Oracle
What Information Is Needed to Connect SQL*Plus an Oracle Server in Oracle? If you want to connect your SQL*Plus session to an Oracle server, you need to know the following information about this server: The network hostname, or IP address, of the Oracle server. The network port number where the Orac...
2020-08-25, 983👍, 0💬

Start the Command-Line SQL*Plus in Oracle
How To Start the Command-Line SQL*Plus in Oracle? If you Oracle server or client installed on your windows system, you can start the command-line SQL*Plus in two ways: 1. Click Start &gt; All Programs &gt; Oracle ... &gt; Start SQL Command Line. The SQL*Plus command window will show up w...
2020-08-25, 904👍, 0💬

Main Features of SQL*Plus in Oracle
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface. SQL*Plus has its own comm...
2020-08-25, 833👍, 0💬

Help at the SQL Prompt in Oracle
How To Get Help at the SQL Prompt in Oracle? Once SQL*Plus is started, you will get a SQL prompt like this: SQL&gt;. This where you can enter commands for SQL*Plus to run. To get help information at the SQL prompt, you can use the HELP command as shown in the following tutorial example: SQL&...
2020-08-25, 805👍, 0💬

Connect SQL*Plus Session to Oracle Server in Oracle
How To Connect a SQL*Plus Session to an Oracle Server in Oracle? In order to connect a SQL*Plus session to an Oracle server, you need to: 1. Obtain the connection information from the Oracle server DBA. 2. Define a new "connect identifier" called "FYI_XE" in your tnsnames.org file with the given con...
2020-08-13, 1080👍, 0💬

Error: Could not Resolve the Connect Identifier in Oracle
What Happens If You Use a Wrong Connect Identifier in Oracle? Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier: SQL&gt; CONNECT fyi/retneciyf@WRONG; ERROR: ORA-12154: TNS:could not resolve the connect ...
2020-08-13, 948👍, 0💬

Types of Commands Executed in SQL*Plus in Oracle
What Types of Commands Can Be Executed in SQL*Plus in Oracle? There are 4 types of commands you can run at the SQL*Plus command line prompt: 1. SQL commands - Standard SQL statements to be executed on target database on the Oracle server. For example: "SELECT * FROM fyi_faq;" is a SQL command. 2. PL...
2020-08-13, 872👍, 0💬

What Is a Connect Identifier in Oracle
What Is a Connect Identifier in Oracle? A "connect identifier" is an identification string of a single set of connection information to a specific target database instance on a specific Oracle server. Connect identifiers are defined and stored in a file called tnsnames.ora located in $ORACLE_HOME/ne...
2020-08-13, 852👍, 0💬

Reset Lost SYSTEM Password in Oracle
What To Do If DBA Lost the SYSTEM Password in Oracle? If the DBA lost the password of the SYSTEM user account, he/she can go to the Oracle server machine, and run SQL*Plus on server locally with the operating system authentication method to gain access to the database. The tutorial exercise below sh...
2020-08-13, 836👍, 0💬

Run SQL Commands in SQL*Plus in Oracle
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example: SQL&gt; SELECT 'Welcome!' FROM DUAL; 'WELCOME -------- Welcome! SQL&g...
2020-08-03, 989👍, 1💬

💬 2020-08-03 chelseaclark: β-Arrestin recruitment is a ubiquitous mechanism of negative regulation of GPCR signaling, which has been demonstrated for almos...

Change SQL*Plus System Settings in Oracle
How To Change SQL*Plus System Settings in Oracle? SQL*Plus environment is controlled a big list of SQL*Plus system settings. You can change them by using the SET command as shown in the following list: SET AUTOCOMMIT OFF - Turns off the auto-commit feature. SET FEEDBACK OFF - Stops displaying the "2...
2020-07-22, 930👍, 0💬

Run PL/SQL Statements in SQL*Plus in Oracle
How To Run PL/SQL Statements in SQL*Plus in Oracle? If you want to run a single PL/SQL statement in SQL*Plus, you need to use the EXECUTE command as shown in the following tutorial example: SQL&gt; SET SERVEROUTPUT ON SQL&gt; EXECUTE DBMS_OUTPUT.PUT_LINE('Welcome to FYIcenter!') Welcome to F...
2020-07-22, 878👍, 0💬

Show Current SQL*Plus System Settings in Oracle
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values of SQL*Plus system settings, you can use the SHOW command as shown in the following tutorial exercise: SQL&gt; SHOW AUTOCOMMIT autocommit OFF SQL&gt; SHOW HEADING heading ON SQL&gt; SHOW ...
2020-07-22, 851👍, 0💬

SQL*Plus Environment Variables in Oracle
What Are SQL*Plus Environment Variables in Oracle? Behaviors of SQL*Plus are also controlled a some environment variables predefined on the local operating system. Here are some commonly used SQL*Plus environment variables: ORACLE_HOME - The home directory where your Oracle client application is ins...
2020-07-22, 843👍, 0💬

Input Buffer in SQL*Plus in Oracle
What Is Input Buffer in SQL*Plus in Oracle? Input buffer is a nice feature of the command-line SQL*Plus tool. It allows you to revise a multiple-line command and re-run it with a couple of simple commands. By default, input buffer is always turned on in SQL*Plus. The last SQL statement is always sto...
2020-07-15, 1005👍, 0💬

< 1 2 3 4 5 6 7 > >>   Sort: Rank