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

What are different types of shells?

7 Answers   BMC,


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

1 Answers   TCS,


How do you list the files in an UNIX directory while also showing hidden files?

4 Answers  


What is a Map?

0 Answers  


What is a Region?

1 Answers  






How to setup display for a remote system?

3 Answers  


How will you run the script in UNIX?

5 Answers   BMC,


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

0 Answers   CGI,


interprocess command in unix be achieved by a)pipes b)messages c)semaphores d)shared memory e)all

2 Answers   Mascot,


Am using Mac OS 10.4.11 on an Imac (PPC) Internal hard disk got named disk0s3 and will not mount. What commands can be used in TERMINAL to rename the internal hard disk to C96?

0 Answers  


What are the events done by the Kernel after a process is being swapped out from the main memory?

0 Answers  


What is default permissions for others in a file?

5 Answers  


Categories