| View previous topic :: View next topic |
| Author |
Message |
Xophmeister
n00b
Joined: 22 Apr 2006
Posts: 10
Location: Cheltenham, England
|
 Posted: Mon Sep 03, 2007 4:24 pm Post subject: Oracle 10gR2 Problem at DBCA Stage |
 |
|
Hi all,
I'm installing Oracle 10gR2 on to my Gentoo box, following the HOWTO on the Gentoo Wiki. I have got as far as running dbca, to create the database, but it's failing at the final hurdle (i.e. when you've set everything up and let it do its thing)... I keep getting "ORA-12547" errors (TNS: lost contact). From what I've found online, a possible reason is due to libaio -- but I've followed the guidance here and still can't get it to work.
Any ideas?
Thanks 
_________________
Christopher Harrison |
|
| Back to top |
|
 |
massimo
Veteran
Joined: 22 Jun 2003
Posts: 1226
|
|
| Back to top |
|
|
Xophmeister
n00b
Joined: 22 Apr 2006
Posts: 10
Location: Cheltenham, England
|
| Posted: Tue Sep 04, 2007 9:27 am Post subject: |
|
|
No luck, I'm afraid 
I had a look at the logs and it said that it couldn't find libskgxp10.so -- this is an Oracle lib, which I ln'd into /usr/lib... Unfortunately, this didn't solve the problem either: DBCA is now finding the library, but it says it can't access it due to permission problems
| Code: | | oracleora10g: error while loading shared libraries: libskgxp10.so: cannot open shared object file: Permission denied |
I've checked the link is chown'd to oracle:oinstall, but this doesn't seem to make a difference. Furthermore, I'm now pretty much running-up to the limit of my UNIX knowledge here 
As such, any further ideas/suggestion/advice would be most gratefully received!
Thanks
_________________
Christopher Harrison |
|
| Back to top |
|
|
Xophmeister
n00b
Joined: 22 Apr 2006
Posts: 10
Location: Cheltenham, England
|
| Posted: Tue Sep 04, 2007 9:42 am Post subject: |
|
|
Just a little addendum to this...
I found online that a possible solution to this was to run "relink all", from the Oracle bin directory. This did indeed seem to work, in that it removed the TNS error -- however, it is now replaced with a number of different permission errors:
| Code: | | ORA-01031: insufficient privileges |
and
| Code: | | ORA-12705: Cannot access NLS data files or invalid environment specified |
If I go to my Oracle home's parent and do "chown oracle:oinstall -R oracle", then I get the TNS error. So I won't be doing that again!... It looks like I'm getting closer, but these errors mean nothing to me; and the permissions one is particularly vague!
_________________
Christopher Harrison |
|
| Back to top |
|
|
Xophmeister
n00b
Joined: 22 Apr 2006
Posts: 10
Location: Cheltenham, England
|
| Posted: Tue Sep 04, 2007 10:02 am Post subject: |
|
|
OK... I'm getting closer...
I found that I could bypass this error by resetting the NLS_LANG environment variable to null (i.e. "export NLS_LANG="). It actually created the database this time -- woohoo! -- but then, another error at the "Creating and starting Oracle instance" stage:
| Code: | ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-03114: not connected to ORACLE |
Now I'm definitely stuck! Google is telling me that I need to restart the Oracle instance -- presumably, this is what the installer is supposed to be doing... Any ideas before I throw the machine out the window!?
Thanks 
_________________
Christopher Harrison |
|
| Back to top |
|
|
|
Unsupported Software
