OraFAQ Forum: Networking and Gateways » port forwarding in oracle 10g

Home » RDBMS Server » Networking and Gateways » port forwarding in oracle 10g (windows server 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

port forwarding in oracle 10g [message #565927]

Sat, 08 September 2012 10:10

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.

Report message to a moderator

Re: port forwarding in oracle 10g [message #565928 is a reply to message #565927]

Sat, 08 September 2012 10:35

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: port forwarding in oracle 10g [message #565929 is a reply to message #565928]

Sat, 08 September 2012 10:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: port forwarding in oracle 10g [message #566166 is a reply to message #565929]

Tue, 11 September 2012 10:22

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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:

Code: [Select all] [Show/ hide]

startup;

Note the semi-colon (";")
HTH
-g

Report message to a moderator

Re: port forwarding in oracle 10g [message #566172 is a reply to message #566166]

Tue, 11 September 2012 10:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

NOTICE! no semicolon.

Code: [Select all] [Show/ hide]

[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 ~]$

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 05:43:39 CDT 2025