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

which is the best book for learning unix and linux?

6 Answers  


How to list only the directories inside a directory?

4 Answers  


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

0 Answers   CGI,


what happens when we create a file system?

1 Answers  


Which is the most commonly used replacement algorithm?

0 Answers   Aditi Placement Service,


in unix how to change old name to new name

5 Answers  


What is the main advantage of creating links to a file instead of copies of the file?

5 Answers   Cisco, ING,


how can you say that unix operating system provides more security than other operating systems.

1 Answers  


The UNIX shell is.... a).does not come with the rest of the system b).forms the interface between the user and the kernal c) does not give any scope for programming d) deos not allow calling one program from with in another e) all of the above

2 Answers   IBM,


What is an incremental backup?

2 Answers  


i am prepairing for 2+ yrs exp in oracle/unix production support,can u tell me which type issue comes in server plz help

0 Answers   Crimson Logic,


In detail elaborate the system? What is driver?

0 Answers   BMC,


Categories