[09:55] -->| otay (n=chatzill@81-208-74-187.ip.fastwebnet.it) has joined #oracle [09:56] hello my friends my db host is called: dbserver , my table space iserv , my user id and pass: gabry . How can i connect me on thise DB from my notebook using sql plus? [10:05] -->| misty (n=misty@216.117.23.202) has joined #oracle [10:21] Robinsjostrom: try select * from "hello|table"; [10:22] Robinsjostrom: though i would strongly suggest you rename your table [10:25] hi, i [10:25] -->| Mr_You (n=car@cpe-071-076-161-238.triad.res.rr.com) has joined #oracle [10:28] otay: you still need to know the SID or service name of that instance [10:28] tablespace isn't relevant at all [10:28] otay: google around for OracleNet basics [10:28] sid is iserv [10:29] then you could connect with EasyConnect (I think that's the name) [10:29] or add an entry in your tnsnames.ora file either manually or via one of the two java utilities [10:29] easyconnect? i have downloaded oracle sql plus express client [10:29] i will use this. [10:30] then go nuts [10:30] I've no experience with express clients [10:31] rizzo: i have experience with a big penis and your mother under my desk. if you need RTFM dont google, just ask me .. i am your mother skilled developer. [10:31] http://blogs.ittoolbox.com/oracle/guide/archives/forget-about-tns-connect-to-oracle-using-easy-connect-7295?rss=1 [10:31] wtf [10:31] I don't know if the installation process is any better. A few years ago it lacked any setup for the network related config files (like tnsnames.ora or the libs). Be careful here. [10:31] -->| sekhmet (n=pez@ppp-70-226-146-235.dsl.mdsnwi.ameritech.net) has joined #oracle [10:32] -->| avaia (n=avaia@yosemite.cellcom.com) has joined #oracle [10:32] otay: wtf was that about [10:32] rtfm. [10:33] you're telling *ME* to rtfm? you're the one who was asking how to connect to the DB. [10:33] Once you set up the instant client properly, it'll be fine. But the config might not be done for you and may not be specified in the docs. [10:33] rizzo: i cant now explain you all the oracle stuff.. please google .. and learn how to logon i guess is : connect user/pass@host [10:34] [10:56] hello my friends my db host is called: dbserver , my table space iserv , my user id and pass: gabry . How can i connect me on thise DB from my notebook using sql plus? [10:34] lol [10:34] otay: You're confused. It was you who asked the question. [10:34] I'm confused too. [10:35] ready to bust out the /ignore [10:35] bust bust.. [10:35] who will thief me? [10:35] no I need to log this to show my friends later [10:35] otayyyyyyyyyyyyyyyyyy [10:36] rizzo: italiano del cazzo. [10:36] otay: This isn't a very large channel. Yuo don't really want people who normally/willingly help other to ignore you. [10:36] s/other/others [10:36] -->| misty_ (n=misty@216.117.23.202) has joined #oracle [10:37] Xgc: i dont want.. but if rizzo insult me in query [10:37] how's that? [10:37] otayyyyyy i burn your ass. and kill your family [10:38] otay: Don't bring that into the channel. That's unnecessary. Feel free to ignore anyone you wish. [10:38] oki [10:38] ... [10:38] i put now a ignore on rizzo.. and stop [10:38] thanks a lot [10:38] lol [10:39] someone please show me where I insulted him [10:39] my irc client must be hiding it from me [10:39] rizzo: He thinks you privately /msg'd him in an insulting way. [10:39] I did not [10:40] rest assured [10:40] and of course that could be entirely fabricated. [10:40] its IRC, get over it ;-) [10:40] don't make me pull this channel over! [10:40] haha [10:40] .. i have fabricated nothing [10:40] rizzo is still insult me in query now. [10:40] but i have ignored him. [10:41] so i can read no more him [10:41] then how do you know? [10:41] some second ago.. i bust the ignore.. [10:41] now nothing [10:41] I'm still wondering how it is that I insulted/still insult him [10:41] but it is ok.. its irc.. and there are such lamers like rizzo. [10:41] otay: I did that years ago, good idea. [10:41] ha [10:42] Hopefully my real Italian cousins will forgive the *.it /ignore. [10:42] razzist. [10:42] === otay New Now Know How [10:42] === otay: member of #oracle [10:42] === otay: attached to irc.freenode.net http://freenode.net/ [10:42] === otay is identified to services [10:42] --- End of WHOIS information for otay. [10:42] |<-- grove has left brown.freenode.net (Read error: 110 (Connection timed out)) [10:43] -->| grove (n=grove@062016244240.customer.alfanett.no) has joined #oracle [10:43] versus fake Italian cousins? [10:44] ;-) [10:44] I'm still wondering if otay said that HE's going to burn my ass and kill my family, or if he meant to suggest that I told HIM that. [10:44] * Mr_You is in an obnoxious mood.. time for food. [10:44] now otay is /msg'ing me [10:44] I bet no one in here cares. ;-) [10:44] [10:44] ..you are very bad . [10:44] Mr_You: DRAMA [10:45] which is rare in here.. hehe [10:45] #oracle is becoming mainstream? ;-) [10:45] Mr_You: I was invited here and I brought my popcorn, I demand satisfaction. [10:45] It's usually so nice and calm here. [10:45] hehe [10:46] except for when hali stays too long at the pub [10:47] hehe [10:48] and when rizzo will flame [10:49] |<-- misty has left brown.freenode.net (Read error: 110 (Connection timed out)) [10:50] doing a poor job of /ignoring me [10:52] * rizzo is doing the Log Buffer the week ending April 6th [10:52] beware [10:55] rizzo: i have removed the ignore on you after 10 minuts.. but you are always talking about me.. please stop [10:56] you are delusional [10:56] i forgot you to have insult my mother, father, brother and grandmother [10:56] now return to your script kiddie stuff [10:56] and forgot also me. [10:56] I have yet to insult *anyone* [10:57] all my family.. but is not important [10:57] You have a fascinating way of asking for help. Perhaps try it elsewhere so others may experience it. [10:57] -->| duck_tape (n=adi@64.74.221.28) has joined #oracle [10:57] otay: exactly how did I insult your family? [10:57] you will i paste you query? [10:58] please do. [10:59] excuse me public in channel or i nuke you with my bomber net. NOW. [10:59] no i will not. [10:59] wtf mother fucker! [11:00] and so on [11:00] I'm sorry, are you serious? [11:00] ok you are sorry [11:00] yes i am seriuous when you insult my mother [11:00] otay: i don't think you should stay in this channel [11:00] otay: you are welcome to leave now [11:00] -->| MilkmanDan (i=dannyd@cpe-65-185-90-40.neo.res.rr.com) has joined #oracle [11:01] hali: .. its not my fault.. it is rizzo.. [11:01] -->| superdug_ (n=superdug@24-196-94-222.dhcp.mdsn.wi.charter.com) has joined #oracle [11:01] use ignore, get over it. [11:01] but if you dont want me here.. i go out. .. but the one that must go out is only rizzo. [11:02] otay: you should use easy connect [11:02] he's not bothering the channel. [11:02] 11:47:22 MilkmanDan did I ever tell you how much you mean to me? [11:02] flamer [11:02] -->| sargeantd (n=mike@adsl-68-249-7-33.dsl.milwwi.sbcglobal.net) has joined #oracle [11:02] otay: when was the last time you did a smegcheck? [11:02] never [11:03] what do you mean never? [11:03] are you serious? [11:03] otay: seriously when was the last time you did a smegcheck? [11:03] superdug today all the persone ask me : are you serious.. but i am not here for joke .. like rizzo [11:04] never [11:04] dude you need to do a smegcheck [11:04] <--| avaia has left #oracle ("Leaving") [11:04] oki thanks for advice [11:04] do you know what a smegcheck even is? [11:04] no, google dont help me [11:05] are you next to your oracle server or at least where you can physically have access to it? [11:05] i am in remote [11:05] he is in another room [11:05] ohhh geeze [11:05] okay ... but you can get into that other room? [11:05] no [11:05] ohhh man [11:06] :( [11:06] remote smegchecks aren't easy [11:06] in what consist ? [11:06] can you at least reboot the box remotely? [11:06] no [11:06] or maibe [11:06] yes [11:06] with vnc [11:06] yes you can reboot it? [11:06] yes [11:06] -->| snoopy_atw (n=eugenek@86.57.155.189) has joined #oracle [11:07] okay good ... a smegcheck is basically a way to clear up all the virtual "dust" in oracel [11:08] >hali< you dont have ops in #oracle? [11:08] ah understand [11:08] but superdug_ why i need a smeg check? [11:08] otay: first off you need to close all the applications on the remote box ... [11:08] you want to use easy connect right? [11:08] superdug_: no :( [11:08] you don't want to use easy connect? [11:08] i never want to use easy connect.. was rizzo thise [11:09] ohhh what did you want to use? [11:09] i will only know if with oracle express is possible use utl_snmtp ? [11:09] otay: yes oracle XE can use utl_smtp [11:09] This is going to turn out badly... [11:09] and how can i logon with oracle express client sql plys on my oracle normal [11:09] * MilkmanDan hopes someone logs it. [11:09] hali: thanks [11:09] ohh you just want to use sql plus? [11:09] yes [11:09] just this [11:09] perfect! [11:10] =) thanks [11:10] okay you just need to do a smegcheck on your machine [11:10] not the remote machine [11:10] ah [11:10] ok [11:10] but i have googled and smegcheck return me nothing... [11:10] you will need to reboot first ... reboot and come back in here [11:10] ok [11:11] |<-- otay has left brown.freenode.net ("Chatzilla 0.9.77 [Firefox 2.0.0.2/2007021917]") [11:12] if only we could /ban