| | How to drop Oracle database
Dropping database from sqlplus
1. Shutdown the database
SQL> shutdown immediate;
2. Mount exclusive and put in restricted mode
SQL> startup nomount;
SQL> alter database mount exclusive;
SQL> alter system enable restricted session;
3. Drop database
SQL> drop database; | | More...
06/04/08 | | | | | | | | |
|
|
| | Cannot connect to database when running irca.sh
If you get the following error message:
ERROR: Failed to establish database connection due to the following error:
ORA-01017: invalid username/password; logon denied
when trying to run irca.sh to create schemas in SOA backend database it may be because remote_login_passwordfile parameter is not set. Run the following command from sqlplus:
SQL> alter system set ... | | 
More...
04/04/08 | | | | | | | | |
|
|
|
|
| | How to enable auditing in Oracle database
For Oracle versions prior to 9 set audit_trail parameter in ini file i.e.:
audit_trail = DB
For Oracle 9 and later:
alter system set audit_trail = DB;
If you want to audit a specific user run the following:
audit alter table, select table, insert table, update table, delete table, grant table, grant procedure by USERNAME;
To ... | |
More...
11/08/07 | | | | | | | | |
|
| | View what sql user is running
-- View SQL text for user session
-- Replace DB_USER with the actuall database username and os_user with the OS username.
select a.sql_text, b.username, b.osuser, b.logon_time, b.program,
b.machine, b.sid, b.serial#
from v$sql a, v$session b
where a.address = b.sql_address
and b.username = 'DB_USER'
and b.osuser = 'os_user'; | | More...
11/01/07 | | | | | | | | |
|
| | How to find out character set for a database
SQL> select * from v$nls_parameters;
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
US7ASCII
...
| | More...
10/25/07 | | | | | | | | |
|
| | Make backupset unavailable in RMAN
This may be useful when you want to restore archive logs which were backed up more than once. These archivelog files will be included in multiple backup sets in the RMAN catalog, by default it will attempt to restore from the latest backup. But what if at the moment you ... | |
More...
07/25/07 | | | | | | | | |
|
<< 1 | Page 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 >>
|
