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

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

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

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 ...


4

For your current session? select host_name from gv$instance where instance_number=userenv('instance'); For all sessions: select i.host_name, s.username from gv$session s join gv$instance i on (i.inst_id=s.inst_id) where username is not null;


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

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

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.


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

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

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.


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.


2

This worked for me (10.2.0.3) SQL> connect dbauser/dbauser Connected. SQL> CREATE USER johndoe IDENTIFIED BY johndoe 2 DEFAULT TABLESPACE "USERS" 3 TEMPORARY TABLESPACE "TEMP"; User created. SQL> GRANT CREATE SESSION TO johndoe; Grant succeeded. SQL> connect johndoe/johndoe Connected.


2

If you used double quotes to create the user and give the password, then case becomes significant. I don't have an 11g DB here, but 10g allows me to create a user in lower case, and then I'm stuck using double quotes to log in with: sqlplus /nolog SQL> connect "test"@db Enter password: Connected.


2

OUI (Java installer) seems to run on a Java 32 bits so is unable to retrieve high values as SHMMAX that some GNU/Linux set as an 64bit -1 to big for a 32bit integer. Set in /etc/sysctl.conf: kernel.shmmax = 4294967295 And then run: /sbin/sysctl -p Note: this is for maximum block for each share block segment and not a sum of shared memory used for a ...


2

Some points I didn't see in other answers so far: A high end server SSD will ge bood for about 30.000 IO. RealSSD go up to 50.000 As such, you CAN use RAID 5. Point. Your bottleneck is very likely going to be the RAID controller which simply is not made with SSD IOPS in mind, so it will max out it's CPU. In general, SSD are about 100 times as fast as SAS ...


2

You can download it from Oracle; here is the product page.


2

Run strace -f apachectl start and see what the last dozen lines or so are trying to do. The output is a little bit crazy, so you might update your question with the output, and maybe someone can help.


2

Your very first error is to modify an object owned by SYS. You should not UPDATE/DELETE/TRUNCATE any object owned by SYS unless expressly told by support. Oracle provides APIs (packages) and DDL commands (ALTER DATABASE, etc.) to interact with the system objects and you should not use anything else. Now, this is not how you change the database character ...



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