Thank you very much, sir
I will try this
"Richard" <qaz1521_at_hotmail.com> wrote in message
news:bgc8s5$brr$1$8302bc10_at_news.demon.co.uk...
> See comments
>
> "newbie" <newbs__--_at_hotmail.com> wrote in message
> news:bgb9hj$61hdb$1_at_ID-158805.news.uni-berlin.de...
> > I installed Oracle 8i on Windows 2003
> > I have the same problem when I installed Oracle 9i on Windows XP Pro
> > I have no idea what you mean by "Oracle not running"
>
> I've not used Oracle on Windows 2003 or XP but I'd assume it works in a
> similar way to NT.
>
> To use Oracle, the Oracle server processes need to be running (it's
> multithreaded on Windows so you might only see one process) and you need
to
> have in memory data structures set up.
>
> By default, starting up the Windows service does not make Oracle useable.
> There is a command line utility called ORADIM (might be ORADIM80 in Oracle
> 8i) that you can run. Type this into a DOS window to see a list of
options.
>
> You should be able to type a command like this at the command prompt:-
>
> oradim -edit -sid TEST1 -startmode a
>
> The SID parameter is the Oracle system identifier. You will have
specified
> this when you created the databases (Test1 I think you said). Also, it
will
> appear in the names of the OracleService services that get created.
>
> The '-startmode a' parameter tells Oracle to start automatically when
> OracleServiceTEST1 starts. If you set the service to start automatically
at
> boot time and use
>
> oradim -edit -sid TEST1 -startmode a
>
> then your database should be accessible shortly after boot time.
>
> > I looked in all help files & they are not much help
>
> In my opinion, the help files and documentation are good for reference but
> not good for learning Oracle if you are just starting out. There are some
> good books around though so it would probably be worth having a look round
a
> decent book shop.
>
> The alternative is training courses but these tend to be very expensive.
I
> was lucky because my employers paid for my training but not everybody is
> this fortunate. I think Oracle run some sort of CD or Internet based
> training and this might be a bit less costly.
>
> > I have two databases called Test1 & Test 2
> > In the Oracle Admin Assistant they show up under Databases item
> > I can start & stop the Service successfully on them
> > However when I click on the first item called connect database, a popup
> > window asks for username & password
> > In the top of the box it says
> > "Enter the Oracle username and password with which to connect to the
> > database. To avoid being prompted with this dialog box again, grant
> database
> > administrator privileges to your NT user name".
> > I have full rights to this machine (at home) as admin. How do I do this
?
>
> If I remember correctly, you need to create a Windows user group called
> ORA_DBA and add to this all of the Windows users you want to allow to
> connect to the database without a password.
>
> > I also noticed in 8i that there was no Enterprise Manager as a Start
Menu
> > item
> > but I see it in 9i. Was it used to be an optional item in 8i or
something
> ?
>
> Not sure about this but you can download Enterprise Manager from
> technet.oracle.com.
>
> Good luck,
>
> Richard
>
> >
> >
> >
> > "Richard" <qaz1521_at_hotmail.com> wrote in message
> > news:bga0fe$fuu$1$8300dec7_at_news.demon.co.uk...
> > > This could mean Oracle is not running. Can you try starting it ? What
> > > operating system are you using?
> > >
> > > "newbie" <newbs__--_at_hotmail.com> wrote in message
> > > news:bg9stm$lsho9$1_at_ID-158805.news.uni-berlin.de...
> > > > I installed Oracle 8i
> > > >
> > > > The database I created was called test1
> > > >
> > > > It gave this during install
> > > > ----------------------
> > > >
> > > > global datbase name : test1
> > > > database SID : test1
> > > > internal account password: oracle
> > > > SYS account password : change_on_install
> > > > SYSTEM account password : manager
> > > >
> > > > I went to SQL Plus & tried to launch it.
> > > > No combination of username / passwords as suggested by Oracle
> > > > above worked. I get the error
> > > >
> > > > (I am not sure what to install at HOSTSTRING. I assume it is the
> > > > hostname I tried blank as well)
> > > >
> > > > EROOR:
> > > > ORA-01034:ORACLE not available
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Thu Jul 31 2003 - 21:33:42 CDT
