How to run Oracle 11 on Windows without installing service
876019Jul 17 2011 — edited Jul 29 2011Hello,
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