Sponsored Content
Full Discussion: Not able to connect Oracle
Top Forums UNIX for Dummies Questions & Answers Not able to connect Oracle Post 302610429 by methyl on Wednesday 21st of March 2012 08:52:40 AM
Old 03-21-2012
Imho. This is not a routine unix problem. Not heard of this exact fault before and it would take some effort to generate this effect with unix commands. Spilling coffee in the keyboard would be easier!

First: Can you try a different physical keyboard? Can you try a different terminal? Anybody else got the problem?

Second: Ignoring sqlplus. Does typing the @ character at the shell command prompt behave differently when you are logged in as root compared with when you are logged in as oracle or any other user?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to connect to oracle ??

Hi, I am a new user, who wants to connect to oracle through shell scripting. Can anybody help me? Regards, Divyesh (2 Replies)
Discussion started by: divyesh shah
2 Replies

2. Shell Programming and Scripting

How to connect ORACLE using PERL

Hi Friends, I am having Perl 5 and Oracle 9i. I just wanna to connect Oracle DB & to perform some select query statement. Could anyone pls let me know. I've tried below command which i found in some website, But it throws some error.:confused: Executed: perl -e 'use DBI; print... (1 Reply)
Discussion started by: Vijayakumarpc
1 Replies

3. Shell Programming and Scripting

How to connect oracle from unix

Hi All, I am trying to connect oracle from unix mechine but i am getting an error like Ksh: sqlplus: not found Any one please tell me how to connect oracle from unix mechine. I would appreciate if any one send the query. Regards, Ravi kumar.Gongati (2 Replies)
Discussion started by: ravi gongati
2 Replies

4. Solaris

Connect Oracle from NATted IP

We have a Sun solaris 9 server (say A), with oracle 9 installed and running, at one place(say X). We have installed oracle client in windows machines and accessing the database through one application developed by our software vendor. The windows machines are connected through LAN in which the... (0 Replies)
Discussion started by: skbpk_in
0 Replies

5. Shell Programming and Scripting

Perl connect to remote oracle db without local oracle installation

I want to use Perl to connect to a remote Oracle DB I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server. Is this possible? I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies

6. Shell Programming and Scripting

Unix - Oracle DB Connect

Hello, Returing to Unix scripts after a long while, This might be a simple question for most of you , I need to connect from a .sh script to oracle, select XYZ.nextval from dual , , meaning either get the Current Val or Next Val for a sequence. How do I store the return value , I know... (2 Replies)
Discussion started by: Shanks
2 Replies

7. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies

8. Shell Programming and Scripting

Connect to Oracle using sqlplus

I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'. What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies

9. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

10. Shell Programming and Scripting

Connect to Oracle database

could someone please help me in shell scripting. i want to connect to oracle database which is on remote sever. requirement: 1 want to check files in source directory if file exist then a execute a corresponding batch jobs on unix sever and fetch data from oracle database which is on remote... (2 Replies)
Discussion started by: refi123
2 Replies
write(1)						      General Commands Manual							  write(1)

NAME
write - interactively write (talk) to another user SYNOPSIS
DESCRIPTION
The command copies lines from your terminal to that of another user. When first called, it sends the message: to the receiving user's terminal. When it has successfully completed the connection, it also sends two bells to your own terminal to indi- cate that what you are typing is being sent. To set up two-way communication, the recipient of the message (user) must execute the command: (yourterminal is only required if the originator is logged in more than once.) Communication continues until an end of file is read from the terminal, an interrupt is sent, or the recipient executes At that point, writes on the other terminal and exits. To write to a user who is logged in more than once, use the terminal argument to indicate which line or terminal to send to (e.g., Other- wise, the first writable instance of the user found in database is assumed and the following message is displayed: terminal ... Permission to write may be denied or granted with the command (see mesg(1)). Writing to others is normally allowed by default. Certain commands, in particular and disallow messages in order to prevent interference with their output. However, if the user has the appropriate privileges, messages can be forced onto a write-inhibited terminal. If the character is found at the beginning of a line, calls the POSIX shell (see sh-posix(1)) to execute the rest of the line as a command. The following protocol is suggested for using When you first to another user, wait for the user to back before starting to send. Each per- son should end a message with a distinctive signal (such as "" for "over") so that the other person knows when to reply. Similarly, the signal "" (for "over and out") can be used to indicate the end of the conversation. EXTERNAL INFLUENCES
Environment Variables determines the locale to use for the locale categories when both and the corresponding environment variable (beginning with do not specify a locale. If is not set or is set to the empty string, a default of "C" (see lang(5)) is used. determines the format and contents of date and time strings. determines the language in which messages are displayed. If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are set to "C". See environ(5). International Code Set Support Single- and multi-byte character code sets are supported. DIAGNOSTICS
The user you are trying to write to is not logged on. Your correspondent has denied write permission after your session started. Your session is ended. Your correspondent sent end-of-file, or you set your terminal to and your correspondent tried to write to you. If you have a session established, you can continue to write to your correspondent. The user you are trying to write to has denied write permission (with Your terminal is set to and the recipient cannot respond to you. EXAMPLES
By issuing the command: user sends a message to user screen. If responds: two-way communication between and is established. FILES
To find user To execute shell commands SEE ALSO
elm(1), mail(1), mailx(1), mesg(1), nroff(1), pr(1), sh-posix(1), sh(1), who(1), utmpd(1M), getutsent(3C). STANDARDS CONFORMANCE
write(1)
All times are GMT -4. The time now is 06:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy