Friday, May 27, 2005
Automatic for the people.
There was a discussion over on the Dizwell Forum regarding ASM, which as discussions tend to do moved on to Oracle Managed Files and the fact that you don't need to specify file name or file size anymore.
I felt that this didn't quite go far enough.
No need to know what the files are, what the users passwords are, etc etc.
1 Comments
I felt that this didn't quite go far enough.
C:\Documents and Settings\user>oradim -new -sid demo
Instance created.
C:\Documents and Settings\user>orapwd file=e:\oracle\10g\db\database\pwddemo.ora password=demo entries=5
C:\Documents and Settings\user>set oracle_sid=demo
C:\Documents and Settings\user>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on Fri May 27 14:21:58 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to an idle instance.
SYS@demo>startup nomount
ORACLE instance started.
Total System Global Area 788529152 bytes
Fixed Size 790936 bytes
Variable Size 204467816 bytes
Database Buffers 583008256 bytes
Redo Buffers 262144 bytes
SYS@demo>create database demo;
Database created.
SYS@demo>
No need to know what the files are, what the users passwords are, etc etc.
1 Comments:
You could extend this even further - just set db_file_recovery_dest and a belly load of other things now go to 'automatic' places with 'automatic' names.
Post a Comment
