oracle10g - Oracle 10 g - Setting up ODBC Connections and what is TNSNames.ora -


i not understand how oracle works. first tryst oracle, please accept apologies if questions sounds silly or ridiculously silly.

the oracle dba team creates database or schema (what difference?). let call sit_release2. setup odbc connections it. have file called tnsnames.ora resides in oracle_home\network\admin path.

the tnsnames.ora has following information

sit = (description = (address_list = (address = (protocol = tcp)(host = "ipaddress")(port = 1875)) ) (connect_data = (sid = "sit") (server = dedicated) ) )

now, odbc connection exists different database or schema (name of sit_release1) below. alt text

the data source name populated value.

the description populated value.

the tns service name populated value of sit

the user id populated.

question

the tnsnames.ora specifies server connecting , listening via port.

where specifying odbc connection points particular database?

edit

answer

i still not understand how works. happened -

the sid="sit" still remains such, credentials give point different databases.

so, in above screenshot, tns service name still same. however, username/password different , able connect different database.

its sid="sit" part points database.

the oracle system id (sid) used uniquely identify particular database on system.

for reason, 1 cannot have more 1 database same sid on computer system

refer here or here more details.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc...
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use...
Read more