| Unknown error (for me) [message #120231] |
Wed, 18 May 2005 09:59  |
dstjahjono
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
I posted this question in Beginner forum but somebody told me to post it here. Sorry for double posting.
----------------------------------------------------------------
I am a new Oracle user. Just installed coz it's required for SAP, so almost
99.99% no knowledge 
During installation I got an error message,
Oracle Server Manager Release 3.0.6.0.0 - Production
(c) Copyright 1999, Oracle Corporation. All Rights Reserved.
Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
PL/SQL Release 8.0.6.0.0 - Production
Connected.
CREATE TABLESPACE PSAPUSER1D
*
ORA-00059: maximum number of DB_FILES exceeded
Server Manager complete.
Found information by googling to update the DB_FILES in init<SID>.ora but I
do not see any information rgding DB_FILES in there
shared_pool_size = 98817802
shared_pool_reserved_size = 9881780
db_block_buffers = 18094
control_files = (
D:\oracle\DST\sapdata1\cntrl\cntrlDST.dbf,D:\oracle\DST\sapdata2\cntrl\cntrl
DST.dbf,D:\oracle\DST\sapdata3\cntrl\cntrlDST.dbf )
MAX_ROLLBACK_SEGMENTS = 400
rollback_segments = (START_0)
so I added manually,
DB_FILES = 30 (why did I put 30? just trial and error) then restard the
Oracle services.
Rerun the SAP Setup and I got the error message [unfortunately I forgot to
copy ] Removed the DB_FILES from the init<sid>.ora, rerun the
setup and now I get these error messages.
Oracle Server Manager Release 3.0.6.0.0 - Production
(c) Copyright 1999, Oracle Corporation. All Rights Reserved.
Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
PL/SQL Release 8.0.6.0.0 - Production
Connected.
ORACLE instance started.
Total System Global Area 141294512 bytes
Fixed Size 52144 bytes
Variable Size 103653376 bytes
Database Buffers 37056512 bytes
Redo Buffers 532480 bytes
ORA-01506: missing or illegal database name
alter database noarchivelog
*
ORA-01126: database must be mounted EXCLUSIVE and not open for
this operation
alter database open
*
ORA-01107: database must be mounted for media recovery
Server Manager complete.
Tried to do,
D:\orant\BIN>TNSPING80 ucam
TNS Ping Utility for 32-bit Windows: Version 8.0.6.0.0 - Production on
18-MAY-15 21:25:02
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=ucam)(PORT=1521))
TNS-12541: TNS:no listener
My TNSNAMES contains,
DST.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = ucam)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = DST)
(GLOBAL_NAME = DST.WORLD)
)
)
Please advise, what I should do.
As I am no experience, please give me the step-by-step actions including
username/password (if it's required).
Thx a lot 
|
|
|
|
| Re: Unknown error (for me) [message #120459 is a reply to message #120231] |
Thu, 19 May 2005 21:45  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
ORA-00059 maximum number of DB_FILES exceeded
Cause: The value of the DB_FILES initialization parameter was exceeded.
Action: Increase the value of the DB_FILES parameter and restart Oracle.
----------------------------------------------------------------
Note :- Parameter file means init.ora files there you can get parameter ..
----------------------------------------------------------------
From :- sunil
|
|
|
|
| Re: Unknown error (for me) [message #120461 is a reply to message #120459] |
Thu, 19 May 2005 22:00 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
ORA-01107 database must be mounted for media recovery
Cause: An attempt to perform media recovery was made but the database is not mounted.
Action: Mount the database.
_____________________________
Try this at SQL prompt
SQL>startup mount
SQL>Alter database open
-----------------------------
From:- Sunil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
