Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to run Oracle 11 on Windows without installing service

876019Jul 17 2011 — edited Jul 29 2011
Hello,
I've spend the day trying to setup Oracle with just the installation files I copied from another computer. The point is that I don't want to run the installation because it creates windows service. I want to run oracle purely from command line.

My database is currently functional only from sqlplus, oracle is not listening on the localhost and thus I cannot connect to it from sqldeveloper or any other application.

This is my progress so far:

-------------------------
I created the "initora1.ora" with startup atributes:
db_name = 'ORA11G'
sga_target = 300M
db_create_file_dest='D:\Software\oraclexe\app\oracle\product\10.2.0\server\database\ora11g'
------------------------
cmd>oracle.exe ora1
Press CTRL-C to exit server:

cmd>sqlplus /nolog

sql>conn as sysdba
Enter user-name:sys
Enter password:
Connected

sql>create SPFILE from PFILE='c:\ora11\initora1.ora';
File created.

sql>startup nomount
ORACLE instance started.

Total System Global Area 314572800 bytes
Fixed Size 1287184 bytes
Variable Size 96472048 bytes
Database Buffers 213909504 bytes
Redo Buffers 2904064 bytes

sql>create database ORA1;
Database created.
------------------------

These are all the steps I made so far. I can INSERT/SELECT normally via the SQLPLUS. Apparently there are more steps involved to get oracle listen on 1521 and accept remote connections. I wasn't able to find any information on that :(
If I try to connect via sqldeveloper using the SID:

SQL> select distinct sid from V$mystat;

SID
---
39

I just get network IO error ("The network adapter could not establish the connection") since nothing is listening on 1521 according to netstat.

Thanks in advance for any ideas.

Peter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2011
Added on Jul 17 2011
12 comments
1,441 views