Home » RDBMS Server » Networking and Gateways » interesting connection problem (11, i, XP)
interesting connection problem [message #452347] Wed, 21 April 2010 08:56 Go to next message
matheszabi
Messages: 2
Registered: April 2010
Junior Member
telnet localhost 1521 -success
telnet 192.168.0.X 1521 -falied , where 192.168.0.X the intranet IP ( ipconfig shows it)
telnet 192.168.0.X 8080 (tomcat) -succes

-windows firewall is off, I hope Nod32 doesn't make some background firewall/restrictions, and other firewall software I shouldn't have installed.

The problem is: I don't know what kind of configuration problem I have => I don't know the keyword for search => can't solve the problem.


Any help or ideas?
Re: interesting connection problem [message #452349 is a reply to message #452347] Wed, 21 April 2010 09:01 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this an Oracle problem?

Regards
Michel
Re: interesting connection problem [message #452350 is a reply to message #452347] Wed, 21 April 2010 09:03 Go to previous messageGo to next message
BlackSwan
Messages: 21942
Registered: January 2009
Senior Member
lsnrctl stop
rename listener.ora file out of the way to a new name
lsnrctl start
try again

is DHCP used on this system?
Re: interesting connection problem [message #452428 is a reply to message #452347] Thu, 22 April 2010 01:22 Go to previous message
matheszabi
Messages: 2
Registered: April 2010
Junior Member
Can't post link here, but I have found a site with configuration:
try a search for: MacLochlainns Weblog

MacLochlainns Weblog

Michael McLaughlin's Technical Blog

User Name:

Password:

Site Admin
Reconfigure Oracle EM

with 30 comments

One mistake can lead to a lot of work. When you've installed Oracle Database 11g, you can't change the Windows Hostname without reinstalling Oracle Enterprise Manager.

These are the steps:

1. Change the %ORACLE_HOME%\network\admin\listener.ora file from an IP number to machine name.

2. Change the %ORACLE_HOME%\network\admin\tnsnames.ora file from an IP number to a machine name.

3. Change the C:\WINDOWS\System32\drivers\etc\hosts file by adding this line beneath the default localhost line:

127.0.0.1 localhost
172.16.113.128 mclaughlin11g mclaughlin11g.techtinker.com

4. Change the Windows hostname by navigating: Start > Control Panel > System (classic view) from the random assignment of VMWare Fusion.

5. Reboot the machine, and then drop the em configuration with the following commands:

C:\Data> set ORACLE_SID=orcl
C:\Data> emca -deconfig dbcontrol db -repos drop

6. You'll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g):

STARTED EMCA at Jul 13, 2008 8:26:42 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y

7. You should then drop the SYSMAN user manually because it doesn't happen without your assistance (or, it didn't happen when I did it). If you don't drop the SYSMAN schema, you'll raise an error when you try to recreate it:

CONFIG: ORA-20001: SYSMAN already EXISTS..
ORA-06512: at line 17

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already EXISTS..
ORA-06512: at line 17

The Java stack trace will look like this, more or less based on version and release:

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java
at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)

Drop the user and dependent on version a few other objects, like:

DROP USER sysman CASCADE;
DROP PUBLIC SYNONYM setemviewusercontext;
DROP ROLE mgmt_user;
DROP PUBLIC SYNONYM mgmt_target_blackouts;
DROP USER mgmt_view;

8. You can then create the em environment with the following syntax:

C:\Data> emca -config dbcontrol db -repos create

9. Again, you'll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g):

STARTED EMCA at Jul 13, 2008 8:28:48 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. ALL rights reserved.

Enter the following information:
DATABASE SID: orcl
Listener port number: 1521
Password FOR SYS user:
Password FOR DBSNMP user:
Password FOR SYSMAN user:
Password FOR SYSMAN user: Email address FOR notifications (optional):
Outgoing Mail (SMTP) server FOR notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

DATABASE ORACLE_HOME ................ C:\app\Administrator\product\11.1.0\db_1

LOCAL hostname ................ mclaughlin11g
Listener port number ................ 1521
DATABASE SID ................ orcl
Email address FOR notifications ...............
Outgoing Mail (SMTP) server FOR notifications ...............

-----------------------------------------------------------------

Do you wish TO continue? [yes(Y)/no(N)]: y

A note to me, remember haste makes waste. I'm just glad that rebuilding the MarkLogic server was easy.



So I needed to edit those 2 files
Previous Topic: Instalation-Product-Specific Prerequisite Checks Window
Next Topic: TNS ERROR
Goto Forum:
  


Current Time: Fri Apr 18 12:36:33 CDT 2014

Total time taken to generate the page: 0.09599 seconds