Sqlplus not working through ssh

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

"SQLPLUS -S " is not working in one environment where same code is working in another

"SQLPLUS -S " is not working in one environment where same code is working in another getting below error =================================== SQL*Plus: Release 11.2.0.3.0 Production Copyright (c) 1982, 2011, Oracle. All rights reserved. Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus...

2. Shell Programming and Scripting

Ssh does not support sqlplus and sudo -i?

Hey everybody, currently I am having an issue that I need to open an ssh session to a remote host, once on the remote host I need to use sudo and then execute sqlplus. Once the sqlplus call is open I need to execute one command while the sqlplus is active. For example show sga. I already got so...

3. Shell Programming and Scripting

Working with UTF char sqlplus

I have below SQL that I wasnt to run from a solaris machine using sqlplus select * from TABLE_NAME where regexp_like(field_value, 'Α|Β|Γ|Δ|Ε|Ζ|Η|Θ|Ι|Κ|Λ|Μ|Ν|Ξ|Ο|Π|Ρ|Σ|Τ|Υ|Φ|Χ|Ψ|Ω|α|β|γ|δ|ε|ζ|η|θ|ι|κ|λ|μ|ν|ξ|ο|π|ρ|σ|τ|υ|φ|χ|ψ|ω'); When I cat the file UTF char shows perfect however when i run...

4. AIX

SQLPLUS -S option not working

Hi All, I am using the following script to run some sql on database but i am not getting the result. When i tried the same by removing "-s" option it is working fine but getting other things as well with my input as shown below. Can anyone please suggest why "-s" option is not working in AIX and...

5. Shell Programming and Scripting

Ssh not supporting sudo and sqlplus commands

Hi Guys , I was facing an issue some thing like , I have to connect remote machine and should execute few commands over there , I am able to run some simple commands , but below commands are throws error like not found. eg : sudo su - username and sqlplus user/pwd@db , srvrmgr commands etc ...

6. UNIX for Dummies Questions & Answers

SSH tunnel working for ssh but not for sshfs

I'm trying to setup a link between my home pc (work-machine) and a server at work (tar-machine) that is behind a gateway (hop-machine) and not directly accessible. my actions: work-machine$ ssh -L 1234:tar-machine:22 hop-machine work-machine$ ssh -p 1234 user@127.0.0.1 - shh access on...

7. Shell Programming and Scripting

Sqlplus Set Heading not Working

Hello, Could someone tell me why this still returns headings? echo "SELECT columnA from tableA group by columnA;" | sqlplus -s ${DB_CONNECT} set heading OFF | while read line do arr="$line" echo ${arr} let i=$i+1 done

8. Solaris

SSH: internal working but external not working

Hi, This is a strange issue: We have an sftp server. Users can ssh to it from internal LAN without any issue, but they can not ssh to it externally via firewall. Here is what I got: OS is Solaris 9. No hosts.allow and hosts.deny files. Please help. Thank you in advance!

9. Shell Programming and Scripting

sqlplus @ not working sqlplus \@ working..

Hi All, I am facing a strange problem on one of my unix servers. When i try to login using the standard method: it fails with below message >sqlplus REF1SSTDBO1/REF1SSTDBO1@TKS3N10G > TKS3N10G ksh: TKS3N10G: not found But it works perfectly when i escape with ;\ >sqlplus...

10. Shell Programming and Scripting

Multiple SQLPLUS background processes not working properly

Hi All, I am running 25 background process from a Unix shell script which calls a single Oracle procedure with different paramenters each time. These 25 process creates 25 different files. When i run these 25 Background SQLPLUS processes, few files are not created completly but if i run 25...

LEARN ABOUT NETBSD

newgrp

NEWGRP(1)						    BSD General Commands Manual 						 NEWGRP(1)

NAME

     newgrp -- change to a new primary group

SYNOPSIS

     newgrp [-l] [group]

DESCRIPTION

     The newgrp command changes a user to a new primary group (real and effective group ID) by starting a new shell.  The user remains logged in
     and the current directory and file creation mask remain unchanged.  The user is always given a new shell even if the primary group change
     fails.

     The newgrp command accepts the following options:

     -l      The environment is changed to what would be expected if the user actually logged in again.  This simulates a full login.

     The group is a group name or non-negative numeric group ID from the group database.  The real and effective group IDs are set to group or the
     group ID associated with the group name.

     If group is not specified, newgrp restores the user's real and effective group IDs to the user's primary group specified in the password
     database.	The user's supplementary group IDs are restored to the set specified for the user in the group database.

     If the user is not a member of the specified group, and the group requires a password, the user will be prompted for the group password.

FILES

     /etc/group 	 The group database
     /etc/master.passwd  The user database
     /etc/passwd	 A Version 7 format password file

EXIT STATUS

     If a new shell is started the exit status is the exit status of the shell.  Otherwise the exit status will be >0.

SEE ALSO

     csh(1), groups(1), login(1), sh(1), su(1), umask(2), group(5), passwd(5), environ(7)

STANDARDS

     The newgrp command conforms to IEEE Std 1003.1-2001 (``POSIX.1'').

HISTORY

     A newgrp command appeared in Version 6 AT&T UNIX.	A newgrp command appeared in NetBSD 5.0.

BUGS

     There is no convenient way to enter a password into /etc/group.  The use of group passwords is strongly discouraged since they are inherently
     insecure.	It is not possible to stop users from obtaining the encrypted password from the group database.

BSD
								   June 6, 2007 							       BSD

Shell Programming and Scripting