Oracle 9i Database Free Download For Windows 7 64 Bit
Denna Repaci
Viewed 1000+ timesYou Asked Hi Tom,I have been asking regular questions from you. I hope that does not bothers you too much. I have made a recent trasition from Unix to NT so I am little confused about services in NT for
the Oracle DB. In NT there is something called 'SERVICE'. How is that connected to DB ? If that service is stopped then what does that mean - the database is up or not ?
If we have to shutdown that database normally then if we stop the service, will the database be shutdown ? or we have to stutdown the database then dtop the service. What should be the sequence for shutting down the database and bringing it up again so that database
keeps running smoothly? I hope my question is clear.
Basically I want to know the relationship between the service and database up/down status/procedure.
and Tom said...Sorry to hear of your predicament. I hope you can get back to unix soon ;) (hey, we are all entitled to our opinions)
The SERVICE is how the database "bootstrap" process gets going. If the service is running that means the database may or may not be up. If the service is NOT running, the service will NOT be up.
When the service is running, normally it indicates the database is up and running (but does not imply that it is). For example, I have my 9i instance setup so that it does NOT startup with the service starting up. So, I have to start the instance and then I use sqlplus to startup the database.
You can use sqlplus/svrmgrl to shutdown normal the database, typically, the stopping of the service will actually "crash" the instance (NT can be impatient and can kill the service on shutdown instead of waiting for it to end).
The relationship between the OracleService%ORACLE_SID% and the datebase "up down" state is this:
o if the service is not running, the database is definitely not up
o if the service is running, the database might be up and if it is not, you can start it up.
follow up to comment three
I find that time spent in books and manuals is not wasted.
where do you think I get many of my answers from? I read the manuals and books. I used the software.
This was not one of them, but I frequently get questions that I answer with a simple URL pointing the questioner to the documentation. I would urge and encourage everyone to read the manuals. There is some truly useful information in there.
Start with the server concepts manual (which I reread with every release).
it is DEFINITELY not a waste of time.
followup to comment 5
Thats just part of the story... there are two other parameters you need to be aware of as well:
ORA_SID_SHUTDOWN
Possible values: TRUE or FALSE
Set this to TRUE to enable the proper shutdown of the database
ORA_SID_SHUTDOWN_TIMEOUT
Possible values: timeout in seconds (30 for example)
Sets the maximum time (in seconds) to wait for the
shutdown to complete before the service for a particular SID stops.
This timeout should be set high enough to give the database time
to complete the shutdown.
If this is lower then the time needed, you won't have a clean shutdown!
You can check this in the alert file.
ORA_SID_SHUTDOWNTYPE
Possible Values: i , t , a.
where n = shutdown normal
i = shutdown immediate
and a = shutdown abort
If the entry's are not set, stopping an service will do WORSE then an shutdown
abort. Windows NT / 2000 will just "clean" the memory. This could be compared
by a kill -9 on unix.
So, NT will still crash your instance if the database takes longer then it likes to shutdown. NT has ( i believe ) a 20 second default in addition upon which it'll kill the service. There is a registry WaitToKillServiceTimeout that controls this.
Rating (10 ratings)
Is this answer out of date? If it is, please let us know via a Comment Comments Comment What is the feature of oracleAnna Lee, July 13, 2001 - 10:33 pm UTC
Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account. More to Explore PL/SQL demos Check out more PL/SQL tutorials on our LiveSQL tool.
I have a Windows 2008 Server with an Oracle 11g R2 (11.2.0.3, Standard, 64-bit) database. I need to install an additional database (11.2.0.3, Standard, 64-bit) for tests on the same server. These tests target database patches, which shall first be applied on the new database before applying these patches on the existing database, to evaluate potential problems after patching.
I am used to install, configure and manage Oracle databases as stand-alone, RAC or as physical standby via DataGuard since 9i - as long as I am in a Un*x / linux (Red Hat Enterprise Linux, CEntOs, Oracle Enterprise Linux, etc.) environment. Setting up multiple instances in a single home or multiple homes has never been an issue for me until now.
I have searched google, oracle.com, and other related forums already. But I could not find any results regarding installing two or more Oracle homes on Windows. I have found guidelines on copying / cloning an instance into a new home, but if i recall correctly it is meant for copying / cloning onto other servers and not on the same server. Since the existing database is installed on Windows, I am afraid that I may damage the existing install by running the setup wizard again, changing Windows registry values and running the database as service.
Now , the last few after hours patching reboots (database is open during the reboot) this one db doesn't come up with the windows service. Even after all the users log off before the shutdown. Nothing is obvious in the alert.log file.
Any thoughts on what to check or change to ensure the db does proper cleanup on startup.. assuming I don't shut it down clean, which is not always an option. The windows service is set to automatic, naturally. There are 2 11g databases on this server.
I'm trying to connect to this database in Excel and pull out some data to see if we can work with them in Excel. We also use another software to access the database and build reports in it, and while this software is really sophisticated, it lacks in some aspects we'd like and therefore I'd like to try to do few things in Excel.
So far, I've spent about two hours Googling and searching around the web how to connect to the Oracle database, and most tutorials are pretty straight forward. In Excel, I should go to Data, and tab, then Get Data > From Database > From Oracle Database. If I don't see the Get Data button, then click New Query > From Database > From Oracle Database. This is from Office Support article on how to connect to Oracle Database. However, I do not have any such options in Excel.
I have Oracle 11.2.0 installed with Administration package option (it's necessary to install it for software we use to work), and the PATH system variable has oracle install folder also correctly set.
So my question is, is there problem in my Office installation, or does Business 365 plan not include these options (connect to Oracle)? What or where should I do if I'm not in correct place for my issue?
Oracle Database@Azure delivers all the performance, scale, and workload availability advantages of Oracle Database on OCI with the security, flexibility, and best-in-class services of Microsoft Azure, including best-in-class AI services like Azure OpenAI. This combination provides customers with more flexibility regarding where they run their workloads. It also provides a streamlined environment that simplifies cloud purchasing and management between Oracle Database and Azure services.
The new service delivers a fully integrated experience for deploying, managing, and using Oracle database instances within Azure. It enables organizations to drive breakthroughs in the cloud using their existing skills to leverage the best of Oracle and Microsoft capabilities directly within the Azure portal.
As a result of this expanded partnership, customers will have the choice to deploy their Azure services with their fully managed Oracle Database services all within a single datacenter, including support for Oracle Exadata Database services, Oracle Autonomous Database services, and Oracle Real Application Clusters (RAC). Oracle and Microsoft have also developed a joint support model to provide rapid response and resolution for mission-critical workloads.
Additionally, Oracle and Microsoft have significantly simplified the purchasing and contracting process. Customers will be able to purchase Oracle Database@Azure through Azure Marketplace, leveraging their existing Azure agreements. They will also be able to use their existing Oracle Database license benefits including Bring Your Own License and the Oracle Support Rewards program.
About Oracle
Oracle offers integrated suites of applications plus secure, autonomous infrastructure in the Oracle Cloud. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.
i have access to an oracle database but for some reason I cannot access the database and keep getting error message stating "Oralce: ORA-12541: TNS: No Listener". I have tried the following as stated other knowledge base
Having said the above, I went to verify if my connection from the ODBC driver works fine and I'm able to connect successfully but cannot connect via Data > New Query > Database > Oracle Database and the same applies for ODBC.
New Query > connect to DB > Oracle Database > in the servername the syntax to use is "hostname:[port number] /SID" which I was using only as host ID. After this update, it all worked fine.
7fc3f7cf58