How can I sloved this problem:oracle 10g on fc5 [message #264464] |
Mon, 03 September 2007 07:46 |
snowball
Messages: 229 Registered: April 2006 Location: China
|
Senior Member |
|
|
Hi, everybody.
These days, I've tried to install oracle in our Linux Lab.All the computers here are installed FC5.First,I tried Oracle 9i on it,but it stoped at 18% and then crash.So,today,I've tried Oracle 10g,everything goes right expect the linking issue,but i used the file hacked.then it can go smoothy.But during the creation of database I met some dialogs ,tell me these errors:
1.File "etc/oratab" is not accessible.
and I pressed OK.
2.ORA-12157:TNS:internal network communication error.
and I pressed Ignore.After I pressed 10 times,it skiped a different dialog with OK button.After that,it skiped a Warning dialog says,
"Enterprise manager configuration failed due to the following error-Invalid username/password.Refer to the log file at
/u01/app/oarcle/product/10.2.0/db_1/cfgtoollogs/dbca/oracle/emConfig.log
for more detials.
You can retry configuring this database with Enterprise Manager later by manually running /u01/app/oracle/product/10.2.0/db_1/bin/emca script."
So I did a lot of search at google,but most of results without solutions.So hopes that somebody can help me.
By the way,this is a article I use for my oracle installation:
<a href="http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnFedora5.php" target="_blank">Reference</a>
Thanks,
snowball
[Updated on: Mon, 03 September 2007 07:49] Report message to a moderator
|
|
|
|
|
Re: How can I sloved this problem:oracle 10g on fc5 [message #264683 is a reply to message #264584] |
Tue, 04 September 2007 03:19 |
snowball
Messages: 229 Registered: April 2006 Location: China
|
Senior Member |
|
|
anacedent wrote on Mon, 03 September 2007 20:05 | >[oracle@localhost ~]$ sqlplus / as sysdba
>SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 3 22:06:44 2007
>Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
>ORA-12157: TNS:internal network communication error
12157, 00000, "TNS:internal network communication error"
// *Cause: Internal error during network communication.
// *Action: Not normally visible to the user. For further details, turn
// on tracing and reexecute the operation. If error persists, contact
// Worldwide Customer Support.
Thanks,
snowball
For V10.2 no listener.ora file is required.
You might want to try renaming your file out of the way so it never gets used.
BUT, I strongly suspect that this won't solve your problems(s).
Having a (functioning) listener is NOT required to start Oracle DB.
Use CUT & PASTE along with nice code tags (as previous post) & post what happens when you do while logged in as OS user "oracle" or which ever user owns/installed the Oracle s/w.
id
sqlplus
/ as sysdba
startup
|
This is what I got from the terminal,but the startup command can't work ,because I can't log in.
[oracle@localhost ~]$ id
uid=503(oracle) gid=503(oinstall) groups=503(oinstall),504(dba)
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 4 16:16:36 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12157: TNS:internal network communication error
Enter user-name: system
Enter password:
ERROR:
ORA-12157: TNS:internal network communication error
Enter user-name: system
Enter password:
ERROR:
ORA-12157: TNS:internal network communication error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[Updated on: Tue, 04 September 2007 03:20] Report message to a moderator
|
|
|
|
|
|
|
|
Re: How can I sloved this problem:oracle 10g on fc5 [message #534503 is a reply to message #264464] |
Tue, 06 December 2011 16:05 |
|
jakedatreble
Messages: 1 Registered: December 2011
|
Junior Member |
|
|
In repsonse to:
File "etc/oratab" is not accessible.
==================================================
This is because you missed an important step towards the end of Oracle 11g database installation.
Installer prompts you at 94% completion to run the following 2 scripts as root:
mountpoint/app/oraInventory/orainstRoot.sh
mountpoint/oracle/product/11.2.0/dbhome_1/root.sh
When this is done, the etc/oratab file is created and ORACLE_HOME and ORACLE_OWNER values are set.
Now return to the installer and hit OK to continue to completion.
This is on 11g. I'm sure this should fix the issue on 10g as well.
All relevant windows (from install on SuSE) can be seen in the attached screenshot. Hope this helps!
|
|
|