Tag Info

Hot answers tagged

11

"We open a connection, make a quick query and then drop the connection. Very short connections but many of them." I'd try with Shared Server connections. Oracle running on a unix box needs a unix process to do the 'work' requested by a session. Conventionally, under a dedicated connection, it forks a new unix process when a session connects and kills it ...


9

You are being asked to do it wrong. You should not be logging in to production systems and doing periodic manual checks. This guarantees that you will (a) miss something that happens between the checks and takes your business down, and (b) eventually screw up while doing the checks and take the business down. Instead, you should be implementing a ...


7

Sun Solaris, because: the system is rock solid and itself one of best it's been Oracle's primary and reference platform for a long time (and still is patched very early and well tested) it scales from a $200 PC to massive multiprocessor machines (think development, test and production each cost effective in almost the same environment) has best ...


7

But watch out : Do not use the character set named UTF8 as the database character set unless required for compatibility with Oracle Database clients and servers in version 8.1.7 and earlier, or unless explicitly requested by your application vendor. Despite having a very similar name, UTF8 is not a proper implementation of the Unicode encoding UTF-8. If the ...


6

You'll need a separate account to grant the read-only access to. I would suggest adding a role that you grant read-only access to as well-- you can then re-use that role if more users need this access in the future. CREATE ROLE my_read_only_role; BEGIN FOR x IN (SELECT table_name FROM dba_tables WHERE owner=<<schema name>>) LOOP ...


6

Oracle 11g release 2 - Microsoft Windows Installation Guide


4

You should have two choices to make : Choose your database character set (used by VARCHAR2, CHAR, CLOB datatypes). Choose your national character set (used by NVARCHAR2, NCHAR, NCLOB datatypes). As seen here : Oracle recommends using Unicode for all new system deployments. National character sets can only be Unicode : UTF-8 or UTF-16. So ...


4

I don't think there's such a thing as the "best" OS for the purposes you're using Oracle for here. A sandbox and the number of users you have is relatively small scale stuff; this ain't a huge Fortune 500 deployment. I also get the feeling that "unbreakable" security - while always good to have - isn't as crucial a factor in this case as it would be in ...


4

Is it not here ? "Oracle Database 11g Release 2 Standard Edition, Standard Edition One, and Enterprise Edition" Careful of those license costs for dev servers!


4

It's the os user oracle, which you should have created in step 4: # useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle


4

It looks like the errors below are fairly clear but have added a few points below each one which may help you. Recommendation: Make sure you are installing the software on the correct platform. Recommendation: Install the recommended Service Pack. For both of these recommendations, make sure you have the latest service packs installed on ...


4

Have you tried changing your password, since it seems to have expired? That would seem like a logical place to start given that error message.


4

It appears as though you are asking whether you can have two instances of the same RAC (in an active-passive configuration) connected to different set of disks. The answer to this question is no. To quote from the Introduction to Oracle RAC linked to in the comments of your other question: An Oracle RAC database is a shared everything database. All data ...


4

Use procmon to check your disk queue lengths when this happens, as well as looking for bad disk sectors or trouble with that RAID5 array (which is what my experience tells me is probably the problem). I should add that I had what sounds to be the exact same problem with an ESXi host a few months back, and it turned out that the RAID5 array was degraded (had ...


3

I'd go by Oracle's recomendations, and since Oracle really want's its own box then using Oracle Unbreakable Linux makes the most sense. If you need to scale above what a single AMD64 machine can handle then, and only then, would I consider some of the midrange Sun SPARC hardware.


3

it seems like a bug, regression from 10g... did a quick lookup in metalink and didn't find anything... How about opening an SR with a test case of 10g vs 11g? if it is a known issue, you might get a patch. If it isn't, they will hopefully fix it (eventually). In a bit related note, you can consider using RMAN to check for physical and logical corruptions in ...


3

Firstly, separate the concepts of database "software installation" from the database "store of data". 11.2.0.2 has changed the upgrade mechanism. Previously you had to install the base version of the software then run an upgrade. 11.2.0.2 is installed as a separate product. There's a walkthrough here, but the actual steps may vary depending on what your ...


3

There are choices here. Check out the Oracle Documentation Upgrade Guide for more info.


3

Is the listener listening on the external ip? You can check with netstat -an if the listener is listening on port 1521 of 127.0.0.1 only or if it listens also on 192.168.... Remote login is on by default afaik. If you create a new user the user need the roles resource and connect to be able to connect to the DB and to create tables and other stuff.


3

The algorithm for Java applet caching is described here. Try getting Apache to return reasonable Last-Modified headers. If this is not happening, this could mess up the caching algorithm. Last-Modified should be a later date than the previous applet. Also check that the MIME type for the JAR files from Apache are application/java-archive, as not having ...


3

Are you able to change the link that users click to open the java file? If so, there are a couple of ways to fix it there: change appname.jar to appname.jar?version=20120124. add <param name="cache_option" value="no"> between <object> and </object>. (This will cause clients to reload the latest version every time, not just once.)


3

Visiting the equivalent page in the 11g version of Oracle 2 Day DBA, I see that the monitoring you are referring to is now done in SQL Developer, rather than via web interface. It appears the web interface you were previously using is completely gone in 11g. Sorry for the bad news.


2

First suggestion is to never mess with them manually unless you really know what you're doing. What you want to do is read up on rman, the Oracle tool for performing backups (including redo log backups). I would highly recommend researching this pretty thoroughly to make sure you fully understand how the various aspects of Oracle backups work before you ...


2

Try this: DataGuard starting with Rman


2

Found the culprit; running the installer with the -noconfig option causes the configuration assistants to not inherit the passwords from the silent installation configuration file. So, this doesn't work: su oracle -- database/runInstaller -silent -noconfig -responseFile `pwd`/ORA11G_Linux.rsp But this does: su oracle -- database/runInstaller -silent ...


2

I've run into this problem before on a machine where windows was managing the swap space. Oracle, thinking it's smarter than windows, seems to require you to have your swap space discretely allocated. You can do that by following the steps below. How to: Right click on my computer > properties > advanced In the Performance section click on 'Settings' and ...


2

Oracle Enterprise Linux (OEL): It's currently Oracle's primary developement platform and supports all the latest features. OEL/RHEL has a good record of stability and performance for Oracle databases. Oracle directly supports the OS, giving you a single point of contact for any issues and much less chance of playing the blame game. Oracle maintains OEL, ...


2

Check out these links from the 11g Data Guard Concepts and Administration (you don't need Data Guard to be configured for these to be useful): 3.2.7 Verify the Physical Standby Database Is Performing Properly or 4.2.6 Verify the Logical Standby Database Is Performing Properly. If you have Grid Control, it's even easier. There's a link under Maintenance ...


2

You can find the config files for the database specific DBCONSOLE in your ORACLE_HOME under a direcory named with the FQDN of the Host, an underscore, and the SID. eg myhost.mynetwork_mydatabase You could try stopping the dbconsole with set ORACLE_SID=mydatabase emctl stop dbconsole Then fiddling with the config files and dir names and then restarting ...


2

The expiration of passwords in Oracle is controlled by the profile that is assigned to the user. You can see which profile is assigned to each user by querying the DBA_USERS table SELECT username, profile FROM dba_users You appear to be hitting the PASSWORD_LIFE_TIME limit. Prior to 11g, the DEFAULT profile had this set to UNLIMITED. To improve ...



Only top voted, non community-wiki answers of a minimum length are eligible