Re: [suse-oracle] Oracle Installation Problem with SUSE 11 Enterprise server
"Chen Wu" <[email protected]> Tue, 02 Aug 2011 01:51:58 -0600
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Message-ID | <[email protected]> |
This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__Part331C478E.2__= Content-Type: multipart/alternative; boundary="=__Part331C478E.3__=" --=__Part331C478E.3__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hope this helps. =20 1). >>Edit ~/.bash_profile. Add a line in the final. I am sorry. It is not ~/.bash_profile. You can edit ~/.bashrc. Add the = required environment variables. Then #source ~/.bashrc Or #env | grep ORA //get ORACLE_SID=20 #export ORACLE_UNQNAME=3D$ORACLE_SID //export ORACLE_UNQNAME using = command line =20 #echo $ORACLE_UNQNAME //This should be the same and = ORACLE_SID=20 =20 #emctl start dbconsole //check again =20 2). If the problem still. Drop dbconsole repos first and then re-configurat= ion. #emca -deconfig dbconsole db -repos drop //Sometimes this will be = failed. =20 If above command fails, do the following: ---------------------------------------------------------- Login to db server. (Make sure your operation is permitted.) =20 #sqlplus /nolog sql> connect /as sysdba Connected. sql>startup sql>alter user dbsnmp identified by orcl; sql>drop role MGMT_USER; sql>drop user MGMT_VIEW cascade; sql>drop user sysman cascade; sql>drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS; sql>drop public synonym SETEMVIEWUSERCONTEXT; =20 ----------------------------------------------------------- =20 Then re-configuration using the following: =20 #emca -config dbcontrol db -repos create =20 -------------------------------------- //When prompted: enter the SID,=20 enter the port,=20 enter the SYS password,=20 enter DBSNMP password,=20 enter the SYSMAN password and so on. -------------------------------------- =20 Restart oracle listener =20 #lsnrctl stop #lsnrctl start =20 and then #emctl status dbconsole //Check again. =20 Thanks, Chen =20 >>> dev kishore <[email protected]> 2011-8-2 14:29 >>> Thank you Chen. I Did everything but still there is some problem. I Think = we are getting close to fix the problem ,i really really appreciate all = your help. i did not the see the .bash_profile in my /home/oracle directory i logged = in as root but still i created a new .bash_profile and added the export = line. localhost:/home/oracle #emctl start dbconsole Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME = to database unique name. localhost:/etc # emca -config dbcontrol db -repos create STARTED EMCA at Aug 2, 2011 1:10:10 AM EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: orcl Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailable= Exception: Database instance unavailable. at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseCh= ecks.java:151) at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks= .java:144) at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.jav= a:163) at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:5= 82) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssist= ant.java:1267) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:5= 73) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521) localhost:/etc # echo $ORACLE_SID orcl localhost:/etc # sqlplus scott/oracle@orcl; SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 2 01:11:12 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit = Production With the Partitioning, OLAP, Data Mining and Real Application Testing = options SQL>=20 On Mon, Aug 1, 2011 at 10:49 PM, Chen Wu <[email protected]> wrote: Please do the following check: 1). Make sure there is also a static IP address in the /etc/hosts file = before installing the database. A similar /etc/hosts file as following: 127.0.0.1 localhost=20 192.168.1.10 E5400-DB.site E5400-DB 2). I assume you have set the completion of other environmental variables. set ORACLE_UNQNAME=3D$ORACLE_SID=20 or=20 Edit ~/.bash_profile. Add a line in the final. export ORACLE_UNQNAME=3D$ORACLE_SID=20 Then, startup database sqlplus /nolog SQL> connect /as sysdba Connected. SQL> startup Startup oracle listener #lsnrctl start Startup oracle dbconsole #emctl start dbconsole If the error still, drop dbconsole and re-configuration. #emca -deconfig dbconsole db -repos drop #emca -config dbcontrol db -repos create #emctl status dbconsole 3). If the problem still. Update the Java binaries to jdk-6u23-linux-64 or = later. Thanks, Chen >>> dev kishore <[email protected]> 2011-8-2 8:07 >>> Problem is getting bigger. I am able to connect to the database but not = able to run oracle enterprise manager. Show parameter db_unique_name=3Dorcl=20 all environment variables required are set ,just wondering what else is = missing please help. oracle@localhost:~/Desktop> emctl start dbconsole Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME = to database unique name.=20 oracle@localhost:~/Desktop> emca -config dbcontrol db -repos create STARTED EMCA at Aug 1, 2011 6:29:47 PM EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: orcl Listener port number: 1521 Listener ORACLE_HOME [ /opt/oracle/product/11gR1/db ]: /opt/oracle/product/= 11gR1/db Password for SYS user:=20 Password for DBSNMP user:=20 Password for SYSMAN user:=20 Email address for notifications (optional):=20 Outgoing Mail (SMTP) server for notifications (optional):=20 ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /opt/oracle/product/11gR1/db Local hostname ................ localhost Listener ORACLE_HOME ................ /opt/oracle/product/11gR1/db Listener port number ................ 1521 Database SID ................ orcl Email address for notifications ...............=20 Outgoing Mail (SMTP) server for notifications ...............=20 ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y Aug 1, 2011 6:31:16 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /opt/oracle/cfgtoollogs/emca/orcl/e= mca_2011_08_01_18_29_46.log. Aug 1, 2011 6:31:17 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Aug 1, 2011 6:39:22 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Aug 1, 2011 6:39:28 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToR= epository INFO: Uploading configuration data to EM repository (this may take a = while) ... Aug 1, 2011 6:41:24 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully # # An unexpected error has been detected by HotSpot Virtual Machine: # # SIGSEGV (0xb) at pc=3D0x00007f0164b2f399, pid=3D5493, tid=3D1396453607933= 28 # # Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_17-b03 mixed mode) # Problematic frame: # C [libclntsh.so.11.1+0x653399] snlinGetAddrInfo+0x1b1 # # An error report file with more information is saved as hs_err_pid5493.log= # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # /opt/oracle/product/11gR1/db/bin/emca: line 102: 5493 Aborted (core = dumped) ${JRE_JAVA} $JAVA64FLAG -DDISPLAY=3D"${DISPLAY}" -DORACLE_HOME=3D"$= {ORACLE_HOME}" -DTNS_ADMIN=3D"${TNS_ADMIN}" oracle.sysman.emcp.EMConfigAssi= stant $* oracle@localhost:~/Desktop>=20 On Thu, Jul 28, 2011 at 2:22 PM, Chen Wu <[email protected]> wrote: Hello, Please check your /etc/hosts file. Ensure that the following line exists: 127.0.0.1 localhost Then try again! Thanks, Chen _______________________________________________ suse-oracle mailing list [email protected]=20 http://listx.novell.com/mailman/listinfo/suse-oracle>>> dev kishore = <[email protected]> 2011-7-28 22:16 >>> Hi, I Installed 11gR2 on suse enterprise linux 11 server i am getting the = below error when i start the listener. I Followed everything as mentioned = in the document by Arun singh. LSNRCTL> trace 2 Connecting to (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DIPC)(KEY=3DEXTPROC1521)= )) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 2: No such file or directory Connecting to (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DTCP)(PORT=3D1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Any help highly appreciated ..Thanks in advanced . --=__Part331C478E.3__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable <HTML><HEAD> <META content=3D"text/html; charset=3DUTF-8" http-equiv=3DContent-Type> <META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18702"></HEAD> <BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt =E5=AE=8B=E4=BD=93"> <DIV>Hope this helps.</DIV> <DIV> </DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">1). >>Ed= it ~/.bash_profile. <SPAN lang=3Den><SPAN>Add a line</SPAN> <SPAN>in the = final.</SPAN></SPAN></SPAN></SPAN></SPAN></DIV> <DIV>I am sorry. It is not ~/.bash_profile. You can edit ~/.bashrc. Add = the r<SPAN id=3Dresult_box lang=3Den class=3D"long_text short_text"><SPAN = class=3Dhps>equired environment variables. Then #source ~/.bashrc</SPAN></S= PAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN>Or</SPAN></SPAN></SPAN></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN>#env | grep ORA &n= bsp;  = ; //get ORACLE_SID </SPAN></SPAN></SPAN></SPAN></SPAN></D= IV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN>#export <FONT color=3D#ff0000>ORACLE_UNQNAME=3D</FONT><FONT= color=3D#000000>$ORACLE_SID //export = </FONT><FONT color=3D#ff0000>ORACLE_UNQNAME </FONT><FONT color=3D#0000= 00>using command line</FONT></SPAN></SPAN></SPAN></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN></SPAN></SPAN></SPAN></SPAN></SPAN> </DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN>#echo $<FONT color=3D#ff0000>ORACLE_UNQNAME &nbs= p; &= nbsp; </FONT>//<FONT color=3D#ff0000><FONT color=3D#000000>This = should be the same and ORACLE_SID</FONT> </FONT></SPAN></SPAN></SPAN><= /SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN></SPAN></SPAN></SPAN></SPAN></SPAN> </DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN>#emctl start dbconsole &= nbsp; //check = again</SPAN></SPAN></SPAN></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN></SPAN></SPAN></SPAN></SPAN></SPAN> </DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN>2). If the problem still. Drop dbconsole repos first and = then re-configuration.</SPAN></SPAN></SPAN></SPAN></SPAN></DIV> <DIV><BR> <DIV>#emca -deconfig dbconsole db -repos drop //Sometimes= this will be failed.</DIV> <DIV> </DIV> <DIV><SPAN id=3Dresult_box lang=3Den class=3D"long_text short_text"><SPAN = class=3Dhps>If</SPAN> <SPAN class=3Dhps>above</SPAN> command <SPAN = class=3Dhps>fails</SPAN><SPAN>, do the following:</SPAN></SPAN></DIV> <DIV><SPAN lang=3Den class=3D"long_text short_text"><SPAN>-----------------= -----------------------------------------</SPAN></SPAN></DIV> <DIV>Login to db server. (Make sure y<SPAN id=3Dresult_box lang=3Den = class=3D"long_text short_text"><SPAN class=3Dhps>our</SPAN> <SPAN = class=3Dhps>operation is</SPAN> <SPAN class=3Dhps>permitted.</SPAN></SPAN>)= </DIV> <DIV> </DIV> <DIV>#<SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">sqlplus /nolog</SP= AN> <DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">sql> connect = /as sysdba</SPAN></DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">Connected.</SPAN></= DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">sql>startup</SPA= N><BR>sql>alter user dbsnmp identified by orcl;</DIV> <DIV>sql>drop role MGMT_USER;</DIV> <DIV>sql>drop user MGMT_VIEW cascade;</DIV> <DIV>sql>drop user sysman cascade;</DIV></DIV></DIV> <DIV>sql>drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;</DIV> <DIV>sql>drop public synonym SETEMVIEWUSERCONTEXT;</DIV> <DIV> </DIV> <DIV>-----------------------------------------------------------</DIV> <DIV> </DIV> <DIV>Then re-configuration using the following:</DIV> <DIV> </DIV> <DIV>#emca -config dbcontrol db -repos create </DIV> <DIV>--------------------------------------</DIV> <DIV>//<SPAN id=3Dresult_box lang=3Den class=3Dlong_text><SPAN class=3Dhps>= When prompted:</SPAN></SPAN></DIV> <DIV><SPAN lang=3Den class=3Dlong_text><SPAN class=3Dhps>enter</SPAN> = <SPAN class=3Dhps>the </SPAN><SPAN class=3Dhps>SID, </SPAN></SPAN></DIV> <DIV><SPAN lang=3Den class=3Dlong_text><SPAN class=3Dhps><SPAN id=3Dresult_= box lang=3Den class=3Dlong_text><SPAN>enter the port,</SPAN> </SPAN></SPAN>= </SPAN></DIV> <DIV><SPAN lang=3Den class=3Dlong_text><SPAN class=3Dhps><SPAN lang=3Den = class=3Dlong_text><SPAN class=3Dhps>enter</SPAN> <SPAN class=3Dhps>the SYS = password</SPAN><SPAN>,</SPAN> </SPAN></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den class=3Dlong_text><SPAN class=3Dhps><SPAN lang=3Den = class=3Dlong_text><SPAN class=3Dhps>enter</SPAN> <SPAN class=3Dhps>DBSNMP</= SPAN> <SPAN class=3Dhps>password</SPAN><SPAN>, </SPAN></SPAN></SPAN></SPAN>= </DIV> <DIV><SPAN lang=3Den class=3Dlong_text><SPAN class=3Dhps><SPAN lang=3Den = class=3Dlong_text><SPAN>enter the</SPAN> <SPAN class=3Dhps>SYSMAN</SPAN> = <SPAN class=3Dhps>password and so on.</SPAN></SPAN></SPAN></SPAN></DIV> <DIV>--------------------------------------</DIV></DIV> <DIV> </DIV> <DIV>Restart oracle listener</DIV> <DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"></SPAN> </DIV>= <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">#lsnrctl stop</SPAN= ></DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN style=3D"BACK= GROUND-COLOR: rgb(255,255,255)">#lsnrctl start</SPAN><BR></SPAN></DIV> <DIV> </DIV> <DIV>and then<BR></DIV> <DIV>#emctl status dbconsole //Check again.</DIV></= DIV> <DIV> </DIV> <DIV>Thanks,</DIV> <DIV>Chen</DIV> <DIV> </DIV> <DIV>>>> dev kishore <[email protected]> 2011-8-2 = 14:29 >>><BR><FONT class=3DApple-style-span color=3D#000099>Thank = you Chen. I Did everything but still there is some problem. I Think we are = getting close to fix the problem ,i really really appreciate all your = help.</FONT></DIV> <DIV><BR></DIV> <DIV>i did not the see the .bash_profile in my /home/oracle directory i = logged in as root but still i created a new .bash_profile and added the = export line.</DIV> <DIV><BR></DIV> <DIV>localhost:/home/oracle #emctl start dbconsole</DIV> <DIV><FONT class=3DApple-style-span color=3D#ff0000>Environment variable = ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique = name.</FONT></DIV> <DIV><BR></DIV> <DIV> <DIV>localhost:/etc # emca -config dbcontrol db -repos create</DIV> <DIV><BR></DIV> <DIV>STARTED EMCA at Aug 2, 2011 1:10:10 AM</DIV> <DIV>EM Configuration Assistant, Version 11.2.0.0.2 Production</DIV> <DIV>Copyright (c) 2003, 2005, Oracle. All rights reserved.</DIV> <DIV><BR></DIV> <DIV>Enter the following information:</DIV> <DIV>Database SID: orcl</DIV> <DIV><FONT class=3DApple-style-span color=3D#cc0000>Exception in thread = "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database = instance unavailable.</FONT></DIV> <DIV><FONT class=3DApple-style-span color=3D#cc0000><SPAN style=3D"WHITE-SP= ACE: pre" class=3DApple-tab-span></SPAN>at oracle.sysman.emcp.DatabaseCheck= s.throwDBUnavailableException(DatabaseChecks.java:151)</FONT></DIV> <DIV><FONT class=3DApple-style-span color=3D#cc0000><SPAN style=3D"WHITE-SP= ACE: pre" class=3DApple-tab-span></SPAN>at oracle.sysman.emcp.DatabaseCheck= s.checkDbAvailabilityImpl(DatabaseChecks.java:144)</FONT></DIV> <DIV><FONT class=3DApple-style-span color=3D#cc0000><SPAN style=3D"WHITE-SP= ACE: pre" class=3DApple-tab-span></SPAN>at oracle.sysman.emcp.DatabaseCheck= s.checkDbAvailability(DatabaseChecks.java:163)</FONT></DIV> <DIV><FONT class=3DApple-style-span color=3D#cc0000><SPAN style=3D"WHITE-SP= ACE: pre" class=3DApple-tab-span></SPAN>at oracle.sysman.emcp.DatabaseCheck= s.getDbServiceName(DatabaseChecks.java:582)</FONT></DIV> <DIV><FONT class=3DApple-style-span color=3D#cc0000><SPAN style=3D"WHITE-SP= ACE: pre" class=3DApple-tab-span></SPAN>at oracle.sysman.emcp.EMConfigAssis= tant.performConfiguration(EMConfigAssistant.java:1267)</FONT></DIV> <DIV><FONT class=3DApple-style-span color=3D#cc0000><SPAN style=3D"WHITE-SP= ACE: pre" class=3DApple-tab-span></SPAN>at oracle.sysman.emcp.EMConfigAssis= tant.statusMain(EMConfigAssistant.java:573)</FONT></DIV> <DIV><FONT class=3DApple-style-span color=3D#cc0000><SPAN style=3D"WHITE-SP= ACE: pre" class=3DApple-tab-span></SPAN>at oracle.sysman.emcp.EMConfigAssis= tant.main(EMConfigAssistant.java:521)</FONT></DIV> <DIV>localhost:/etc # echo $ORACLE_SID</DIV> <DIV>orcl</DIV> <DIV>localhost:/etc # sqlplus scott/oracle@orcl;</DIV> <DIV><BR></DIV> <DIV>SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 2 01:11:12 = 2011</DIV> <DIV><BR></DIV> <DIV>Copyright (c) 1982, 2009, Oracle. All rights reserved.</DIV> <DIV><BR></DIV> <DIV><BR></DIV> <DIV>Connected to:</DIV> <DIV>Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit = Production</DIV> <DIV>With the Partitioning, OLAP, Data Mining and Real Application Testing = options</DIV> <DIV><BR></DIV> <DIV>SQL> </DIV></DIV> <DIV><BR></DIV> <DIV><BR></DIV> <DIV><BR></DIV> <DIV><BR><BR> <DIV class=3Dgmail_quote>On Mon, Aug 1, 2011 at 10:49 PM, Chen Wu <SPAN = dir=3Dltr><<A href=3D"mailto:[email protected]">[email protected]</A>></SPA= N> wrote:<BR> <BLOCKQUOTE style=3D"BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px = 0.8ex; PADDING-LEFT: 1ex" class=3Dgmail_quote> <DIV style=3D"MARGIN: 4px 4px 1px"> <DIV><SPAN lang=3Den><SPAN>Please</SPAN> <SPAN>do the</SPAN> <SPAN>followin= g</SPAN> check:</SPAN></DIV> <DIV><SPAN lang=3Den><SPAN></SPAN></SPAN></DIV> <DIV>1). Make sure there is<SPAN lang=3Den> <SPAN title=3D=C3=A7=E2=80=9A= =C2=B9=C3=A5=E2=80=A1=C2=BB=C3=A5>also</SPAN> <SPAN title=3D=C3=A7=E2=80=9A= =C2=B9=C3=A5=E2=80=A1=C2=BB=C3=A5>a</SPAN> <SPAN title=3D=C3=A7=E2=80=9A=C2= =B9=C3=A5=E2=80=A1=C2=BB=C3=A5>static</SPAN> <SPAN title=3D=C3=A7=E2=80=9A= =C2=B9=C3=A5=E2=80=A1=C2=BB=C3=A5>IP address in the /etc/hosts file before = installing the database.</SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5>A similar /etc/hosts file as following:<BR></SPAN></SPAN></DIV> <DIV class=3Dim> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5>127.0.0.1 localhost </SPAN></SPAN></DIV></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5>192.168.1.10 E5400-DB.site E5400-DB</SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5>2). <SPAN lang=3Den><SPAN>I assume</SPAN> <SPAN>you</SPAN> = <SPAN>have</SPAN> <SPAN>set the</SPAN> <SPAN>completion of</SPAN> = <SPAN>other environmental</SPAN> <SPAN>variables.</SPAN></SPAN></SPAN></SPA= N></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5>set<SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"> ORACLE_UNQ= NAME=3D$ORACLE_SID </SPAN></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">or </SPAN></SP= AN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">Edit = ~/.bash_profile. <SPAN lang=3Den><SPAN>Add a line</SPAN> <SPAN>in the = final.</SPAN></SPAN></SPAN></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"><SPAN = lang=3Den><SPAN><SPAN lang=3Den><SPAN>export ORACLE_UNQNAME=3D$ORACLE_SID = </SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5></SPAN></SPAN></DIV> <DIV><SPAN lang=3Den><SPAN title=3D=C3=A7=E2=80=9A=C2=B9=C3=A5=E2=80=A1=C2= =BB=C3=A5>Then, startup database</SPAN></SPAN></DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"></SPAN></DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">sqlplus /nolog</SPA= N></DIV> <DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">SQL> connect = /as sysdba</SPAN></DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">Connected.</SPAN></= DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">SQL> startup</SP= AN><BR></DIV> <DIV>Startup oracle listener</DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)"></SPAN></DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">#lsnrctl start</SPA= N><BR></DIV> <DIV>Startup oracle dbconsole</DIV> <DIV></DIV> <DIV><SPAN style=3D"BACKGROUND-COLOR: rgb(255,255,255)">#emctl start = dbconsole</SPAN></DIV> <DIV></DIV> <DIV>If the error still, drop dbconsole and re-configuration.</DIV> <DIV></DIV> <DIV>#emca -deconfig dbconsole db -repos drop</DIV> <DIV>#emca -config dbcontrol db -repos create</DIV> <DIV>#emctl status dbconsole</DIV> <DIV></DIV> <DIV>3). If the problem still. Update the Java binaries to jdk-6u23-linux-6= 4 or later.</DIV> <DIV></DIV> <DIV><BR>Thanks,</DIV> <DIV>Chen</DIV> <DIV></DIV> <DIV></DIV> <DIV>>>> dev kishore <<A href=3D"mailto:[email protected]= " target=3D_blank>[email protected]</A>> 2011-8-2 8:07 >>>= ; <DIV> <DIV></DIV> <DIV class=3Dh5><BR>Problem is getting bigger. I am able to connect to the = database but not able to run oracle enterprise manager.</DIV></DIV></DIV></= DIV> <DIV> <DIV></DIV> <DIV class=3Dh5> <DIV><BR></DIV> <DIV>Show parameter db_unique_name=3Dorcl </DIV> <DIV>all environment variables required are set ,just wondering what else = is missing please help.<BR> <DIV><BR></DIV> <DIV> <DIV>oracle@localhost:~/Desktop> emctl start dbconsole</DIV> <DIV><FONT color=3D#ff0000>Environment variable ORACLE_UNQNAME not = defined. Please set ORACLE_UNQNAME to database unique name. </FONT></DIV> <DIV>oracle@localhost:~/Desktop> emca -config dbcontrol db -repos = create</DIV> <DIV><BR></DIV> <DIV>STARTED EMCA at Aug 1, 2011 6:29:47 PM</DIV> <DIV>EM Configuration Assistant, Version 11.2.0.0.2 Production</DIV> <DIV>Copyright (c) 2003, 2005, Oracle. All rights reserved.</DIV> <DIV><BR></DIV> <DIV>Enter the following information:</DIV> <DIV>Database SID: orcl</DIV> <DIV>Listener port number: 1521</DIV> <DIV>Listener ORACLE_HOME [ /opt/oracle/product/11gR1/db ]: /opt/oracle/pro= duct/11gR1/db</DIV> <DIV>Password for SYS user: </DIV> <DIV>Password for DBSNMP user: </DIV> <DIV>Password for SYSMAN user: </DIV> <DIV>Email address for notifications (optional): </DIV> <DIV>Outgoing Mail (SMTP) server for notifications (optional): </DIV> <DIV>-----------------------------------------------------------------</DIV= > <DIV><BR></DIV> <DIV>You have specified the following settings</DIV> <DIV><BR></DIV> <DIV>Database ORACLE_HOME ................ /opt/oracle/product/11gR1/db</DI= V> <DIV><BR></DIV> <DIV>Local hostname ................ localhost</DIV> <DIV>Listener ORACLE_HOME ................ /opt/oracle/product/11gR1/db</DI= V> <DIV>Listener port number ................ 1521</DIV> <DIV>Database SID ................ orcl</DIV> <DIV>Email address for notifications ............... </DIV> <DIV>Outgoing Mail (SMTP) server for notifications ............... </DIV> <DIV><BR></DIV> <DIV>-----------------------------------------------------------------</DIV= > <DIV>Do you wish to continue? [yes(Y)/no(N)]: Y</DIV> <DIV>Aug 1, 2011 6:31:16 PM oracle.sysman.emcp.EMConfig perform</DIV> <DIV>INFO: This operation is being logged at /opt/oracle/cfgtoollogs/emca/o= rcl/emca_2011_08_01_18_29_46.log.</DIV> <DIV>Aug 1, 2011 6:31:17 PM oracle.sysman.emcp.EMReposConfig createReposito= ry</DIV> <DIV>INFO: Creating the EM repository (this may take a while) ...</DIV> <DIV>Aug 1, 2011 6:39:22 PM oracle.sysman.emcp.EMReposConfig invoke</DIV> <DIV>INFO: Repository successfully created</DIV> <DIV>Aug 1, 2011 6:39:28 PM oracle.sysman.emcp.EMReposConfig uploadConfigDa= taToRepository</DIV> <DIV>INFO: Uploading configuration data to EM repository (this may take a = while) ...</DIV> <DIV>Aug 1, 2011 6:41:24 PM oracle.sysman.emcp.EMReposConfig invoke</DIV> <DIV>INFO: Uploaded configuration data successfully</DIV> <DIV>#</DIV> <DIV><FONT color=3D#ff0000># An unexpected error has been detected by = HotSpot Virtual Machine:</FONT></DIV> <DIV><FONT color=3D#ff0000>#</FONT></DIV> <DIV><FONT color=3D#ff0000># SIGSEGV (0xb) at pc=3D0x00007f0164b2f399, = pid=3D5493, tid=3D139645360793328</FONT></DIV> <DIV><FONT color=3D#ff0000>#</FONT></DIV> <DIV><FONT color=3D#ff0000># Java VM: Java HotSpot(TM) 64-Bit Server VM = (1.5.0_17-b03 mixed mode)</FONT></DIV> <DIV><FONT color=3D#ff0000># Problematic frame:</FONT></DIV> <DIV><FONT color=3D#ff0000># C [libclntsh.so.11.1+0x653399] snlinGetAddrInf= o+0x1b1</FONT></DIV> <DIV><FONT color=3D#ff0000>#</FONT></DIV> <DIV><FONT color=3D#ff0000># An error report file with more information is = saved as hs_err_pid5493.log</FONT></DIV> <DIV><FONT color=3D#ff0000>#</FONT></DIV> <DIV><FONT color=3D#ff0000># If you would like to submit a bug report, = please visit:</FONT></DIV> <DIV><FONT color=3D#ff0000># <A href=3D"http://java.sun.com/webapps/bugrepo= rt/crash.jsp" target=3D_blank>http://java.sun.com/webapps/bugreport/crash.j= sp</A></FONT></DIV> <DIV><FONT color=3D#ff0000>#</FONT></DIV> <DIV><FONT color=3D#ff0000>/opt/oracle/product/11gR1/db/bin/emca: line = 102: 5493 Aborted (core dumped) ${JRE_JAVA} $JAVA64FLAG -DDISPLAY=3D"${DISP= LAY}" -DORACLE_HOME=3D"${ORACLE_HOME}" -DTNS_ADMIN=3D"${TNS_ADMIN}" = oracle.sysman.emcp.EMConfigAssistant $*</FONT></DIV> <DIV><FONT color=3D#ff0000>oracle@localhost:~/Desktop> </FONT></DIV> <DIV><BR></DIV><BR> <DIV class=3Dgmail_quote>On Thu, Jul 28, 2011 at 2:22 PM, Chen Wu <SPAN = dir=3Dltr><<A href=3D"mailto:[email protected]" target=3D_blank>cwu@novell.= com</A>></SPAN> wrote:<BR> <BLOCKQUOTE style=3D"BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px = 0.8ex; PADDING-LEFT: 1ex" class=3Dgmail_quote> <DIV style=3D"MARGIN: 4px 4px 1px"> <DIV>Hello,</DIV> <DIV></DIV> <DIV>Please check your /etc/hosts file. Ensure that the following line = exists:</DIV> <DIV></DIV> <DIV>127.0.0.1 localhost</DIV> <DIV></DIV> <DIV>Then try again!</DIV> <DIV></DIV> <DIV>Thanks,<BR>Chen<BR></DIV> <DIV><BR><BR></DIV> <DIV></DIV> <DIV>_______________________________________________<BR>suse-oracle = mailing list<BR><A href=3D"mailto:[email protected]" target=3D_b= lank>[email protected]</A> <BR><A href=3D"http://listx.novell.co= m/mailman/listinfo/suse-oracle" target=3D_blank>http://listx.novell.com/mai= lman/listinfo/suse-oracle</A>>>> dev kishore <<A href=3D"mailto= :[email protected]" target=3D_blank>[email protected]</A>> = 2011-7-28 22:16 >>><BR></DIV> <DIV> <DIV></DIV> <DIV> <DIV>Hi,</DIV> <DIV></DIV> <DIV></DIV> <DIV>I Installed 11gR2 on suse enterprise linux 11 server i am getting the = below error when i start the listener. I Followed everything as mentioned = in the document by Arun singh.</DIV> <DIV></DIV> <DIV>LSNRCTL> trace 2<BR>Connecting to (DESCRIPTION=3D(ADDRESS=3D(PROTOC= OL=3DIPC)(KEY=3DEXTPROC1521)))<BR>TNS-12541: TNS:no listener<BR>TNS-12560: = TNS:protocol adapter error<BR>TNS-00511: No listener<BR>Linux Error: 2: No = such file or directory<BR>Connecting to (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL= =3DTCP)(PORT=3D1521)))<BR>TNS-12541: TNS:no listener<BR>TNS-12560: = TNS:protocol adapter error<BR>TNS-00511: No listener<BR>Linux Error: 111: = Connection refused</DIV> <DIV></DIV> <DIV></DIV> <DIV>Any help highly appreciated ..Thanks in advanced .</DIV> <DIV></DIV> <DIV></DIV></DIV></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV></DIV= ></DIV></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML> --=__Part331C478E.3__=-- --=__Part331C478E.2__= Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ suse-oracle mailing list [email protected] http://listx.novell.com/mailman/listinfo/suse-oracle --=__Part331C478E.2__=--