OraFAQ Forum: Server Administration » database creation manual error

Home » RDBMS Server » Server Administration » database creation manual error (oracle 9i os ibm-aix 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database creation manual error [message #523200]

Fri, 16 September 2011 03:47

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

i am creating database manually in oracle 9i os version ibm-aix5.3 it showing following error

CREATE DATABASE "varathu"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/backup/varathu/control01.ctl'
ORA-27040: skgfrcre: create error, unable to create file
IBM AIX RISC System/6000 Error: 13: Permission denied

[MERGED by LF]

[Updated on: Fri, 16 September 2011 04:30] by Moderator

Report message to a moderator

Re: database creation manual error [message #523203 is a reply to message #523200]

Fri, 16 September 2011 03:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This is a test forum so ... is this question real, or did you just use it to post a dummy, test message?

Anyway: it seems that you aren't allowed to write into /backup/varathu/ directory. What privileges do you have on it?

Report message to a moderator

Re: database creation manual error [message #523206 is a reply to message #523203]

Fri, 16 September 2011 03:56

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

for that directory i am having this permission
drwsr-s--x 5 oracle dba 256 Sep 15 19:52 varathu

inside that directory i am having this permission
drwxr-xr-x 2 oracle dba 256 Sep 15 19:35 backup
drwxr-xr-x 2 oracle dba 256 Sep 15 19:35 archive
drwxr-xr-x 6 oracle dba 256 Sep 15 19:36 admin
-rwsr-s--x 1 oracle dba 349 Sep 15 19:41 varathudb.sql
-rwsr-s--x 1 oracle dba 507 Sep 16 12:47 initvarathu.ora

Report message to a moderator

Re: manual database creation error [message #523214 is a reply to message #523200]

Fri, 16 September 2011 04:21

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

The oracle user doesn't have write permissions on the directory backup/varathu

Report message to a moderator

Re: manual database creation error [message #523216 is a reply to message #523214]

Fri, 16 September 2011 04:25

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

how to check that oracle user have write permission if oracle user doesn't have write permission how to change the user with write permission

Report message to a moderator

Re: manual database creation error [message #523224 is a reply to message #523216]

Fri, 16 September 2011 05:16

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Who executed the sqlplus that issued the CREATE DATABASE?

Retry and post the complete session:

id
env | sort
sqlplus / as sysdba <<EOF
CREATE DATABASE ...
EOF

Regards
Michel

Report message to a moderator

Re: manual database creation error [message #523525 is a reply to message #523224]

Mon, 19 September 2011 04:01

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

SQL> startup nomount pfile=/u01/practice/initpractice.ora
ORA-27123: unable to attach to shared memory segment
IBM AIX RISC System/6000 Error: 13: Permission denied

Report message to a moderator

Re: manual database creation error [message #523533 is a reply to message #523525]

Mon, 19 September 2011 04:37

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You didn't post what I asked.

Also, read How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: manual database creation error [message #523535 is a reply to message #523533]

Mon, 19 September 2011 04:49

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

In ORACLE_HOME/bin ls -l oracle
-rwsr-sr-x 1 nasim oinstall 76743303 Jan 24 2009 oracle
I am having this permission

my initpractice.ora content

control_files='/u01/practice/control01.ctl'
undo_management=auto
db_name=practice
db_block_size=8192

and initpractice.ora permission
-rwxrwxrwx 1 oracle dba 101 Sep 19 16:17 initpractice.ora

my createdb.sql content

create database practice
logfile group 1 '/u01/practice/redo01.log' size 10M,
group 2 '/u01/practice/redo02.log' size 10M
CHARACTER SET WE8ISO8859P1
datafile '/u01/practice/system.dbf' size 100M
sysaux datafile '/u01/practice/sysaux.dbf' size 100M
undo tablespace undo datafile '/u01/practice/undo.dbf' size 50M
default temporary tablespace temp
tempfile '/u01/practice/temp.dbf' size 10M;

createdb.sql permission

-rwxrwxrwx 1 oracle dba 391 Sep 16 19:25 createdb.sql

[/u01/practice]export ORACLE_SID=practice
[/u01/practice]sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.8.0 - Production on Mon Sep 19 16:19:58 2011

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on

Report message to a moderator

Re: manual database creation error [message #523539 is a reply to message #523535]

Mon, 19 September 2011 05:00

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Still not posted what I asked in the way I posted.
Waiting...

Regards
Michel

Report message to a moderator

Re: manual database creation error [message #523542 is a reply to message #523539]

Mon, 19 September 2011 05:04

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

ID
uid=1004(oracle) gid=999(dba) groups=997(oinstall)

env | sort

AUTHSTATE=compat
A__z=! LOGNAME
HOME=/home/oracle
LANG=en_US
LC__FASTMSG=true
LIBPATH=/u01/app/ORACLE/ora92/product/lib32:/u01/app/ORACLE/ora92/product/lib:/usr/lib:/lib
LOCPATH=/usr/lib/nls/loc
LOGIN=oracle
LOGNAME=oracle
MAIL=/usr/spool/mail/oracle
MAILMSG=[YOU HAVE NEW MAIL]
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
ODMDIR=/etc/objrepos
ORACLE_HOME=/u01/app/ORACLE/ora92/product
ORACLE_SID=practice
PATH=/u01/app/ORACLE/ora92/product/bin:/usr/ccs/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
PWD=/u01/practice
SHELL=/usr/bin/ksh
SSH_CLIENT=172.1.21.14 3804 22
SSH_CONNECTION=172.1.21.14 3804 172.1.17.43 22
SSH_TTY=/dev/pts/0
TERM=xterm
TZ=CST6CDT
USER=oracle
_=/usr/bin/env

Report message to a moderator

Re: manual database creation error [message #523544 is a reply to message #523542]

Mon, 19 September 2011 05:22

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 19 September 2011 12:00

Still not posted what I asked in the way I posted.
Waiting...

Regards
Michel

Report message to a moderator

Re: manual database creation error [message #523566 is a reply to message #523544]

Mon, 19 September 2011 06:30

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

sir please tell what exactly i have to send .this is first time i am sending so code format i will correct from next time .please give me the solution sir.

Report message to a moderator

Re: manual database creation error [message #523761 is a reply to message #523566]

Tue, 20 September 2011 05:15

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

SQL> startup nomount pfile=/u01/oradata/TEST/initTEST.ora
ORACLE instance started.

Total System Global Area 160923376 bytes
Fixed Size 741104 bytes
Variable Size 109051904 bytes
Database Buffers 50331648 bytes
Redo Buffers 798720 bytes
SQL>
SQL> create database TEST
2 maxdatafiles 1021
3 maxinstances 1
4 maxlogfiles 8
5 maxlogmembers 4
6 CHARACTER SET WE8ISO8859P15
7 NATIONAL CHARACTER SET UTF8
8 DATAFILE '/u01/oradata/TEST/system01.dbf' SIZE 2000M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
9 EXTENT MANAGEMENT LOCAL
10 SYSAUX DATAFILE '/u01/oradata/TEST/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
11 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oradata/TEST/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
12 UNDO TABLESPACE "PSUNDOTS" DATAFILE '/u01/oradata/TEST/psundots01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
13 LOGFILE GROUP 1 ('/u01/oradata/TEST/redo01.log') SIZE 100M,
14 GROUP 2 ('/u01/oradata/TEST/redo02.log') SIZE 100M,
15 GROUP 3 ('/u01/oradata/TEST/redo03.log') SIZE 100M;
SYSAUX DATAFILE '/u01/oradata/TEST/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
*
ERROR at line 10:
ORA-02165: invalid option for CREATE DATABASE

Report message to a moderator

Re: manual database creation error [message #523763 is a reply to message #523761]

Tue, 20 September 2011 05:29

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no SYSAUX in 9i.

Regards
Michel

Report message to a moderator

Re: manual database creation error [message #523768 is a reply to message #523763]

Tue, 20 September 2011 05:50

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

thanku u very much sir now database is created

Report message to a moderator

Re: manual database creation error [message #523781 is a reply to message #523768]

Tue, 20 September 2011 07:18

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

After database creation successfully i am not able to start the listener

[/u01/app/oracle/product/bin]lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 20-SEP-2011 18:47:16

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Starting /u01/app/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
IBM/AIX RISC System/6000 Error: 1: Not owner

Listener failed to start. See the error message(s) above...

Report message to a moderator

Re: manual database creation error [message #523789 is a reply to message #523781]

Tue, 20 September 2011 07:44

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Not owner

Is this not sufficient information?

Regards
Michel

Report message to a moderator

Re: manual database creation error [message #523792 is a reply to message #523789]

Tue, 20 September 2011 07:49

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

System parameter file is /u01/app/ORACLE/ora92/product/network/admin/listener.ora
Log messages written to /u01/app/ORACLE/ora92/product/network/log/listener.log
Trace information written to /u01/app/ORACLE/ora92/product/network/trace/listener.trc
Trace level is currently 0

Started with pid=405754
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=BDHCPDEV02)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
22-JAN-2009 20:44:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=BDHCPDEV02)(USER=nasim))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LIST
ENER)(VERSION=153092352))

Report message to a moderator

Previous Topic:	bdump dir deleted; cannot get cause of downtime
Next Topic:	Oracle RAC ASM user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:35:16 CST 2024