Home » Other » Community Hangout » Hi everybody!
Hi everybody! [message #522168] |
Wed, 07 September 2011 01:54  |
 |
Baranor
Messages: 83 Registered: September 2011 Location: Netherlands
|
Member |
|
|
Hey folks,
Didn't see an actual introduction area, so I figured I'd post it here, seems to be the closest to Off Topic as it gets 
Name's Barry ( well, my internet alias is ), I'm 31 years old at the moment, work as a software engineer on a decent sized app (400+ forms) for governemental licensing and am really enjoying the Oracle Trade. I've been doing PL/SQL, Designer and Forms for about 5 years now, have my OCP ( got that within a year after I hopped over from the pharmaceutical industry) and for some reason this database stuff is right up my alley. Strange, considering I have an MSc in Biology O_o.
So, HI!
p.s. English is not my native language, I might make a mistake here and there.
|
|
|
|
|
|
Re: Hi everybody! [message #523618 is a reply to message #523498] |
Mon, 19 September 2011 09:37   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Oh, the error messages are actually quite good. One tip:
On each database server there is an utility "oerr" installed, that explains the cause of the error, and the action required to fix it.
It's called with
oerr [COMPONENT] [ERRORCODE]
for example:
oracle ~ $ oerr ora 12345
12345, 00000, "user %s lacks CREATE SESSION privilege in database link (linkname %s)"
// *Cause: There are several possible causes for this message:
// First, you will get this message if your username in the
// second database specified was not granted the
// CREATE SESSION system privilege.
// Second, you will get this message if the username specified
// in the connect string of the database link definition was
// not granted the CREATE SESSION system privilege.
// *Action: The action you take depends upon the cause of the message:
// In the first case, ensure that your username in the secondary
// database was granted the CREATE SESSION system privilege.
// In the second case, ensure the username specified in the
// connect string of the database link definition was granted
// the CREATE SESSION system privilege in the secondary database.
oracle ~ $
oracle ~ $ oerr tns 00000
00000, 00000, "Not An Error"
// *Cause: Everything is working as it should.
// *Action: Don't worry: Be happy.
oracle ~ $
|
|
|
|
Re: Hi everybody! [message #523716 is a reply to message #523641] |
Tue, 20 September 2011 02:16   |
 |
Baranor
Messages: 83 Registered: September 2011 Location: Netherlands
|
Member |
|
|
Hahahaha. I'll explore that option for sure next time I get an error I don't understand... its the funny little errors that you get that don't actually say what the problem is but point to something else at first that are strange.
[Updated on: Tue, 20 September 2011 02:17] Report message to a moderator
|
|
|
|
|
Goto Forum:
Current Time: Mon Apr 07 12:53:41 CDT 2025
|