Home » RDBMS Server » Networking and Gateways » port forwarding in oracle 10g (windows server 2008)
port forwarding in oracle 10g [message #565927] Sat, 08 September 2012 10:10 Go to next message
sadboybcs01
Messages: 7
Registered: June 2012
Junior Member
i want to online my oracle 10g database but when i make connection string then i donont know what the port i set
i set default port 1521 but it not work on client site
please tell me how can connect the server which port.
Re: port forwarding in oracle 10g [message #565928 is a reply to message #565927] Sat, 08 September 2012 10:35 Go to previous messageGo to next message
Michel Cadot
Messages: 57607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Net Services Administrator's Guide
Database Net Services Reference

Start with "Part I Getting Started with Oracle Net Services" of first link.

And if you want a more accurate answer you have to SHOW us what you did and got.

Regards
Michel

Re: port forwarding in oracle 10g [message #565929 is a reply to message #565928] Sat, 08 September 2012 10:49 Go to previous messageGo to next message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
If you are logged on to the DB Server itself as same OS user that owns Oracle software;
then no listener is require to start or use the DB.

open a Command Window & do EXACTLY as below

sqlplus
/ as sysdba
startup
select * from v$version;

COPY the results from above then PASTE all back here.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: port forwarding in oracle 10g [message #566166 is a reply to message #565929] Tue, 11 September 2012 10:22 Go to previous messageGo to next message
gazzag
Messages: 267
Registered: November 2010
Location: Bristol, UK
Senior Member
BlackSwan wrote on Sat, 08 September 2012 15:49
If you are logged on to the DB Server itself as same OS user that owns Oracle software;
then no listener is require to start or use the DB.

open a Command Window & do EXACTLY as below

sqlplus
/ as sysdba
startup
select * from v$version;

COPY the results from above then PASTE all back here.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


Of course, the third line of the steps Blackswan suggests should be:

startup;


Note the semi-colon (";")
HTH
-g
Re: port forwarding in oracle 10g [message #566172 is a reply to message #566166] Tue, 11 September 2012 10:51 Go to previous message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
NOTICE! no semicolon.
[oracle@localhost ~]$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 11 08:49:37 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


08:49:42 SQL> startup
ORACLE instance started.

Total System Global Area  456146944 bytes
Fixed Size                  1344840 bytes
Variable Size             352324280 bytes
Database Buffers           96468992 bytes
Redo Buffers                6008832 bytes
Database mounted.
Database opened.
08:50:05 SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$ 


Previous Topic: tns_admin
Next Topic: Does oracle 10.2.0.4.0 supports ipv6
Goto Forum:
  


Current Time: Thu Apr 17 18:11:31 CDT 2014

Total time taken to generate the page: 0.09825 seconds