Random Post :
#757
Step 1:
SELECT name,value FROM v$parameter WHERE name IN ('undo_management','undo_tablespace');
NAME VALUE
——————– ——————–
undo_management MANUAL
undo_tablespace UNDO_TBS
Step2:
select FILE_NAME, TABLESPACE_NAME from dba_data_files where TABLESPACE_NAME like 'UNDO%';
FILE_NAME TABLESPACE_NAME
—————————————————————-
/path/to/tablespace/undotbs_02.dbf UNDO_TBS
/path/to/tablespace/undotbs_01.dbf UNDO_TBS
Step 3: Create a new undo tablespace
create UNDO tablespace UNDOTBS datafile '/path/to/tablespace/undotbs01.dbf' size 1024m REUSE AUTOEXTEND ON NEXT 4096K MAXSIZE 1024M;
Tablespace created.
Step 4:
ALTER SYSTEM SET undo_tablespace = 'UNDOTBS' scope=spfile;
System altered.
Step 5: set old undo tablespace offine mode and drop
ALTER TABLESPACE UNDO_TBS offline;
Tablespace altered.
drop tablespace UNDO_TBS including contents and datafiles;
Tablespace dropped.
Step 6:
Rebounced the db services
Step 7: Changed the undo management parameter to AUTO
alter system set undo_management='AUTO' scope=spfile;
System altered.
SELECT name,value FROM v$parameter WHERE name IN ('undo_management','undo_tablespace');
NAME VALUE
——————– ——————–
undo_management AUTO
undo_tablespace UNDOTBS
Now the database is up and running with no issue and we cant find any ora error in the alert log file,
database, oracle
#782
http://tom23.com/?p=110
#897
Oracle :
SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1
MySQL :
SELECT column FROM table
ORDER BY RAND()
LIMIT 1
MySQL
#1972
Source: Extend a CentOS Oracle VirtualBox Image with more Disk Space — munz & more
CentOS, Disk, virtualbox
#246
Delcare a new virtual host (host1 for example) :
<VirtualHost _default_:80>
# Root Folder
DocumentRoot /var/www
# Protect parent folder
<Directory />
Options FollowSymLinks
AllowOverride None
</Directory>
# Allow redirection (htaccess) for current colder
<Directory /var/www/host1>
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order allow,deny
allow from all
</Directory>
# Protect script folders
ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
<Directory "/usr/lib/cgi-bin">
AllowOverride None
Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
Order allow,deny
Allow from all
</Directory>
# ##############################################################
# LOGGING
# ##############################################################
ErrorLog ${APACHE_LOG_DIR}/host1_error.log
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
LogLevel warn
CustomLog ${APACHE_LOG_DIR}/host1_access.log combined
# ##############################################################
# IE special functions
# ##############################################################
BrowserMatch "MSIE [2-6]" \
nokeepalive ssl-unclean-shutdown \
downgrade-1.0 force-response-1.0
# MSIE 7 and newer should be able to use keepalive
BrowserMatch "MSIE [17-9]" ssl-unclean-shutdown
# ##############################################################
# Proxy configuration
# ##############################################################
ProxyRequests Off
ProxyPreserveHost On
# ##############################################################
# Alias configuration
# ##############################################################
Alias /<context_root> /var/www/host1
</VirtualHost>
apache, web