problem with a sqlplus client

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #220,140 by boxley 8/19/05 3:20:20 PM Reply	problem with a sqlplus client sqlplus name/passwd@SID works fine sqlplus name/passwd gets object not found. tnsnames.ora is pointing at the right hole any ideas? I have ORACLE_DB_SERVICE ORACLE_SID ORACLE_HOME TNS_ADMIN PATH=$PATH:$ORACLE_HOME/bin all populated correctly in the environment, what am I missing? thanx, bill "the reason people don't buy conspiracy theories is that they think conspiracy means everyone is on the same program. Thats not how it works. Everybody has a different program. They just all want the same guy dead. Socrates was a gadfly, but I bet he took time out to screw somebodies wife" Gus Vitelli Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org]
Post #220,142 by SpiceWare 8/19/05 3:26:35 PM Reply	Re: problem with a sqlplus client I don't know what you're missing, but check if a file called sqlnet.log was created. That file has helped me troubleshoot connection problems in the past. Darrell Spice, Jr. [link\|http://spiceware.org/gallery/ArtisticOverpass\|Artistic Overpass]\n[link\|http://www.spiceware.org/\|SpiceWare] - We don't do Windows, it's too much of a chore
Post #220,143 by boxley 8/19/05 3:33:54 PM Reply	creates one and here is the contents Fatal NI connect error 12545, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/export/home/oracle/product/9.2.0/bin/oracle)(ARGV0=oracleSID(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=( PROTOCOL=beq)))')(DETACH=YES))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=foo)(USER=root)))) it looks like it is trying the local box instead of the remote. Why would that be? thanx, bill "the reason people don't buy conspiracy theories is that they think conspiracy means everyone is on the same program. Thats not how it works. Everybody has a different program. They just all want the same guy dead. Socrates was a gadfly, but I bet he took time out to screw somebodies wife" Gus Vitelli Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org]
Post #220,151 by SpiceWare 8/19/05 4:43:03 PM Reply	Re: creates one and here is the contents I just tried running sqlplus from the command line and the same thing happens here if I don't put the @SID Darrell Spice, Jr. [link\|http://spiceware.org/gallery/ArtisticOverpass\|Artistic Overpass]\n[link\|http://www.spiceware.org/\|SpiceWare] - We don't do Windows, it's too much of a chore
Post #220,152 by ben_tilly 8/19/05 4:48:42 PM Reply	My attitude about sqlplus Once I figured out the syntax, I wrote a shell script per database I need to connect to and then forgot about it. :-) I also used a login.sql script that is slightly modified from what Tom Kyte suggests: \nset termout off\ndefine _editor=vi\nset serveroutput on size 1000000 format wrapped\n\ncolumn object_name format a30\ncolumn segment_name format a30\ncolumn file_name format a40\ncolumn name format a30\ncolumn file_name format a30\ncolumn what format a40 word_wrapped\ncolumn plan_plus_exp format a70\n\nset trimspool on\nset long 5000\nset linesize 80\nset pagesize 9999\n\ndefine gname=idle\ncolumn global_name new_value gname\nselect lower(user) \|\| '@' \|\| global_name global_name\nfrom global_name;\nset sqlprompt '&gname> '\nset termout on\n Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #220,154 by admin 8/19/05 4:59:32 PM Reply	tnsping is useful for debugging connection problems Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #220,419 by boxley 8/22/05 11:56:46 AM Reply	answer TWO_TASK=SID makes it work, never heard of it "the reason people don't buy conspiracy theories is that they think conspiracy means everyone is on the same program. Thats not how it works. Everybody has a different program. They just all want the same guy dead. Socrates was a gadfly, but I bet he took time out to screw somebodies wife" Gus Vitelli Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org]

problem with a sqlplus client - (boxley) - (6) - Aug. 19, 2005, 03:20:20 PM EDT

Re: problem with a sqlplus client - (SpiceWare) - (2) - Aug. 19, 2005, 03:26:35 PM EDT

creates one and here is the contents - (boxley) - (1) - Aug. 19, 2005, 03:33:54 PM EDT

Re: creates one and here is the contents - (SpiceWare) - Aug. 19, 2005, 04:43:03 PM EDT

My attitude about sqlplus - (ben_tilly) - Aug. 19, 2005, 04:48:42 PM EDT

tnsping is useful for debugging connection problems -NT - (admin) - Aug. 19, 2005, 04:59:32 PM EDT

answer TWO_TASK=SID makes it work, never heard of it -NT - (boxley) - Aug. 22, 2005, 11:56:46 AM EDT

iwethey.org

Prolly need to go back for "reeducation"...
47 ms