Routers
--
Questions
--
Followers
Top Experts
Opening port 1521
Greetings!
The background is that I am trying to get my Oracle Thin Client to work. However my question is based on a friend's suggestion as to why it doesn't work - He suggested that port 1521 is being blocked. My question is how to open the port.
My laptop is connected to the company network which is connected to the Internet using a sweex AnnexA Router.
As a novice in Routers, I would be much appreciative of some help.
This is what I did so far.
1. I turned off all firewalls on my computer.
2. I went to http://www.yougetsignal.com/tools/open-ports/ and checked port 1521.
It said that the port was closed.
3. I then went to my router and added port 1521. See attached screenshot. I restarted router.
4. Again yougetsignal said the port was closed.
5. I then downloaded Port Forwarding Wizard. See attached screenshot.
6. Again yougetsignal said the port was closed.
7. I telephoned my ISP who said that they did not close the port.
Now I am a little stuck. It could be that yougetsignal doesn't always work, and really the port is open. Or that I have put some settings in wrongly to the Router....
sweex.jpg
portforwarding.jpg
The background is that I am trying to get my Oracle Thin Client to work. However my question is based on a friend's suggestion as to why it doesn't work - He suggested that port 1521 is being blocked. My question is how to open the port.
My laptop is connected to the company network which is connected to the Internet using a sweex AnnexA Router.
As a novice in Routers, I would be much appreciative of some help.
This is what I did so far.
1. I turned off all firewalls on my computer.
2. I went to http://www.yougetsignal.com/tools/open-ports/ and checked port 1521.
It said that the port was closed.
3. I then went to my router and added port 1521. See attached screenshot. I restarted router.
4. Again yougetsignal said the port was closed.
5. I then downloaded Port Forwarding Wizard. See attached screenshot.
6. Again yougetsignal said the port was closed.
7. I telephoned my ISP who said that they did not close the port.
Now I am a little stuck. It could be that yougetsignal doesn't always work, and really the port is open. Or that I have put some settings in wrongly to the Router....
sweex.jpg
portforwarding.jpg
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Hello,
Wich os is runnig on your laptop. If it is windows xp vista there is a integrated firewall.
So you have to open the port on windows
Wich os is runnig on your laptop. If it is windows xp vista there is a integrated firewall.
So you have to open the port on windows
Hello
It is Windows XP Vista 64 Home Premium. However I shut down the firewall.
What do you mean by open the port on windows?
It is Windows XP Vista 64 Home Premium. However I shut down the firewall.
What do you mean by open the port on windows?
Ok so let me follow this, your client is trying to connect to third party vendor oracle database and your not the network?
You may have your port open, but they may not have you defined to their system so they our not letting you log on. I doubt if its a oracle application, that the ports blocked on their end.
Try going to your dos command and doing a couple things...
1. First Ping the server ip address to see if it fails or is not recognized.
2. Next if 1 does fail, then do a tractert on the ip address again.
For tracert you may have to download it....
Then tell me your results, thanks
You may have your port open, but they may not have you defined to their system so they our not letting you log on. I doubt if its a oracle application, that the ports blocked on their end.
Try going to your dos command and doing a couple things...
1. First Ping the server ip address to see if it fails or is not recognized.
2. Next if 1 does fail, then do a tractert on the ip address again.
For tracert you may have to download it....
Then tell me your results, thanks
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
I will now add more information about what I am trying to do.
1. I am using Thin Client: Oracle OC4J Standalone Server 10.1.3.n on my laptop
2. I connect to Oracle Database 9.2.0.1.0 which is installed on our server (in another city)
3. My laptop has Windows Vista Home Premium 64 bit. I am using Eclipse.
4. The setup was working very well until a few weeks ago. My (ex-)colleague uses the same system (from a different city) and he had no problems even after mine stopped working.
Upon attempting to start the Thin Client, the console gets to "09/04/22 13:34:17 Oracle Containers for J2EE 10g (10.1.3.4.0) initialized" and then times out.
I was told that it was probably a problem with the port 1521. I did ask the full question in Experts Exchange under Oracle, but no one replied at all! so I was re-asking part of the question in the Routers section.
1. I am using Thin Client: Oracle OC4J Standalone Server 10.1.3.n on my laptop
2. I connect to Oracle Database 9.2.0.1.0 which is installed on our server (in another city)
3. My laptop has Windows Vista Home Premium 64 bit. I am using Eclipse.
4. The setup was working very well until a few weeks ago. My (ex-)colleague uses the same system (from a different city) and he had no problems even after mine stopped working.
Upon attempting to start the Thin Client, the console gets to "09/04/22 13:34:17 Oracle Containers for J2EE 10g (10.1.3.4.0) initialized" and then times out.
I was told that it was probably a problem with the port 1521. I did ask the full question in Experts Exchange under Oracle, but no one replied at all! so I was re-asking part of the question in the Routers section.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
ONce you get that going , then ensure your data-source.xml located under the OC4J-1013/j2ee/home/config
<?xml version = '1.0' encoding = 'UTF-8'?>
<data-sources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocat
<managed-data-source connection-pool-name="Exam
<managed-data-source connection-pool-name="XXXX
<connection-pool name="Example Connection Pool">
<connection-factory factory-class="oracle.jdbc
</connection-pool>
<connection-pool name="XXXX Pool-PROD">
<connection-factory factory-class="oracle.jdbc
</connection-pool>
</data-sources>
Also load try connecting with a 3rd party tool like TOAD or AQT and hitting the server and port. This way its nothing related to the oracle container setup...
<?xml version = '1.0' encoding = 'UTF-8'?>
<data-sources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocat
<managed-data-source connection-pool-name="Exam
<managed-data-source connection-pool-name="XXXX
<connection-pool name="Example Connection Pool">
<connection-factory factory-class="oracle.jdbc
</connection-pool>
<connection-pool name="XXXX Pool-PROD">
<connection-factory factory-class="oracle.jdbc
</connection-pool>
</data-sources>
Also load try connecting with a 3rd party tool like TOAD or AQT and hitting the server and port. This way its nothing related to the oracle container setup...
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
OK. Thanks for your detailed replies. Interesting you have the same set-up
1. Although ping fails, I can connect to the server where the database is using Remote Desktop. I assume that the port for ping is blocked by the firewall on the server, but not the port for Remote Desktop [or the port for Oracle for that matter, because as I mentioned my ex-colleague had no problem]
2. I did do ping XXXX.XX.XX.XXX
[I didn't know you could add the port]
3. This is my data-sources file. It looks pretty similar to yours...
<?xml version="1.0" standalone='yes'?>
<data-sources
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocat
schema-major-version="10"
schema-minor-version="1"
>
<data-source
class="com.evermind.sql.Dr
name="OracleDS"
location="jdbc/OracleCoreD
xa-location="jdbc/xa/Oracl
ejb-location="jdbc/OracleD
pooled-location="jdbc/Char
connection-driver="oracle.
max-connection="45"
min-connection="15"
username="XXXX"
password="XXXX"
url="jdbc:oracle:thin:@XXX
inactivity-timeout="30"
/>
</data-sources>
1. Although ping fails, I can connect to the server where the database is using Remote Desktop. I assume that the port for ping is blocked by the firewall on the server, but not the port for Remote Desktop [or the port for Oracle for that matter, because as I mentioned my ex-colleague had no problem]
2. I did do ping XXXX.XX.XX.XXX
[I didn't know you could add the port]
3. This is my data-sources file. It looks pretty similar to yours...
<?xml version="1.0" standalone='yes'?>
<data-sources
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocat
schema-major-version="10"
schema-minor-version="1"
>
<data-source
class="com.evermind.sql.Dr
name="OracleDS"
location="jdbc/OracleCoreD
xa-location="jdbc/xa/Oracl
ejb-location="jdbc/OracleD
pooled-location="jdbc/Char
connection-driver="oracle.
max-connection="45"
min-connection="15"
username="XXXX"
password="XXXX"
url="jdbc:oracle:thin:@XXX
inactivity-timeout="30"
/>
</data-sources>
Yeh the reason I said to use TOAD or AQT, is they will connect to oracle. Also you just do a odbc entry under you admin on you desktop and just test it. Thinking you will need to load the odbc driver to do this.
This way we know you oracle setup is correct.
This way we know you oracle setup is correct.
I went to Administrative Tools/Data Sources(ODBC) but I do not have an ODBC driver for Oracle installed or a possibility for installing it.
I wasn't quite sure whether you meant that Toad needed an ODBC driver or not, but I could not get it to work anyway. See attached picture. I feel though that trying to get Toad to work is a can of worms...
toad.jpg
I wasn't quite sure whether you meant that Toad needed an ODBC driver or not, but I could not get it to work anyway. See attached picture. I feel though that trying to get Toad to work is a can of worms...
toad.jpg
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Sorry our email is down and been swamped. Yeh you will need a odbc driver and if your not the admin this will be fruitless. I would get with your network guy to find out why you cant ping that server... you machine first needs to be able to locate it before any software will work
Thanks for your advice TheVeee. I will let you know if anything transpires....
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thank you very much TheVeee for all your time you invested trying to help me fix the problem
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Dang forget all about that one...been awhile since had to mess with that one...least you got it going! Have a great day!
Routers
--
Questions
--
Followers
Top Experts
A router is a networking device that forwards data packets between computer networks. Routers perform the "traffic directing" functions on the Internet. The most familiar type of routers are home and small office cable or DSL routers that simply pass data, such as web pages, email, IM, and videos between computers and the Internet. More sophisticated routers, such as enterprise routers, connect large business or ISP networks up to the powerful core routers that forward data at high speed along the optical fiber lines of the Internet backbone. Though routers are typically dedicated hardware devices, use of software-based routers has grown increasingly common.