How to connect oracle database from unix

Answers were Sorted based on User's Feedback



How to connect oracle database from unix..

Answer / basha

Hi this is correct way to connect oracle using unix.

sqlplus username/passord@datasbename

Is This Answer Correct ?    66 Yes 9 No

How to connect oracle database from unix..

Answer / sashi

In Unix prpomt type the command
sqlplus -s username/passwd <<EOD
select * from emp;
EOD

Is This Answer Correct ?    56 Yes 14 No

How to connect oracle database from unix..

Answer / jaga

oracle need to install on unix. and database has to
configured in /oracle/network/admin/listener.ora file.
then use sqlplus dbname@sa/sa

Is This Answer Correct ?    43 Yes 13 No

How to connect oracle database from unix..

Answer / dba

The other answers will work, but would allow other users to see the passwords using ps or history.

sqlplus /nolog
@ > connect username/password@database

or

sqlplus username@database
Enter password:

Is This Answer Correct ?    13 Yes 3 No

How to connect oracle database from unix..

Answer / marigold

Set ORACLE_HOME & ORACLE_SID environment variable.
Then use sqlplus username@ORACLE_SID

Is This Answer Correct ?    0 Yes 0 No

How to connect oracle database from unix..

Answer / debendra nath panigrahi

sqlpus -s username/passwd >>eof
select * from emp;

Is This Answer Correct ?    2 Yes 7 No

Post New Answer

More Unix AllOther Interview Questions

Explain about Inodes?

0 Answers   Amazon,


If Media Server fails. What are the steps to be followed? Can anyone please reply for this question Thanks, Ganesh

0 Answers   HCL, IBM,


What is default permissions for others in a file?

5 Answers  


I am new to Unix and Unix Shell scripting could you guide me on how to go about these subjects and where to start from with concern to Oracle?. I also would like to know where does UNIX shell Scripting help in terms of development of a application in Oracle? I have no clue in the subject so do help me. Thank You Neelima

0 Answers  


What is the number of the masked code ee@?

2 Answers   Accenture, Amazon, Amdocs,


what is difference between milestone and run-levels in Solaris ?

0 Answers  


What is the difference between internal and external commands?

13 Answers   BPL, DOEACC, Engro, Kuvempu University, NIIT, TCS,


what is the time for incident, problem and change management tickets?

0 Answers   CGI,


. Using sed and grep, write a command which lists files and directories with following properties: (i) created in 1999 (ii) with user's as owner and group

0 Answers  


Is this the command to connect oracle from unix? sqlplus -s username/password. Then what is the -S here...????

1 Answers   TCS,


differentiate between named & unnamed pipe.

11 Answers   Cisco, IIT, ISEC,


What are the main differences between Apache 1.x and 2.x?

1 Answers   IBM,


Categories