ORACLE 9i installation

W

hi frnds,

I've got a 1.7 Ghz pro with 128 ram running win XP, for my project I ve to install Oracle. I've got a copy of Oracle 9i and I tried to install it; its not working.

can any one give some Oracle installation tips, its pretty urgent!
thanks in advance,

krive.

I have prepare one word document having step by step procedure with print screens that how 2 install 9i. size is 3 MB .give ur e-mail id i will send u. I think big attachment is not allowed here. One more thing "No Oracle Product will work on Windows ME or Windows XP Home Edition " .OK. so use windows 2000 Server edition

Vikas

W

I am havin XP pro.

Then "Not workin" in the sense when i run the prog, it asks for a username , password & a hot string which I've never given durin installation process, so I can't proceed from that window,
when runnimg some other app's frm BIN an error message says "reinstalling the soft ware may fix this".

any way how to Uninstall this?? its not listed in add or remove prog and the destination folder is of only some 30 mb but some 1.5 gb is used up!!!

mail me: gr8junkyard1@yahoo.com

you cant just uninstall the Oracle

but to do so

remove the directory where oracle is installed
remove all oracle concerned registry keys from registry

bingo oracle is removed from your pc

now install the oracle from the very first

host string is the SID which you have to provide during installation

there are host of default logins which you can see at the last of installation in password Management.

after installation

to create a user follow belows

Connect as System (username) Manager (Password) hoststring (hoststring)
then issue this command

1. Create User <Uname> Identified by <Password> (without <>)
then
2. Grant Connect, Resource, dba to <username>

whizkrive said:
hi frnds,

I've got a 1.7 Ghz pro with 128 ram running win XP, for my project I ve to install Oracle. I've got a copy of Oracle 9i and I tried to install it; its not working.

can any one give some Oracle installation tips, its pretty urgent!
thanks in advance,

krive.

ORACLE 9i needs atleast 256mb ram.
so u r bound to get a error

The username and password for that are Scott and tiger respectively.Try this.

gary4gar said:
ORACLE 9i needs atleast 256mb ram.
so u r bound to get a error

No oracle does not need 256 MB of RAM. My friend has installed oracle on just 128 MB of RAM.

@whizkrive use the username scott, pwd tiger with a blank hoststring.

For uninstalling run the oracle installer again and choose the products to be uninstalled

Is this allowed here ?? I mean helping someone who has a Pirated Copy of Oracle 9i ??

Tanmay said:
Is this allowed here ?? I mean helping someone who has a Pirated Copy of Oracle 9i ??

Though Appreciate your Concern.
Are you Using All Genuine Softies ????

Where do you see word "Pirated" in this post ???

Searchin....Searchin....Searchin....Searchin....Searchin....Searchin....Searchin....

FOUND Only in your Reply

Do we hv any substitutes or simulators for ORACLE..

coz i hav to practise couple of basic things like Cursors,Triggers,Functions.etc...and i dont wanna install complete 1.3 GB ORACLE9i....

Dipen01 said:
Do we hv any substitutes or simulators for ORACLE..

coz i hav to practise couple of basic things like Cursors,Triggers,Functions.etc...and i dont wanna install complete 1.3 GB ORACLE9i....

Choose Oracle Database XE or SQL Server 2K5 XE They Are For free and cost less to HDD Space.

I don know about MYSql. May be it uses the same sort of syntax as in oracle

Tanmay said:
Is this allowed here ?? I mean helping someone who has a Pirated Copy of Oracle 9i ??

oracle is free
and is available on the net on oracle.com & so there no question of piracy
*www.oracle.com/technology/software/products/oracle9i/htdocs/winsoft.html
__________

UFO007 said:
No oracle does not need 256 MB of RAM. My friend has installed oracle on just 128 MB of RAM.

i don't think so. maybe for friend has installed oracle 8i??

gary4gar said:
oracle is free
and is available on the net on oracle.com & so there no question of piracy
*www.oracle.com/technology/software/products/oracle9i/htdocs/winsoft.html
__________

i don't think so. maybe for friend has installed oracle 8i??

i use to use oracle 9i on 128mb before adding 128 mb more to my ram

currently im using both ora9i and ora10g on 256MB PIII 1GHz with no issues

ok

DukeNukem said:
Choose Oracle Database XE or SQL Server 2K5 XE They Are For free and cost less to HDD Space.

I don know about MYSql. May be it uses the same sort of syntax as in oracle

Do these hav same interface as of SQL Plus

W

friends thanks for ur support...
I am runnin out of time these days, will inform abut my installation procedings soon!

Thanx DukeNukem & vikasg03 for their help!

krive.

W

I've installed the database and when I try to get in as "system" n "manager" I got the foll error message.

ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist

wats my prob? I never got a screen for defining my own password n username as i found on the guide provided by vikasg03.

pls help, wold win XP support any other ver of ORACLE other than 9i (any lite ver's, which can make SQL tables? )

krive

hy
its means that your pfile is not configure fully to automate initialize the listner services and startup files. just open sql as sysdba and type statup pfile ='location of init.ora';

for connect as sysdba
type in sql user name----------> as sysdba or /as sysdba (no need of password here)
password----------------------> oracle

now type which i tell u earlier --> statup pfile ='location of init.ora';

and ur problem will be solved. But this has to be done every time u start sql once in a system.
As for as defining own password window is concern it depends on version 2 version also the options selected by u. u can change password later .

W

SQL> startup pfile='location of init.ora';
LRM-00109: could not open parameter file 'location of init.ora'
ORA-01078: failure in processing system parameters

this is displayed when i did as vikasg has told..
what shuld i do?
please help

hy
sorry u misunderstood which i can tell u. "location of init.ora files " means u have to search in ur oracle 9i installation folder that where this file is exist. and give the path inside that. For example in my system the location of that file is E:\Oracle\ADMIN\xps\pfile. it means i write in sql prompt
SQL> CONNECT sys/password AS SYSDBA
CONNECTED
SQL> STARTUP PFILE='E:\Oracle\ADMIN\xps\pfile\INIT.ORA';
ORACLE instance started.
Total System Global Area 96547356 bytes
Fixed Size 685234 bytes
Variable Size 46137344 bytes
Database Buffers 16777216 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.

I think now u got it.

vikas

W

hi

I've searched my installation folder, but there is no file named "init.ora" and a folder named XPS inside "admin". The admin location is C:\oracle\ora90

but inside admin there is a folder named "sample" (only this folder inside admin) and inside it a "pfile" folder containing "initsmpl.ora"( 8 kb)

no "init.ora" is found.

wats the prob? Is it any installation error or things like that??
Is there any lite ver's other than 9i; just to work on with sql table?

any way thanks Vikas for ur help...wat to do nw?

krive

Use MYSql for that

as far as oracle is concerned i recommend you

first dissable all running services of oracle

Second remove all Oracle related registeries from registry (using regedit, prefer regcleaner as its quite user friendly and you dont have to search fro oracle entries in reg. using it)

Third remove the directory of the Oracle
Then install the fresh copy of oracle 9i