OraFAQ Forum: Server Administration » Unknown error (for me)

Home » RDBMS Server » Server Administration » Unknown error (for me)

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

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 Embarassed

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 Embarassed

] 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 Cool