| GOPU |
Posted: May 15, 2008 01:50:01 AM |
Total Post: 242
Joined: Apr, 2008
|
For creating the database,I tried to start the instance but it is throwing the error..
SQL> startup nomount pfile='/u01/app/oracle/product/10.2.0/Db_1/dbs/initgopu.ora
ORA-01031: insufficient privileges
SQL> |
|
|
 Bishal |
| Posted: May 15, 2008 02:36:50 AM |  |
|
Total Post: 196
Joined: Apr, 2008
|
To solve this problem, simply create a file named sqlnet.ora if you dont one,in your ORA_HOME\network\admin directory and add to it the following line:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Save the file.
After this, try starting the instance using the same procedure described above and your O/S based logon should work just fine!
|
|
|
|
|
| Murtuja |
| Posted: May 15, 2008 02:38:44 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
You have to create password file first
Windows
http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html
|
|
|
|
|
| Murtuja |
| Posted: May 15, 2008 02:43:59 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
create password file using below command
orapwd file=orapwSID password=oracle entries=5
|
|
|
|
|
| GOPU |
| Posted: May 15, 2008 02:44:23 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
Murtuja you are right ,it is the problem with the passwrod file..
now wht the problem i am facing is with the controlfile ... ?
wht the error i am getting in the alert log is
ORA-00202: control file: '/u01/app/oracle/gopu/controlfile.ctl'
ORA-27047: unable to read the header block of file
SVR4 Error: 17: File exists
Additional information: 1
Fri May 16 12:15:39 2008
ORA-205 signalled during: alter database mount...
|
|
|
|
|
| Murtuja |
| Posted: May 15, 2008 02:58:46 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
Hi Gopu,
compare control file realted location from your "initgopu.ora" and "create database" statement.
You have to give same location in both.
|
|
|
|
|
| Murtuja |
| Posted: May 15, 2008 03:00:42 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
Hi,
Please check your alert.log file for more info.
|
|
|
|
|
| Murtuja |
| Posted: May 15, 2008 03:10:36 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
Hi,
>>>> SVR4 Error: 17: File exists
It means you have to delete control files before running "create database" statement.
|
|
|
|
|
| GOPU |
| Posted: May 15, 2008 03:16:11 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
in the initfile the controlfile path i given is
control_files='/u01/app/oracle/gopu/controlfile1.ctl'
the instance is comming to the nomount stage.
after when i run the createdb script the databse is not creating... this is the issue.
the database is not created in the specified path
|
|
|
|
|
| Murtuja |
| Posted: May 15, 2008 05:01:20 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
Hi,
go to /u01/app/oracle/gopu/ location.You will find control files there.delete those control files and run your createdb script.
|
|
|
|
|
| Gitesh |
| Posted: May 15, 2008 05:08:31 AM | |
|
Total Post: 322
Joined: May, 2005
|
When manual database creation is fail that time we should need to delete all files like control files,redo log files,datafiles. After that again we should need to execute database creation script.
|
|
|
|
|
| GOPU |
| Posted: May 15, 2008 05:36:14 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
Thanks guys it worked.....
there is some problem,the database is created :)
|
|
|
|
|
| yogi |
| Posted: May 15, 2008 05:37:59 AM | |
|
Total Post: 9
Joined: Apr, 2008
|
hi gopu do this
create directory like CDUMP,BUMP,ADUMP,UDUMP using MKDIR coomand
let parameter file like this :my init
sir.__db_cache_size=184549376
sir.__java_pool_size=4194304
sir.__large_pool_size=4194304
sir.__shared_pool_size=402653184
sir.__streams_pool_size=0
*.background_dump_dest='/d04/stony/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/d04/stony/control01.ctl','/d04/stony/control02.ctl','/d04/stony/control03.ctl'
*.core_dump_dest='/d04/stony/cdump'
*.db_block_size=8192
*.db_cache_size=67108864
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='sir'
*.db_recovery_file_dest='/d04/stony/recover'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=sirXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=200278016
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=601882624
*.shared_pool_size=4194304
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
*.user_dump_dest='/d04/stony/udump'
create script : stone .sql for example
// contents of script
CREATE DATABASE "SIR"
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/d04/stony/redo1.log' SIZE 10M,
GROUP 2 '/d04/stony/redo2.log' SIZE 10M,
GROUP 3 '/d04/stony/redo3.log' SIZE 10M
DATAFILE
'/d04/stony/system.dbf' size 200m,
'/d04/stony/usr04.dbf' size 10m
sysaux datafile '/d04/stony/sysaux.dbf' size 200m
undo tablespace undotbs
datafile '/d04/stony/undo.dbf' size 100m
CHARACTER SET US7ASCII
;
in sqlplus
execute following commands
startup pfile nomount ='$ORACLE_HOME/dbs/initsir.ora';
@ location/stone.sql
after that
run catalog.sql, cataproc.sql
try out this
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
