table name = schema name issue?
Title: table name = schema name issue? Are there any known issues to having a table name the same as its schema name? Such as EMPLOYEE table in the EMPLOYEE schema. Someone told me there was an issue when Oracle tried to resolve EMPLOYEE.EMPLOYEE in the code. Thanks in advance. Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321
Lengthy Table and/or column names
Title: Lengthy Table and/or column names Are there any issues to consider when naming tables and/or columns (length of column name)? I know the max length is 30 but some of the table names that my client wants to add (against my recommendation) look like Cobol and are pushing 30 characters. Just wanted to know if there are any potential performance issues or anything else I should warn them about. Thank in advance! Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321
RE: Freeware reverse engineer ER diagram from ODBC connection
Title: RE: Freeware reverse engineer ER diagram from ODBC connection Oracle Designer can do reverse engineering except Oracle calls it "Design Capture" now... -Original Message- From: Lyndon Tiu [mailto:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Freeware reverse engineer ER diagram from ODBC connection I found a couple of demo versions. One is from Sybase: http://www.sybase.com/detail?id=1020999 One is from TheKompany: http://www.thekompany.com/products/dataarchitect/demo.php3?PHPSESSID=328ec531c8c3db6bb4f5086963d866bf I heard that Oracle Designer can do this? Is this true? Last time I tried it I did not seem to find the function for this. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Development Vs. Production DBA
Title: RE: Slightly OT: Development Vs. Production DBA I agree 100%. I am fighting this battle as we speak. Many Duhvelopers think they can do it all until something goes wrong then guess who they call to bail them out. Then Damagement is breathing down your neck to get it fixed when you have no idea what happened neither does the Duhveloper! I think an organization needs to have clear policies in place and enforce them to the end. Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 8:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Slightly OT: Development Vs. Production DBA A "development DBA" is a developer who wants to design the schemas his/her application will rely on. I prefer calling them application designers, because that's what they are. Sometimes you have another role, that of "Application Administrator." This second group is for larger applications that sometimes require constant attention, esp. if user accounts have to be created, or custom views etc. ... or if the application wasn't ready for production and was placed into production anyway -- then it will require constant babysitting. Consultants come in usually to implement new projects, or to add features to an existing system. That makes them application designers or application developers. Sometimes (rarely) consultants are hired to tune systems, that would be a blend of DBA and application designer. This is rare though, usually the database layer is working properly it seems to me, if the DBA has been there for more than a year, has read a book or two, and has at least the echo of a conscience. A "production DBA" is responsible for ensuring that the structure beneath the application stays up and is tuned properly. He/she works with the system administrator(s) to ensure that the hardware and the Oracle software (rdbms, developer server, iAS, networking,...) are all working properly and as expected. I don't fully understand why developers (some developers) strive to be called a DBA. Here is my guess: Perhaps this distinction stays fuzzy in organizations because there is a constant tug-of-war for control over resources between the development and production groups. If an overlap can be created, then there is an opportunity to take over some of the other group's resources. Also, when responsibilities are not delineated clearly, there is an opportunity for one side to blame the other and management can never figure out who is doing what. I worked in a lab where we were implementing Good Laboratory Practice (GLP) for the Food and Drug Administration (FDA), there was supposed to be no overlap between positions. I noticed that the managers who played games and only thought about their own advancement didn't like GLP at all, they fought it tooth and nail. I liked the idea of separate each person's circle of responsibility myself. Why can't IT shops strive to do the same? Speaking as a DBA, it is my perception that developers tend to be project-oriented. That's fine, it's why they are there. But that tendency also means, when they see their deadlines coming, that they sometimes aren't keen on thinking long term. Perhaps it's not their fault, it's because of the way projects are funded. Which client wants to hear that for every project, money will have to be allocated for ongoing costs of maintenance, operation, upgrades every 2-3 years? No one wants to think about that when they only want to think about the great new things they will be able to do with the new application. Also, no one wants to spend more money than necessary, so there is a tendency to try to cut corners to get to the end of the project. That is probably why projects tend to be rushed into production. Once the projects are in production mode funding to finish the product dries up. That sometimes leaves the application designer off the hook and leaves the "production DBA" holding the bag. Finally, if you are designing a new project, the tendency is to try to retain control over as much of it as possible. If you declare yourself to be a "development DBA", then people are less likely to insist that you consult the DBA(s) during the design phase of a project. "What a bother that is, having to listen to other people -- it's "my" project! It will only slow us down... Worse, I will have to share the credit once the application works properly. That won't be as good for my career." If you know that the DBA in the organization is stubborn and intractable, then this is the route the application designers will try to take. I could draw up a list of things that can go wrong when DBAs are not involved in the design phase of a project, but I think all people need to do is brainstorm for ten minutes to get a list of 10 or more things that can go wrong...
RE: Database/system Crashing
Title: RE: Database/system Crashing I'm not sure about savecore but I do know that the disks are internal. No SAN... They're about to yank SUN's chain because they are trying to resolve this remotely and its taking too long. Hopefully we'll have something solid from SUN next week. I am going to check out this SUN patch. Thanks for sending! -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 1:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Here is the Sun patch 108727-16 that was related to our problem. Does the system have savecore running? You can try to symbolic link /var/adm to another disk. In our case Oracle never wrote anything to alert log because it was a system crash. Sounds like your system is having IO related issues. Is it internal disks? or SAN? -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Please do. Any information at this point will help. The only difference is that when it fails it doesn't even get to write the /var/adm/messages or the core dump. Oracle wasn't writing to the alert log file until I moved it off the root disk an onto another disk. That has helped but its definitely an OS problem. Is it possible to re-locate the messages and/or core dump file for UNIX to another disk? If we did, maybe it could write to it like Oracle was able to. I don't know if that's a possibility on the Unix system or does it have to reside on the root disk? Thanks in advance!Val -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 12:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Sorry for getting back to you late on this. In our case, the server crashes each time with CPU panic message in /var/adm/messages. We used adb to analyze the core dump and saw in each instance of the crash, NFS lead to it. It was trying to free memory twice which caused the panic. And talking to Sun confirmed that there was a bug in NFS. If you are interested in it I can send you the patch number. -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 5:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Richard, Yes this is a SUN platform. One SA now believes it is independent of the database since it happens when the database isn't running. I moved the background dest files to the other disk (other than the root disk.) Normally it would have crashed by now after starting the database and using Designer but so far so good. There are no error messages in /var/adm/messages. There's no core dump file either. Its like the system gets corrupt before it can write to the /var/adm/messages file. What were the symptoms of your Sun NFS related crashed and how did you diagnois the problem and what was the solution (if it were that simple) Val -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 4:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Sorry I missed the previous messages. Was this a Sun platform? Did the system crash with a CPU panic in /var/adm/messages? We resovled a Sun NFS related crashes a couple of months ago. Richard Ji -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 11:40 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Yes there are NFS mounts involved. What you said about the OS locks on the audit directory makes a lot of sense. My SA's are back to thinking it's a OS problem because it crashed again with the database shut down. The odd thing is that there is nothing written to the Oracle alert log file nor are there any entries in the trace files. But when the system is rebooted and I bring the db back up, Oracle knows it previously crashed and recovers itself. That's in
RE: Database/system Crashing
Title: RE: Database/system Crashing Please do. Any information at this point will help. The only difference is that when it fails it doesn't even get to write the /var/adm/messages or the core dump. Oracle wasn't writing to the alert log file until I moved it off the root disk an onto another disk. That has helped but its definitely an OS problem. Is it possible to re-locate the messages and/or core dump file for UNIX to another disk? If we did, maybe it could write to it like Oracle was able to. I don't know if that's a possibility on the Unix system or does it have to reside on the root disk? Thanks in advance!Val -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 12:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Sorry for getting back to you late on this. In our case, the server crashes each time with CPU panic message in /var/adm/messages. We used adb to analyze the core dump and saw in each instance of the crash, NFS lead to it. It was trying to free memory twice which caused the panic. And talking to Sun confirmed that there was a bug in NFS. If you are interested in it I can send you the patch number. -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 5:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Richard, Yes this is a SUN platform. One SA now believes it is independent of the database since it happens when the database isn't running. I moved the background dest files to the other disk (other than the root disk.) Normally it would have crashed by now after starting the database and using Designer but so far so good. There are no error messages in /var/adm/messages. There's no core dump file either. Its like the system gets corrupt before it can write to the /var/adm/messages file. What were the symptoms of your Sun NFS related crashed and how did you diagnois the problem and what was the solution (if it were that simple) Val -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 4:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Sorry I missed the previous messages. Was this a Sun platform? Did the system crash with a CPU panic in /var/adm/messages? We resovled a Sun NFS related crashes a couple of months ago. Richard Ji -----Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 11:40 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Yes there are NFS mounts involved. What you said about the OS locks on the audit directory makes a lot of sense. My SA's are back to thinking it's a OS problem because it crashed again with the database shut down. The odd thing is that there is nothing written to the Oracle alert log file nor are there any entries in the trace files. But when the system is rebooted and I bring the db back up, Oracle knows it previously crashed and recovers itself. That's in the alert log file. Its like the system is losing its pointers or something. I suggested reinstalling the OS and Oracle then put my database back and see if that helps. Are there huge risks with this scenario? Another odd thing that the SA's can't figure out is there are no entries in the message file nor can they get a dump file to determine why the system crashed. There is nothing. It crashed over the weekend with no activity and they got some sort of i-nodes error. Thanks for all your replies. Any ideas are helpful and I will relay them to our SA's... Val -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Database/system Crashing I wonder if a file lock is being left in place when the instance crashes, and the OS does not clear the lock until a reboot. I would think the OS should clear this without a reboot, but stranger things have been seen with OS's ... even Unix. This doesn't explain why the instance crashes. I wonder if fuser would show anything. Are there any NFS mounts involved? -Original Message- Yes, you're correct and it can write the file to $
RE: Protecting schema changes
Title: Protecting schema changes Super! Is it okay to grant 'select any table' or should it be object specific? I'd think object specific would be more secure. Thanks for your help and have a nice weekend too! Val -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, January 10, 2003 3:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Protecting schema changes Val, 1). Create a role. Grant select, insert, update and delete of all the tables, views, sequences, procedures, packages and functions used by the application to this role. 2). create public synonyms for the objects in the application synonym. 3). create an "application" account that will be used by the application to connect to the database. 4). grant the role to the application account. 5). tell the applications group to change their JDBC procedure to connect to this new account. 6). then change the password to the application schema account. tell them that changes to this account will now be controlled by you - the DBA. problem solved. they can still play in their own account, but changes to the schema account is now controlled by you. once you move beyond the development environment, do not give them the ability to create anything in the database - only create query accounts for them to look at the data. hope this helps and have a nice weekend. Tom Mercadante Oracle Certified Professional -Original Message-----From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Friday, January 10, 2003 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: Protecting schema changes In a n-tier system that connects to the database with JDBC, how does a DBA keep developers from modifying the application schema without the DBA's consent or knowledge in a centralized development environment? The developers can have their own personal database on their desktops to program/test with but we have a problem with them making changes to the main development database as the application schema owner. They know/have the application schema username/password since it is used to make the JDBC connections to the database from the app server. Does anyone have links to defined change control processes that might help? Thanks in advance! Val Valerie H. WebberManagement Systems Designers, Inc Database Administrator[EMAIL PROTECTED]704-566-5321
Protecting schema changes
Title: Protecting schema changes In a n-tier system that connects to the database with JDBC, how does a DBA keep developers from modifying the application schema without the DBA's consent or knowledge in a centralized development environment? The developers can have their own personal database on their desktops to program/test with but we have a problem with them making changes to the main development database as the application schema owner. They know/have the application schema username/password since it is used to make the JDBC connections to the database from the app server. Does anyone have links to defined change control processes that might help? Thanks in advance! Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321
RE: Orawomen
Title: RE: Orawomen I have worked in IT in private industry and government for the past 15 years. Unfortunately, I have encountered a lot (not all) of men who have great difficulty accepting women in IT. Its hard at times especially when a woman says something and it is denounced or ignored then a man says the exact same thing and its the greatest idea ever. (this response is from other men in IT) I think a lot of women in IT are just getting fed up with it and finding something else. Do men feel threatened my women who are smart and know something they don't know? I don't feel that way about men who are smarter than I am. I just try to learn from them. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: Orawomen Pleeese let's not bring up either Janet Reno's or John Ashcroft's posterior. The mental image is way too disturbing. Jim -Original Message- Sent: Wednesday, January 08, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Same from me...I just get so tired of explaining that subtle discrimination is just as bad, if not worse than overt discrimination. If people put the same importance on the looks of men I wonder if Steven Hawkins would be taken seriously, or Einstein (a bad hair life). How many references did we have to listen to about Madelain Albrights looks, or Janet Reno's. Do we hear about Ashcroft's looks, or butt, or whatever? Or Koko's? Or Cheney's? We hear about their opinions, ideas, policies...but not their looks. Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database/system Crashing
Title: RE: Database/system Crashing No sorry... just a simple 2 disk development Unix box... Sun Solaris 8 -Original Message-From: Burke, William F (Bill) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 5:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing I'm late on this thread... Is this a SAN which is mirrored by any chance? Regards, Bill Burke "The Kinder and Gentler DBA" IOUG University Master Class Faculty 2001-2002 "iDBA Management, High Performance Infrastructure and HA" IOUG Board of Directors 2000-2002 ODTUG Board of Directors 1996-2000 www.OracleGuru.com www.KBMotorsports.biz -Original Message-----From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 2:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Dan, I meant to say that I found out why Oracle crashed. There is a bigger problem with the OS since it crashes when the db is down and it seems to lose parts of itself if that makes sense. After the OS "sorta crashes" or partially crashes, some Unix commands are invalid like CAT or MORE or even VI. The SAs are looking into it. I thought about re-creating the control file or replacing it with a good one but they like you think that is just a symptom of a bigger OS problem. Val -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 12:16 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Have you tried copying a known good controlfile in place of the bad one? If not, try it and report the result. If it corrupts as well, it seems to me that there is a much bigger problem. If it does not corrupt, then the question is, why didn't oracle report the corruption in the first place. I hate to say this, but I'm not certain you have found the problem, you may only be experiencing another symptom. Dan -----Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 9:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Well I relocated the background dest files and I got the following error... that was a great idea! ORA-00206: error in writing (block 3, # blocks 1) of controlfileORA-00202: controlfile: '/u04/oradata/ERCS/ora_control2'ORA-27063: Message 27063 not found; product=RDBMS; facility=ORASVR4 Error: 5: I/O errorAdditional information: -1Additional information: 2048error 221 detected in background process The SA's think its a data block corruption. If anyone has any additional information, it will be greatly appreciated. At least now I know why the database crashed to begin with. Now the SA's just have to figure out how to fix it. Thanks for all the help!! Val -Original Message-From: Burke, William F (Bill) [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing I'd agree with Dan. You need to find the root cause of the crash. If you rebuild to the current state from scratch, the odds are you'll see the same problem reoccur. Secondly, while NFS mounted volumes will work, they should always be a last resort as any network, remote IO load on the server where the NFS mounted volume lives "could" cause IO corruption and panic the host server. I didn't see the start of this thread so these are after the thought comments. Maybe they're helpful. Regards, Bill Burke "The Kinder and Gentler DBA" www.OracleGuru.com www.KBMotorsports.biz -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Not having an entry in the alert log or having trace files is not all that odd. This indicates a hard crash of the instance, where the background processes were unable to write to the files. This could be a result of the instance being forcefully terminated without using the Oracle shutdown process or it could be the result of the processes being
RE: Database/system Crashing
Title: RE: Database/system Crashing "PS.. do we all get a virtual "pass" on a future audit for helping? :)" ABSOLUTELY!! ;) -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 3:52 PMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: Database/system Crashing Val, if the unix commands are disappearing, then it sounds like you are either losing disk directories, or the paths that point at them. when I first read your post last week, I had a sneaky feeling that this was an OS problem and not an Oracle one. but not having anything solid to offer you, I just lurked until someone with better unix experience could help. glad you are "on your way" to figuring it out. PS.. do we all get a virtual "pass" on a future audit for helping? :) Tom Mercadante Oracle Certified Professional -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 3:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Dan, I meant to say that I found out why Oracle crashed. There is a bigger problem with the OS since it crashes when the db is down and it seems to lose parts of itself if that makes sense. After the OS "sorta crashes" or partially crashes, some Unix commands are invalid like CAT or MORE or even VI. The SAs are looking into it. I thought about re-creating the control file or replacing it with a good one but they like you think that is just a symptom of a bigger OS problem. Val -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 12:16 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Have you tried copying a known good controlfile in place of the bad one? If not, try it and report the result. If it corrupts as well, it seems to me that there is a much bigger problem. If it does not corrupt, then the question is, why didn't oracle report the corruption in the first place. I hate to say this, but I'm not certain you have found the problem, you may only be experiencing another symptom. Dan -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 9:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Well I relocated the background dest files and I got the following error... that was a great idea! ORA-00206: error in writing (block 3, # blocks 1) of controlfileORA-00202: controlfile: '/u04/oradata/ERCS/ora_control2'ORA-27063: Message 27063 not found; product=RDBMS; facility=ORASVR4 Error: 5: I/O errorAdditional information: -1Additional information: 2048error 221 detected in background process The SA's think its a data block corruption. If anyone has any additional information, it will be greatly appreciated. At least now I know why the database crashed to begin with. Now the SA's just have to figure out how to fix it. Thanks for all the help!! Val -Original Message-From: Burke, William F (Bill) [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing I'd agree with Dan. You need to find the root cause of the crash. If you rebuild to the current state from scratch, the odds are you'll see the same problem reoccur. Secondly, while NFS mounted volumes will work, they should always be a last resort as any network, remote IO load on the server where the NFS mounted volume lives "could" cause IO corruption and panic the host server. I didn't see the start of this thread so these are after the thought comments. Maybe they're helpful. Regards, Bill Burke "The Kinder and Gentler DBA" www.OracleGuru.com www.KBMotorsports.biz -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Not having an entry in the alert log or having trace files is not all that odd. This indicates a hard cras
RE: Database/system Crashing
Title: RE: Database/system Crashing Dan, I meant to say that I found out why Oracle crashed. There is a bigger problem with the OS since it crashes when the db is down and it seems to lose parts of itself if that makes sense. After the OS "sorta crashes" or partially crashes, some Unix commands are invalid like CAT or MORE or even VI. The SAs are looking into it. I thought about re-creating the control file or replacing it with a good one but they like you think that is just a symptom of a bigger OS problem. Val -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 12:16 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Have you tried copying a known good controlfile in place of the bad one? If not, try it and report the result. If it corrupts as well, it seems to me that there is a much bigger problem. If it does not corrupt, then the question is, why didn't oracle report the corruption in the first place. I hate to say this, but I'm not certain you have found the problem, you may only be experiencing another symptom. Dan -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 9:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Well I relocated the background dest files and I got the following error... that was a great idea! ORA-00206: error in writing (block 3, # blocks 1) of controlfileORA-00202: controlfile: '/u04/oradata/ERCS/ora_control2'ORA-27063: Message 27063 not found; product=RDBMS; facility=ORASVR4 Error: 5: I/O errorAdditional information: -1Additional information: 2048error 221 detected in background process The SA's think its a data block corruption. If anyone has any additional information, it will be greatly appreciated. At least now I know why the database crashed to begin with. Now the SA's just have to figure out how to fix it. Thanks for all the help!! Val -Original Message-From: Burke, William F (Bill) [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing I'd agree with Dan. You need to find the root cause of the crash. If you rebuild to the current state from scratch, the odds are you'll see the same problem reoccur. Secondly, while NFS mounted volumes will work, they should always be a last resort as any network, remote IO load on the server where the NFS mounted volume lives "could" cause IO corruption and panic the host server. I didn't see the start of this thread so these are after the thought comments. Maybe they're helpful. Regards, Bill Burke "The Kinder and Gentler DBA" www.OracleGuru.com www.KBMotorsports.biz -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Not having an entry in the alert log or having trace files is not all that odd. This indicates a hard crash of the instance, where the background processes were unable to write to the files. This could be a result of the instance being forcefully terminated without using the Oracle shutdown process or it could be the result of the processes being unable to write to the device containing the log and trace files. Try moving the background_dump_dest to another device (preferably internally connected to the server). I would not reinstall the OS and Oracle unless it can be reasonably determined that the OS is causing the problem. What are the reasons the SAs say it is the OS? It is a lot of work to recreate the system and you have no guarantee that this will solve it. It sounds like a more detailed inspection of all the systems is in order instead of spinning the 'Wheel Of Blame' to stop on the 'most likely' suspect. More troubleshooting is called for, not the drastic step of "wipe it clean and start over" Dan Fink -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 9:40 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Yes there are NFS mounts involved. What you said about the OS locks on the audit directory makes a lot of sense. My SA's are
RE: Database/system Crashing
Title: RE: Database/system Crashing Well I relocated the background dest files and I got the following error... that was a great idea! ORA-00206: error in writing (block 3, # blocks 1) of controlfileORA-00202: controlfile: '/u04/oradata/ERCS/ora_control2'ORA-27063: Message 27063 not found; product=RDBMS; facility=ORASVR4 Error: 5: I/O errorAdditional information: -1Additional information: 2048error 221 detected in background process The SA's think its a data block corruption. If anyone has any additional information, it will be greatly appreciated. At least now I know why the database crashed to begin with. Now the SA's just have to figure out how to fix it. Thanks for all the help!! Val -Original Message-From: Burke, William F (Bill) [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing I'd agree with Dan. You need to find the root cause of the crash. If you rebuild to the current state from scratch, the odds are you'll see the same problem reoccur. Secondly, while NFS mounted volumes will work, they should always be a last resort as any network, remote IO load on the server where the NFS mounted volume lives "could" cause IO corruption and panic the host server. I didn't see the start of this thread so these are after the thought comments. Maybe they're helpful. Regards, Bill Burke "The Kinder and Gentler DBA" www.OracleGuru.com www.KBMotorsports.biz -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Not having an entry in the alert log or having trace files is not all that odd. This indicates a hard crash of the instance, where the background processes were unable to write to the files. This could be a result of the instance being forcefully terminated without using the Oracle shutdown process or it could be the result of the processes being unable to write to the device containing the log and trace files. Try moving the background_dump_dest to another device (preferably internally connected to the server). I would not reinstall the OS and Oracle unless it can be reasonably determined that the OS is causing the problem. What are the reasons the SAs say it is the OS? It is a lot of work to recreate the system and you have no guarantee that this will solve it. It sounds like a more detailed inspection of all the systems is in order instead of spinning the 'Wheel Of Blame' to stop on the 'most likely' suspect. More troubleshooting is called for, not the drastic step of "wipe it clean and start over" Dan Fink -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 9:40 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Yes there are NFS mounts involved. What you said about the OS locks on the audit directory makes a lot of sense. My SA's are back to thinking it's a OS problem because it crashed again with the database shut down. The odd thing is that there is nothing written to the Oracle alert log file nor are there any entries in the trace files. But when the system is rebooted and I bring the db back up, Oracle knows it previously crashed and recovers itself. That's in the alert log file. Its like the system is losing its pointers or something. I suggested reinstalling the OS and Oracle then put my database back and see if that helps. Are there huge risks with this scenario? Another odd thing that the SA's can't figure out is there are no entries in the message file nor can they get a dump file to determine why the system crashed. There is nothing. It crashed over the weekend with no activity and they got some sort of i-nodes error. Thanks for all your replies. Any ideas are helpful and I will relay them to our SA's... Val
RE: Database/system Crashing
Title: RE: Database/system Crashing Richard, Yes this is a SUN platform. One SA now believes it is independent of the database since it happens when the database isn't running. I moved the background dest files to the other disk (other than the root disk.) Normally it would have crashed by now after starting the database and using Designer but so far so good. There are no error messages in /var/adm/messages. There's no core dump file either. Its like the system gets corrupt before it can write to the /var/adm/messages file. What were the symptoms of your Sun NFS related crashed and how did you diagnois the problem and what was the solution (if it were that simple) Val -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 4:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Val, Sorry I missed the previous messages. Was this a Sun platform? Did the system crash with a CPU panic in /var/adm/messages? We resovled a Sun NFS related crashes a couple of months ago. Richard Ji -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 11:40 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database/system Crashing Yes there are NFS mounts involved. What you said about the OS locks on the audit directory makes a lot of sense. My SA's are back to thinking it's a OS problem because it crashed again with the database shut down. The odd thing is that there is nothing written to the Oracle alert log file nor are there any entries in the trace files. But when the system is rebooted and I bring the db back up, Oracle knows it previously crashed and recovers itself. That's in the alert log file. Its like the system is losing its pointers or something. I suggested reinstalling the OS and Oracle then put my database back and see if that helps. Are there huge risks with this scenario? Another odd thing that the SA's can't figure out is there are no entries in the message file nor can they get a dump file to determine why the system crashed. There is nothing. It crashed over the weekend with no activity and they got some sort of i-nodes error. Thanks for all your replies. Any ideas are helpful and I will relay them to our SA's... Val -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Database/system Crashing I wonder if a file lock is being left in place when the instance crashes, and the OS does not clear the lock until a reboot. I would think the OS should clear this without a reboot, but stranger things have been seen with OS's ... even Unix. This doesn't explain why the instance crashes. I wonder if fuser would show anything. Are there any NFS mounts involved? -Original Message- Yes, you're correct and it can write the file to $ORACLE_HOME/rdbms/audit once the system is rebooted. Its just that when the database crashes, it can't write to that location until its rebooted. Is it possible that I need to beef up my init.ora parameters? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database/system Crashing
Title: RE: Database/system Crashing Yes there are NFS mounts involved. What you said about the OS locks on the audit directory makes a lot of sense. My SA's are back to thinking it's a OS problem because it crashed again with the database shut down. The odd thing is that there is nothing written to the Oracle alert log file nor are there any entries in the trace files. But when the system is rebooted and I bring the db back up, Oracle knows it previously crashed and recovers itself. That's in the alert log file. Its like the system is losing its pointers or something. I suggested reinstalling the OS and Oracle then put my database back and see if that helps. Are there huge risks with this scenario? Another odd thing that the SA's can't figure out is there are no entries in the message file nor can they get a dump file to determine why the system crashed. There is nothing. It crashed over the weekend with no activity and they got some sort of i-nodes error. Thanks for all your replies. Any ideas are helpful and I will relay them to our SA's... Val -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Database/system Crashing I wonder if a file lock is being left in place when the instance crashes, and the OS does not clear the lock until a reboot. I would think the OS should clear this without a reboot, but stranger things have been seen with OS's ... even Unix. This doesn't explain why the instance crashes. I wonder if fuser would show anything. Are there any NFS mounts involved? -Original Message- Yes, you're correct and it can write the file to $ORACLE_HOME/rdbms/audit once the system is rebooted. Its just that when the database crashes, it can't write to that location until its rebooted. Is it possible that I need to beef up my init.ora parameters? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database/system Crashing
Title: RE: Database/system Crashing Yes, you're correct and it can write the file to $ORACLE_HOME/rdbms/audit once the system is rebooted. Its just that when the database crashes, it can't write to that location until its rebooted. Is it possible that I need to beef up my init.ora parameters? Can low system/database resources make the system crash like this and make the system lose track of UNIX commands and/or file directories? I might add that there are 2 disks on this box and the Oracle server software is located on the same disk as root but a different slice. thanks for the reply Val -Original Message- From: Suzy Vordos [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: Database/system Crashing My mistake. The parameter is audit_file_dest, which is the location where audit files are written if audit_trail=os. By default audit_file_dest is $ORACLE_HOME/rdbms/audit. I suspect audit_file_dest is explicitly set to another location which either doesn't exist or lacks proper permissions. Suzy Vordos wrote: > > Check your init.ora for the audit_trail parameter. It's probably set to > write a file to a location that either doesn't exist or lacks proper > permissions. > > > Webber Valerie H wrote: > > > > I have a 8.1.7 repository database for Designer 9i (client) running on > > SUN Solaris 8. I can start the database up but when I access the data > > via Designer it crashes. I try to start it back up and I get the > > following message > > > > ORA-09925: Unable to create audit trail file > > SVR4 Error: 6: No such device or address > > Additional information: 9925 > > > > This happens even after I have removed all of the .aud files from > > $ORACLE_HOME/rdbms/audit. > > > > Can anyone give me some clues as to what the problem might be? How do > > you determine whether it's a hardware problem or a database problem. I > > have checked everything I know to check as far as the database is > > concerned. Nothing major has changed on this system since or before > > this started. > > > > I think its a hardware problem (controller/buffer cache/data block ?) > > because after my database crashes the UNIX system doesn't work > > properly. For example, sometimes I can't even do a ps -ef or cat/more > > a file. The SA can't reboot the system without flipping the switch but > > still thinks its a database problem. Once the SA flips the switch > > (fsck runs fine) then I can start the database. The UNIX system has > > hung on one occasion with the database shutdown. It also happened once > > in the middle of a cold backup of the database. > > > > Thanks in advance! > > Val > > > > Valerie H. Webber > > Management Systems Designers, Inc > > Database Administrator > > [EMAIL PROTECTED] > > 704-566-5321 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database/system Crashing
Title: Database/system Crashing I have a 8.1.7 repository database for Designer 9i (client) running on SUN Solaris 8. I can start the database up but when I access the data via Designer it crashes. I try to start it back up and I get the following message ORA-09925: Unable to create audit trail file SVR4 Error: 6: No such device or address Additional information: 9925 This happens even after I have removed all of the .aud files from $ORACLE_HOME/rdbms/audit. Can anyone give me some clues as to what the problem might be? How do you determine whether it's a hardware problem or a database problem. I have checked everything I know to check as far as the database is concerned. Nothing major has changed on this system since or before this started. I think its a hardware problem (controller/buffer cache/data block ?) because after my database crashes the UNIX system doesn't work properly. For example, sometimes I can't even do a ps -ef or cat/more a file. The SA can't reboot the system without flipping the switch but still thinks its a database problem. Once the SA flips the switch (fsck runs fine) then I can start the database. The UNIX system has hung on one occasion with the database shutdown. It also happened once in the middle of a cold backup of the database. Thanks in advance! Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321
RE: Happy Holidays!!
Title: RE: Happy Holidays!! I'm an "Orawoman" (I love that term) and a mother of 3 children (twin Kindergarteners and a 4th grader.) I'm a lurker too but usually 20 people have already answered the question by the time I read the posts. I must admit too that this list has helped me stay one step ahead of my male IT co-workers! Sorry that I won't be at IOUG... Happy Holidays! Val Valerie H. WebberManagement Systems Designers, Inc Database Administrator[EMAIL PROTECTED]704-566-5321 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 1:46 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Happy Holidays!! No offense guys, but having only small boy children (whom I love dearly), working in a 90% male IT support organization (cause I like men) - can't help feeling like what I really need now is some good woman friends - preferably ones that both work and are raising children. Are any of them going to IOUG? -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 11:40 AM To: Multiple recipients of list ORACLE-L Subject: Re: Happy Holidays!! from what Jared tells me, in the first 50 names on the list (alphabetical>?) he found 11 out of 50 names that were obviously female first names. not the best statistic (1/5 of an admittedly small sample). but better than it was a few years ago. What I really like seeing is that more and more women are answering questions here as well --- Lisa Corell Auerbach <[EMAIL PROTECTED]> wrote: > Hi Rachel - you wrote - > > > I'm more interested in the numbers to see if this field is less > male-centric than others. > > > > I don't post very often, but I'm another in the orawoman category. > > Lisa > (now the DBA at Henrico County Public Schools) > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Lisa Corell Auerbach > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dev tools for web-based apps
Title: Dev tools for web-based apps What development tools (Oracle Forms, Java/JDeveloper) are your shops using to deploy new applications to the web? Or what Oracle tool would you recommend to Developers? My client is wanting to re-design an application (currently written in C) using Oracle Forms (partly due to a "shorter" learning curve with Forms.) The application will contain a great deal of complex business rules and consistency checks. I might add that product in production date is late 2005. I have concerns about Forms' performance issues in running a huge applet and mainly Forms' life expectancy. It appears to me that Oracle's focus and future is with Java and JDeveloper. Am I off base here? Thanks in advance! Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321
RE: White papers on industry trends
Title: RE: White papers on industry trends Dick, Thanks for the information. You make a good point about learning curve (which is a concern the client has too) and about breaking up the C code. Yes, I am a contractor with the IRS but this project was always written in C. Never in Ada.. thank goodness... Currently the system runs on an Informix database but will be converted to Oracle since it is the new IRS system of choice. (Good move) I was just concerned that keeping the C would be keeping a dinosaur in the backyard out of fear of a learning curve. We have the time to convert it and deal with the learning curve. The C code is pretty much spaghetti code after 17 years of band-aids and duct tape. It desperately needs to be reworked/redesigned not to mention adding Pro*C. We have a sister project that chucked all their C code and rewrote everything in Java. It was tough but the payoff was great. We may have to decide on a module-by-module basis. Ada... now there's a dinosaur if I ever heard of one... :) Val -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject: Re:White papers on industry trends Valerie, C is still a very heavily used language, although for a complete application I'd probably want to use a C++ variant since they come with screen painter tools. Migrating from C to Forms/Reports would not be unthinkable, but don't underestimate the learning curve. As far as eliminating the external procedure call, if that's the way the application is written, then your stuck and no it will not be eliminated. What may then be more efficient is to take that C code & break it up into what is database only and what is C only. Then re-code the application as PL/SQL (or stored Java if your so inclined) keeping in pure C only that which cannot be done otherwise. The industry trend I would have to say is headed towards thin clients and three tier applications which serve internal and external customers and Java. While I agree with the trend in many cases there are too many times that the trend does not really fit the needs. In many a case we end up just moving the bottle neck from one place to the other & sometimes making it worse. Case in point is PeopleSoft. There is a panel in the stock room maintenance that updates several tables and rows. Now that is a two tier problem since a lot of data is moving from the server to the client, being processed, and then sent back. But we can id the bottleneck here in that the end user NEEDS a beefy PC. Now you move that into a three tier mess & the bottle neck gets harder to find since data moves from the database to the app server, to the client, gets processed & sent back to the apps server which does more processing, and then back to the database. Result, you still need the beefy PC on the client side, but you almost need a one to one setup on the app server as well. So then each client actually needs two beefy PC's to do the job in a reasonable manner. YUCK!! Who said thin client was easier & cheaper? Must have been some ignorant sales droid at the app server vendor. I note that your address is with the IRS, has the idea of doing Ada cropped up yet? OH, bad joke, it's suppose to be the government's "standard programing language" as declared by Congress back in the 80's. Then, PL/SQL is the Son of Ada!! Dick Goulet ________Reply Separator Author: Webber Valerie H <[EMAIL PROTECTED]> Date: 4/22/2002 5:28 AM Are there any white papers on industry trends for architecture including programming languages. I'm working on a project that is in the early stages of a redesign. The current application uses C code entirely including user interface. The client is sold on Oracle Forms/Reports but is reluctant to trash the C code and start from scratch. This is the first such redesign in 17 years. Does a 3 tier architecture using iAS minimize or eliminate the cost in performance of the external procedure call to the C program from a stored procedure? Any information will be helpful... Thank in advance, Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321 White papers on industry trends Are there any white papers on industry trends for architecture including programming languages. I'm working on a project that is in the early stages of a redesign. The current application uses C code entirely including user interface. The client is sold on Oracle Forms/Reports but is reluctant to trash the C code and start from scratch. This is the first such redesign in 17 years. Does a 3 tier architecture using iAS minimize or eliminate the cost in performance of the external procedure call to the C program from a stored proc
White papers on industry trends
Title: White papers on industry trends Are there any white papers on industry trends for architecture including programming languages. I'm working on a project that is in the early stages of a redesign. The current application uses C code entirely including user interface. The client is sold on Oracle Forms/Reports but is reluctant to trash the C code and start from scratch. This is the first such redesign in 17 years. Does a 3 tier architecture using iAS minimize or eliminate the cost in performance of the external procedure call to the C program from a stored procedure? Any information will be helpful... Thank in advance, Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321
SQL Command to view stored procedure
Title: SQL Command to view stored procedure What is the SQL command, v$ table or SQL*Plus command to see the contents of a stored procedure? I looked at DBA_SOURCE but it stored the code in separate rows based on the owner and procedure name. Is there any way to see the source code for OEM view of the procedures? It displays what I want to see but developer doesn't have access to OEM. Thanks in advance. Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321
RE: Oracle DBA evolution path - please share your opinion
Yes, I saw that... it was 77% and DBA was 4th or 5th on the list of highest demand -Original Message-From: Glenn Travis [mailto:[EMAIL PROTECTED]]Sent: Monday, February 26, 2001 3:47 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle DBA evolution path - please share your opinion I disagree. So does Parade magazine from yesterday's Sunday paper (for all you in the US that get it - it said that DBA demand is increasing 70% per year if I recalled the article correctly. I don't have it at work now, so please correct my numbers if you have it). -Original Message-From: andrey [mailto:[EMAIL PROTECTED]]Sent: Monday, February 26, 2001 11:41 AMTo: oralist@lists; [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: Oracle DBA evolution path - please share your opinion Dear List ! Some background : i've been around Oracle for several years , i'm DBAing for 2+ years now , i have written some java code (jdbc , some XML etc) , perl , PL/SQL , Tcl/Tk , a lot of UNIX scripting . .Where do i go to from here ? Many people say that the profession of Oracle DBA is going to be less demanded in future , because of : 1) either other DB ( like less-expensive MS SQL Server or free MySQL) will occupy the market , especially in small enterprises ; 2) or Oracle will "improve" the DB management and make it "point and click" , so you do not need a dedicated Oracle DBA at all or you need less Oracle DBAs . So , the bottom line is : what should i learn now ? how can i extend my expertise ? In which fields ? Please share your thoughts ! Thanks a lot in advance !