pythontr.com
SELECT version FROM v$instance;
startup nomount pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora';
SQL> CREATE DATABASE "orcl" 2 MAXINSTANCES 8 3 MAXLOGHISTORY 1 4 MAXLOGFILES 16 5 MAXLOGMEMBERS 3 6 MAXDATAFILES 100 7 DATAFILE '/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED 8 EXTENT MANAGEMENT LOCAL 9 SYSAUX DATAFILE '/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED 10 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED 11 UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED 12 CHARACTER SET WE8ISO8859P15 13 NATIONAL CHARACTER SET AL16UTF16 14 LOGFILE GROUP 1 ('/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/redo01.log') SIZE 10240K, 15 GROUP 2 ('/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/redo02.log') SIZE 10240K, 16 GROUP 3 ('/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/redo03.log') SIZE 10240K 17 USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword"; old 17: USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword" new 17: USER SYS IDENTIFIED BY "oracle" USER SYSTEM IDENTIFIED BY "oracle" CREATE DATABASE "orcl"
startup show parameter db_name alter system set db_name=ORCL scope=spfile;
vim /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora logging_listener = off
Yorumlar