 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Oracle / Oracle Server / July 2005Is it possible to change dbname?
I used dbca to create database creation scripts (oraclr 10.1.0.2) and for some reasons I ended up with: oracle_sid=adcdm01 db_dbname=adcinfo (hostname is adcinfops01) db_unique_name=adcdm01 I want all to be the same name as the oracle sid. Is this possible? What exactly is the difference between the oracle sid and the dbname? (I notice db_name is normally a fully qualified domain name) Thx, CC > I used dbca to create database creation scripts (oraclr 10.1.0.2) and > for some reasons I ended up with: [quoted text clipped - 10 lines] > Thx, > CC It is possible but resist the temptation. Doing so is of zero value.  SignatureDaniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond) > I want all to be the same name as the oracle sid. Is this possible? Why? (I'm curious to understand what business value there might be in doing this.) SignatureHans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** I no longer assist with top-posted newsgroup queries *** What exactly is db_name for? I just get so many issues when writing code (perl and php) that connects to oracle. You would think hostname:sid:port would work but it always doesnt. Search google returns scores of issues relating to this db_name paramter. Does it need to be a DNS-resolvable address for the host the database resides on? What purpose does it serve? All code is going to use hardcoded connection strings using either a) the oracle sid or b) an alias defined in tnsnames.ora -CC > What exactly is db_name for? I just get so many issues when writing > code (perl and php) that connects to oracle. You would think [quoted text clipped - 7 lines] > > -CC There is this document called the Net Services Manual: It makes excellent reading. SignatureDaniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond) Man I love these "I Hate Life" ritalin starved responses like this. Grow up. The dude was looking for a quick answer to a simpe question. Maybe he does 100 other things besides working with oracle and doesnt have the time. Man always crap like this in the DBA forums. Seems to be growing over time as well, since it was never this bad 10 years ago. If you can't be productive, don't contribute to the thread. What part of that don't you understand. I have seen scores of posts with your negativeness in them. Adopt a cat. Do some volumnteer work. It is safe to assume that EVERY post in the technical newgroups can be fixed by reading SOME manual. Yes I think so. People come to newsgroups for quick and easy resolutions to problems. Hmm. Yea let me read a 400 page book instead of finding a quick answewr to a colleague in a newsgrouop. Oh wait, just saw your sig, .edu. Never mind, that answers everything. > It is safe to assume that EVERY post in the technical newgroups can be > fixed by reading SOME manual. Yes I think so. People come to newsgroups > for quick and easy resolutions to problems. Hmm. Yea let me read a 400 > page book instead of finding a quick answewr to a colleague in a > newsgrouop. One of the reasons I reference manuals in my responses - there are often several ways to accomplish things. And often the first guess response is wrong and will lead to long term maintenance nightmares. In this day and age of Quick and Dirty programming, wrong seems to be acceptable in that the long term maintenance frequently comes from a different budget. Still, I HATE getting 3 AM calls because some Dodo got a quick answer on a newsgroup and applied it without understanding the implications. Sigh SignatureHans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** I no longer assist with top-posted newsgroup queries *** >> It is safe to assume that EVERY post in the technical newgroups can be >> fixed by reading SOME manual. Yes I think so. People come to newsgroups [quoted text clipped - 13 lines] > > Sigh True, but then what's the use of this newsgroup ? This newsgroup is not the "bible". Everyone can post in here. It's the responsiblity of the OP to at least verify the answers he's gotten. And those answers (even if incorrect) can often help him finding the solution to his problem much faster than semi-randomly searching through 50.000+ pages of documentation. And if getting 3AM calls to fix someone else's "mistakes" is part of your job, then i'm sure you are well paid for it. You can always change your job if you don't like it anymore. Just my 2 (euro)cents, Matthias Hoys > True, but then what's the use of this newsgroup ? The newsgroup is one of MANY resources available. If that provides answers, then fine. Sadly some come here first simply because they are too lazy to do any research on their own. I believe it should be one of the last places used, and most questions should be prefixed with "This is what I am trying to accomplish. This is the environment. This is WHY". An attempt to understand the environment before asking is always appreciated. Anyone looking into my past posts and replies will note that I prefer to tell people where to find the answer, mainly because one question leads to another and the answers are often found close together in the manual. I had hoped to give up spoon feeding people when my youngest son was out of diapers. It's always a surprise to me how few people know how to use an index or internet search. Speaking of which ... to OP - the Google search for "change dbname" gives some reasonable direction on the first search page, including the following link: http://www.oracle.com/technology/obe/paa/obe-mdb/html/Chg_DB_Name.htm -- Hans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** I no longer assist with top-posted newsgroup queries *** > Man I love these "I Hate Life" ritalin starved responses like this. > Grow up. [quoted text clipped - 17 lines] > > Oh wait, just saw your sig, .edu. Never mind, that answers everything. I guess i'm not making myself very "popular" with this reply (well, being an Oracle DBA isn't about being popular, as I experienced ;-)) but I believe that there's a lot of truth in your posting. Oracle is not an easy task to learn - I would like to call it a "challenge". Still, there's huge satisfaction once one start understanding the concepts - but that alone takes months of studying, research and hands-on experience. But, perhaps more difficult than learning and getting a grasp on the Oracle concepts yourself, is the fact of explaining those things to other people, often with a minimal Oracle background (junior developers, sysadmins, IT managers :-)). People ask questions in newsgroups because they are looking for a straightforward answer to an often complex problem :-) I believe we should always treat Oracle beginners (I hate the term "newbies") with respect. Simply referring to tahiti.oracle.com, Google or "RTFM" should be avoided and is - IMHO - impolite and showing a lack of respect to the OP. I'm sure that people who found this newsgroup know of the existence of Google ;-) Nobody is born with Oracle knowledge, everyone has to learn it from scratch (but it's also true that some people will never learn from their mistakes and some people should never have been given a PC in the first place ;-)) And, like "Perm" said : don't post if you don't have anything of value to add to the thread. This only leads to flame wars and wasted bandwidth. Matthias Hoys (already doing volunteer work, and thinking of adopting a cat :-)) >Simply referring to tahiti.oracle.com, Google or "RTFM" should be avoided >and is - IMHO - impolite and showing a lack of respect to the OP. I'm sure >that people who found this newsgroup know of the existence of Google ;-) But it is quite clear they never use it, and they never search. Also in many of those 'RTFM'-case simply searching for the term they provide on http://tahiti.oracle.com would have resulted in an immediate correct response. Now they have potentially to wait for hours. IMHO the lack of respect is on the side of the OP: he demonstrates he is too lazy to do anything himself, and he is prepared to have others do his work for him. When I started using Oracle I didn't have any access to Internet or Usenet at all, and likely it didn't even exist. So, YES, I did read all those manuals, and everyone can and should do that. -- Sybrand Bakker, Senior Oracle DBA >>Simply referring to tahiti.oracle.com, Google or "RTFM" should be avoided >>and is - IMHO - impolite and showing a lack of respect to the OP. I'm sure [quoted text clipped - 14 lines] > -- > Sybrand Bakker, Senior Oracle DBA Echoing what Sybrand has written I'd like to add that those that read them should reread them from time-to-time. The manuals are not static. Too many people find an answer on the web that gets them through the immediate crisis and never read the next sentence. SignatureDaniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond) [...snip...] > If you can't be productive, don't contribute to the thread. What part > of that don't you understand. I have seen scores of posts with your > negativeness in them. Adopt a cat. Do some volumnteer work. POT<==>KETTLE<==>BLACK > Man I love these "I Hate Life" ritalin starved responses like this. > Grow up. [quoted text clipped - 17 lines] > > Oh wait, just saw your sig, .edu. Never mind, that answers everything. The point is that changing a name is of zero value. A name is just a name and that the attempt to do so can be extremely dangerous. Thus ... "Why" is an appropriate question from which one can then determine whether matches are being put into the hands of someone that is lighting a car flare or a stick of dynamite. SignatureDaniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond) >What exactly is db_name for? I just get so many issues when writing >code (perl and php) that connects to oracle. You would think [quoted text clipped - 7 lines] > >-CC You are confusing the service_name of a database for the database name. I would be tempted to ask for more details on the 'score of issues' you mention. Most of these requests originate from people who just start hacking away, and who don't even read the 'Getting started manual' You are incorrect hostname:sid:port always doesn't work. In fact it does work for the jdbc thin driver. The rest of your questions can easily be clarified by reading the net documentation. -- Sybrand Bakker, Senior Oracle DBA |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.