Home » Infrastructure » Linux » How can I sloved this problem:oracle 10g on fc5
How can I sloved this problem:oracle 10g on fc5 [message #264464] Mon, 03 September 2007 07:46 Go to next message
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 #264580 is a reply to message #264464] Mon, 03 September 2007 19:35 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

[oracle@localhost ~]$ lsnrctl staus

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-SEP-2007 22:06:05

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

NL-00853: undefined command "staus".  Try "help"
[oracle@localhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-SEP-2007 22:06:09

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=localhost.localdomain)(PORT=2484)))
TNS-12538: TNS:no such protocol adapter
 TNS-12560: TNS:protocol adapter error
  TNS-00508: No such protocol adapter

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
[oracle@localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-SEP-2007 22:06:18

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
TNS-01150: The address of the specified listener name is incorrect
 TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))

Listener failed to start. See the error message(s) above...
[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

Hope this will help more.
Re: How can I sloved this problem:oracle 10g on fc5 [message #264584 is a reply to message #264464] Mon, 03 September 2007 20:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>[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.


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
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 Go to previous messageGo to next message
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 #264773 is a reply to message #264683] Tue, 04 September 2007 09:44 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
using netmanager try to create a new listener and service.then try to connect using that service.
Re: How can I sloved this problem:oracle 10g on fc5 [message #264873 is a reply to message #264773] Tue, 04 September 2007 20:13 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

I can't use netmanager to create listener.
[oracle@localhost ~]$ netmgr
Exiting
java.lang.NullPointerException
        at oracle.ewt.lwAWT.BufferedApplet.<init>(Unknown Source)
        at oracle.sysman.emSDK.client.appContainer.WebApplication.<init>(WebApplication.java:752)
        at oracle.net.mgr.container.NetApplication.<init>(Unknown Source)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
        at java.lang.Class.newInstance0(Class.java:308)
        at java.lang.Class.newInstance(Class.java:261)
        at oracle.sysman.emSDK.client.appContainer.WebApplication.main(WebApplication.java:3316)
Re: How can I sloved this problem:oracle 10g on fc5 [message #265165 is a reply to message #264873] Wed, 05 September 2007 10:17 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Messsy..
Can you post your LISTNER.ORA setting?
Re: How can I sloved this problem:oracle 10g on fc5 [message #265242 is a reply to message #265165] Wed, 05 September 2007 21:53 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

This error messege is I got from the net manager when I use it to recreate a service:
Attempting to connect using userid: system
The test did not succeed.
ORA-12157: TNS:internal network communication error

There may be an error in the fields entered,
or the server may not be ready for a connection.


And this is the listener.ora file
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
  )


Re: How can I sloved this problem:oracle 10g on fc5 [message #265252 is a reply to message #264464] Wed, 05 September 2007 22:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>(HOST = localhost.localdomain)
IMO, This will never work

What did I say about listener.ora in an earlier reply?
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 Go to previous message
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!
Previous Topic: trouble in sending mails from linux
Next Topic: Differences between OEL and Redhat...and OEL and Unbreakable
Goto Forum:
  


Current Time: Fri Mar 29 04:12:20 CDT 2024