| Unknown error (for me) [message #120222] |
Wed, 18 May 2005 09:35  |
dstjahjono
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
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 
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
