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.
|
|
|
|
|
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:49If 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:
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 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
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 ~]$
|
|
|