Command-Line Utility Program for Oracle

learn more… | top users | synonyms

0
votes
2answers
7k views

sqlplus startup - failure in processing system parameters

I am trying to do the startup command This is what I have done: set oracle_sid=ORCL sqlplus /nolog SQL> conn /as sysdba startup It shows this error message: failure in processing system ...
0
votes
1answer
251 views

Check Oracle Service is Started from Batch Command

Uses: Oracle9i Standard Ed; I have a schedule which performs a Dump Import and afterwards the System Reboots itself, which is happening without any problem. After the System had rebooted, I have ...
2
votes
1answer
2k views

sqlplus is not starting

I have a strange error on a Red Hat machine. InstantClient is installed in and ORACLE_HOME is set to /opt/oracle/product/112030_cl_64/cl/ The user which installed the client was oracle:oinstall. My ...
2
votes
1answer
43k views

Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server

I installed 11g on Centos VM on my mac.I have everything up and working on server.I have included following command I ran on cenos. $lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production ...
2
votes
1answer
23 views

SQLPLUS Default Column Widths

For almost all my databases, when I run a SELECT statement, the length of the column displayed is sized to the width of the data being queried. However, I have two databases (Dev and Prod for the ...
0
votes
1answer
7k views

Can't connect to a Oracle db instance via SQLDeveloper

When I set the connecting information on the GUI in SQLDeveloper I get the following error (everytime!) Status : Failure -Test failed: IO Error: The Network Adapter could not establish the ...
15
votes
4answers
11k views

How to differentiate between SQL and PL/SQL?

I know the question might sound too stupid, but I never understood this part. SQL*Plus works with both SQL and PL/SQL. How do I know whether some code is SQL or PL/SQL? If my code has a for ...
0
votes
0answers
14 views

error while creating user with a default tablespace

I am new to Oracle 12 and I don't know how to work with Container Databases (CDB) and Pluggable Databases (PDB). In Oracle Database 12c I created a database with the dbca and I created a tablespace ...
0
votes
2answers
40 views

ORACLE12 - Connect Via SqlPlus

I have a local installation of Oracle Before i can connect directly via SqlPlus but now when i try to connect i have this error : ERROR: ORA-01034: ORACLE not available ORA-27101: shared ...
0
votes
0answers
54 views

FATAL INS-32012 Unable to create directory - Oracle 12c client installation

I am installing oracle client as Administrator in my Linux machine as a silent mode, I faced issue like this [FATAL] [INS-32012] Unable to create directory: /u01/app/12.1.0.2/admclient64. I don't ...
2
votes
3answers
72 views

using tnsnames.ora and sqlplus client without installing oracle 11g server on linux client [closed]

I want to create a connection to remote Oracle server using SQLplus client and tnsnames.ora without installing Oracle 11g server on the Linux client. I used debian and bash script to generate reports ...
0
votes
1answer
13 views

Setting Blank lines to ON before executing a SQLFILE in shell script

echo exit | sqlplus username/password@host_ip:port/Service_name @SQLFILENAME I want to execute set sqlbl on before executing The SQLFILENAME and also want that after executing SQLFILENAME it should ...
0
votes
1answer
13 views

(SQL) User tables are separated into two sections

Using SQL Plus, I create 13 tables via an .sql file, each containing primary and foreign keys. When I execute "select table_name from user_tables;" they are displayed in this partitioned fashion. ...
1
vote
1answer
38 views

Importing Oracle12c database

i am using Oracle 12c in debian Jessie i want to import an old database exported with expdp on oracle 12c when i try to launch the commande 'impdp' i got those errors : 'ORA-39002: invalid operation' ...
0
votes
0answers
43 views

Error ORA-12547: TNS:lost contact

I installed Oracle12c Database in my server i run SQLPLUS with the command 'sqlplus /nolog' and when i type 'conn sys /as sysdba' i got this error ORA-12547: TNS:lost contact Can you help me ...
0
votes
1answer
74 views

Error launching sqlplus

I try to run sqlplus on my server with the command sqlplus /as sysdba and I got this error sqlplus: error while loading shared libraries: ...
0
votes
1answer
37 views

Help on joining 3 tables Oracle XE 11g

I am trying to return the first name, surname, subject and mark from the following tables: SQL> desc students; Name Null? Type ------------------------ -------- ...
1
vote
1answer
26 views

Oracle XE/SQLPlus query display more items

Is there a setting to allow Oracle XE/SQLPlus to display more items before beginning a new header? For example: First Name SURNAME Subject MARK ...
3
votes
1answer
1k views

Install Oracle 10.2.0.4 on Windows Server 2012 R2

I have problem with installing Oracle 10.2.0.4 on Windows Server 2012 R2. We are running old 10.2.0.4 instance on Windows Server 2008 R2. Now I have to migrate it to the Windows Server 2012 R2. ...
0
votes
1answer
145 views

Does PL/SQL code run differently in sql plus vs sql developer?

Today, I stumbled upon a question someone posted about the / character and ; character. The Answer doesn't seem to be down-voted, so I questioned it a little more as to why it wasn't down-voted. ...
1
vote
2answers
23k views

sqlplus: ORA-01017 logon denied from one host but OK from another

I have a strange behavior for remote sqlplus login to Oracle 11.2 that I cannot explain: 1) I have an Oracle 11.2 server running on a virtual host, say host1 2) I set up another VM, say host2 (CentOS ...
1
vote
2answers
35 views

SQLPLUS: SELECT INTO prompting for variable value

Any idea why this is prompting me for the value? I'm calling the script via batch file: DECLARE precount NUMBER; nowcount NUMBER; BEGIN SELECT COUNT(*) INTO precount FROM ...
0
votes
1answer
34 views

how to run DBMS_RULE_ADM [closed]

Oracle 11.2.0.3 My instructions are DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_RULE_OBJ, '<schema_name>'); I tried to run them at sqlplus /as sysdba but it tells me unknown ...
8
votes
8answers
171k views

Connect to sql plus from command line using connection string

Let's say I have a Oracle database. I have a username = x, password = y, database = z. Also I know the port = a, SID = b, Hostname = c. So how do I need to connect correctly? I used many options ...
3
votes
1answer
95 views

Global command to destroy all disconnected data files in Oracle 11g

Is there a global command to delete/purge all disconnected .bdf files in an Oracle 11g R2 database? Here is the scenario: Every user-defined user and user-defined tablespace was deleted from an ...
1
vote
1answer
110 views

Spool query to file without output on screen

Using spool on Oracle sqlplus correctly sends the results of my queries to a file. But I also see output on the screen. Is it possible to see only the query without output on screen, and result on ...
1
vote
1answer
51 views

Should we consider “sqlplus” as an Oracle client?

I am a newbie of SQL*Plus and Oracle, and I have 2 questions about them. (1) Executing "sqlplus / as sysdba" command: $ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Thu Feb 18 ...
17
votes
13answers
5k views

Comfortable sqlplus interface?

I found sqlplus'interface is rather outdated. It's quite nice to have some commands or keywords at disposal, but for example no "arrow-up" key for the previous history entry is available. What is a ...
0
votes
1answer
48 views

I don't want to have the error when I drop a table although the table doesn't exist [closed]

I am using Oracle 12c and I am not interesting to have an error while droping my table 'CONTINENT' in case it doesn't exist. I did this set echo on set serveroutput on alter session set ...
0
votes
1answer
88 views

How can sqlplus knows where ORACLE_SID point?

As I understand, SID is unique value to identify an Oracle database instance. And I can set default database instance sqlplus use by changing ORACLE_SID environment variable. But how can sqlplus ...
4
votes
1answer
93 views

Result on execution of any SQL is number 2

After successful execution of any sql in oracle sql command line it shows 2 like i want to see the table or description of any table it show 2 instead of showing the table. SQL> select * from dual ...
1
vote
1answer
229 views

sqlplus not connecting to Oracle XE 11g

I installed Oracle XE 11g on my Ubuntu in vmware fusion. The oracle installation is all went fine but I am not able to connect the oracle database using sqlplus. I am getting this exception: $ ...
0
votes
1answer
20 views

Problems to connect to an Oracle Database with SQLPLUS and URL-Variable, can somebody explain what I have to do?

I would like to connect to a ORACLE database via SQLplus. If I do it this way: sqlplus "user/pw@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=dbsrv01.desy.de)(PORT=1521))(ADDRESS=(PROTOCOL = TCP)(HOST = ...
5
votes
5answers
27k views

Message file not found when starting SQLPlus

I've installed Oracle XE 11.2 on Fedora 18 but have trouble starting SQLPlus. It quits with the following error: Error 6 initializing SQL*Plus SP2-0667: Message file sp1<lang>.msb not found ...
1
vote
1answer
751 views

Database gives “ORA-01109: Database not open” error when it IS open

Running Oracle Database 12c on Windows Server 2012 Whenever I attempt to do a log switch (alter system archive log current), I am given the error in the title. Searching online shows the simple ...
9
votes
3answers
19k views

Is there any difference between Rem and — comments for SQL*Plus?

On SQL*Plus prompt, both Rem and -- qualify as comment indicators: Rem this is a comment -- this is also a comment create table emp ( id number primary key, name cvarchar2(40)); Is there any ...
0
votes
2answers
73 views

IF condition in connect command in SQL*Plus

I want to fire SQL queries only when the user is connected to SQL*Plus. In my case even if the connection is not there, the rest of the commands are running in my SQL script. if "connect ...
1
vote
1answer
28 views

Find out where length semantics gets changed

I've code to create tables that doesn't specify length semantics: CREATE TABLE CHAR_TEST ( CHAR_TEST_ID NUMBER(*,0) NOT NULL, FOO VARCHAR2(6) NOT NULL, BAR VARCHAR2(6) NOT NULL, ...
3
votes
1answer
6k views

sqldeveloper ORA-12505. TNS: listener does not currently know of SID given in connect descriptor

There are similar questions asked and answered in this network related to the error message given in the question, however this problem is a little different from each. I have installed oracle 12c in ...
0
votes
1answer
33 views

Can not login user SEC_MGR in SQLPLUS

I can login user SEC_MGR when I use the TOAD tool. But, It has error when i login by SQLPLUS:
0
votes
0answers
166 views

Cannot log in sys as sysdba to Oracle 11g SQL*Plus with full ezconnect string

I am having problems with SQL*Plus on my RAC One ODA. I cannot use a full connect string to log in to any database (there are three on two separate ODAs) with sys as sysdba. I can duplicate this ...
2
votes
2answers
8k views

Sql*Plus ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

I installed Sql*PLUS on a cloud Oracle Linux Environment in order to access an remote database. I used the installation instructions provided as an answer here: ...
3
votes
3answers
13k views

Oracle Enterprise Manager (OEM) locking SYSMAN account

Why does Oracle Enterprise Manager reset my SYSMAN account to LOCKED(TIMED) status? I've tried rebuilding Enterprise Manager, and re-installation of Enterprise Manager, which always works, until the ...
1
vote
0answers
74 views

SQLPlus TNS:protocol adapter error

i have two Oracle 12c instances. currently both are shutdown. when I try to connect with sqlplus / as sysdba it says tns protocol adapter error contents of tnsnames.ora are DB12102 = (DESCRIPTION = ...
1
vote
2answers
328 views

How to erase in sqlplus with backspace?

Using SQL*PLUS, I cannot use the backspace button to erase content during a line command. When I hit backspace, instead of erasing it writes ^H Is there a way to configure backspace so it works as ...
1
vote
1answer
231 views

SQLPlus “no listener” only with a remote connection from Windows

The Oracle database is running on a linux server. The lsnrctl service is running. Locally, I can connect to database from sqlplus and sql developer. Remotely, from windows, I can't connect. sqlplus ...
1
vote
2answers
170 views

SQL*Plus save current COLUMN settings

In SQL*Plus, is there a way to save current COLUMN settings similar to STORE which saves SET commands in a script? COLUMN can be used to list the settings, but they are not in script format.
0
votes
1answer
406 views

is there a way to connect to mysql using oracle sqlplus instant client

i am stuck while trying to connect to mysql using sqlplus client and i have already asked this question at askubuntu.com as ...
0
votes
0answers
42 views

Query on Sqlplus utility

I have a OS user 'test' who doesn't belong to dba group or oinstall group. I need to access the database using sqlplus but I'm unable to access the sqlplus even after setting oracle home ans path and ...
0
votes
1answer
1k views

Spool in Shell script not working for me

#!/bin/sh echo "Started at" `date +%Y/%m/%d" "%H:%M:%S` sqlplus -s ${ORA_LOGIN_SYSADM} <<EOF 2>&1 > /dev/null SET SERVEROUTPUT ON SET FEED OFF spool ech.txt create BEGIN ...