All Questions
Tagged with sqlplus connectivity
7 questions
0
votes
2
answers
603
views
Oracle sqlplus doesn't connect to remote DB, only local
I would appriciate some help with an issue that I'm facing.
I have two Oracle DB servers with same schemas. I want to run sqlplus from one server to another. I've added the tns_names entries in ...
0
votes
1
answer
4k
views
Oracle user password with space character in it
I connected to an Oracle 19c database and executed the following SQL:
alter user sys identified by "a b" container=all;
It executed successfully. However, after that I can't connect to Oracle using ...
- 2,062
3
votes
3
answers
15k
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 ...
- 29
3
votes
2
answers
87k
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 ...
- 143
71
votes
7
answers
871k
views
Connect with sqlplus from the command line using a connection string
Let's say I have an Oracle database. I have a username = x, password = y, database = z, port = a, SID = b, and Hostname = c.
So, how do I connect correctly? I used many options like:
sqlplus x/y@'(...
- 711
10
votes
4
answers
197k
views
SYSDBA password in Oracle DB
I am connecting to Oracle DB with:
sqlplus / as sysdba
What is the default password for the sysdba user? I tried in net and found out the default password is change_on_install but it is not working ...
- 211
5
votes
3
answers
28k
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 ...
- 276