Jul 10, 2012 | Database, PITSS.CON, Resolve Issues, Unix / Linux
If a problem occurs in PITSS.CON where it appears to hang or freeze, some updates to the database environment may be required. The following steps may be run to fix any PITSS.CON hung sessions: On the database server, using the unix prompt logged in as oracle: ulimit...Jul 10, 2012 | Database, Install / Config
It is possible to automatically generate a primary key for Oracle Database tables when they are created. The steps below will show how to configure database tables so that primary keys are automatically generated: The following example would create an automatic...Jul 10, 2012 | Database, Install / Config
Creates a 5MB Tablespace with autoextend. Substitute “INDX” with the name of the tablespace you desire. The path (as shown below) should be the path leading to your database’s tablespace data files. CREATE TABLESPACE INDX DATAFILE...Jul 10, 2012 | Database, PITSS.CON, Resolve Issues, Windows
If you try to log into PITSS.CON in Windows and you are unable to log in (not being able to go beyond the login screen) despite the fact you entered the correct credentials and the correct database, you should check to see if the TNS Listener is currently running. 1....
