Command-Line Utility Program for Oracle
0
votes
1answer
71 views
SQLPlus: Cmd vs PowerShell
From cmd.exe, when I run:
C:\oracle\client\BIN\sqlplus.exe username@server
then type my password, I get in. However, if I run the same command from PowerShell and type the same password I get:
...
1
vote
0answers
91 views
How do I execute an Oracle SQL script without sqlplus hanging on me?
For an automated task I would very much like to run some SQL scripts and make sure that sqlplus does not hang under any circumstancees, i.e.:
If the script contains any named substitution variable ...
0
votes
0answers
21 views
sqlplus command not working [closed]
I am trying to install Oracle Application Express on Windows 7, that is why I need SQL*plus . However SQL*Plus cannot be defined in cmd.
I am new to Oracle. What can I do in order to run SQL*Plus ?
0
votes
1answer
104 views
SYSDBA password in Oracle DB
I am connecting to Oracle DB using sysdba:
sqlplus / as sysdba
What is the default password for sysdba user. I tried in net and found out the default password is change_on_install but it is not ...
5
votes
1answer
270 views
How to resolve ORA-01031: insufficient priviledges error on Windows installation?
I installed Oracle 11G on my Windows 2008 R2 Server. I also installed Oracle Client Libraries using separate installation media. After the client installation, when I try to log into the database ...
0
votes
2answers
359 views
“ORA-01017: invalid username/password” : Why is that?
What is the difference between the two :
SQLPLUS / AS SYSDBA
and
SQLPLUS
Enter user-name: SYSDBA
Enter password:
If I use the first command I get connected and see the prompt SQL> but upon ...
0
votes
1answer
118 views
Set encoding from within SQL*Plus
I have a large set of files with SQL commands that I run with a SQL*Plus script that uses the @@ operator. I run the script on third-party computers (or even send it by e-mail) so I'd like to make it ...
1
vote
2answers
339 views
ORA-12154 TNS: could not resolve the connect identifier specified with SQLPLUS
I am using Toad to connect my database and its working fine for me .
But when i try to connect with the same credential , i am getting the error message as shown below:
ORA-12154 TNS: could not ...
2
votes
1answer
207 views
Can't return data from SQL/Plus and Toad but can from SQL Developer
This one has me stumped. We are running an Oracle 11g on Amazon EC2 and I can connect and query fine with SQL Developer but with Toad and SQL/Plus I can connect but when I try to do a simple select ...
1
vote
1answer
98 views
Invalid File Name on login to SQLPLUS
The moment I log into SQLPLUS I get an SP2-0556 error. I recently moved OS but am connecting to the same database so I am not sure if it's because I'm using my old TNSNames or what. I can connect and ...
1
vote
1answer
42 views
There is an equivalent of login.sql on PostgresSQL?
When you log on Oracle database with SQLplus, it looks for a login.sql file in the current directory. If the file exists, it's executed.
It's usefull to set preferences...
There is an equivalent ...
0
votes
1answer
87 views
Where to put login.sql in Windows environment to configure SQL Plus?
I installed Oracle 10g XE on my Windows Server 2008 R2. Now I would like to configure SQL Plus to use login.sql for login settings. I created a login.sql file and put it into a
C:\users\myname
...
8
votes
3answers
190 views
Do I have to retype information every time I make a mistake in SQLPlus
If I make a mistake in SQLPlus while inputting an 'insert into' command, is there a way I can bring this information back up in order to edit it?
3
votes
1answer
347 views
halt on error in a sqlplus script
I am deploying pl/sql code using several sql files that are called with @@file.
If a package got a compilation error the script continues to the end.
Is there a way to stop on every compilation ...
2
votes
1answer
91 views
Oracle start database with incorrect password
I have a question regarding starting oracle database with in correct sys password.
I have provided incorrect password for sys user and I am still able to start database and execute statements. So ...
