Component : Oracle - Installation Windows

Solution : https://service.sap.com/sap/support/notes/50088 (SAP Service marketplace login required)

Summary :
The SAP Note details procedures for creating and managing OPS$ users in Oracle databases on Windows NT for SAP systems. Key targets for OPS$ user creation are SAPService and ADM, crucial for system operation and security. The note delineates the OPS$ mechanism, enhancing database security by restricting password access exclusively to specific operating system users. It is pertinent for executing secured backups via transaction DB13 in CCMS and supports both central and distributed SAP system architectures through SQL*Net V2. Specific configurations like setting "remote_os_authent=TRUE" are necessary for distributed environments, excluding Oracle 8.*. Comprehensive guidance on creating OPS$ users across various Oracle and SAP releases, and changing passwords for database users are provided. Proper setup is critical to prevent unauthorized database access and maintain system integrity.

Key words :
'create user ops$sapservice<sapsid> default tablespace psapuser1d temporary tablespace psaptemp identified externally, 'create user ops$<sapsid>adm default tablespace psapuser1d temporary tablespace psaptemp identified externally, sqlplus> create user ops$<sid>adm identified externally, terms sql netv2sql netv1ops$ops$password changechanging, oracle network protocol sql net v2, ''connect internal''alter user sapr3 identified, 'connect internal' 'alter user sapr3 identified, windows nt sql net v1, service sap<sapsid>_<instance_id>, sqlplus> connect /    sqlplus> grant select

Related Notes :

575280	Add info about upgrade to SAP Web AS 6.20 ORACLE 9.2.0
491598	Additional info on upgrading to SAP Web AS 6.20 ORACLE 8.1.x
437648	DB13: External program terminated with exit code 1/2
401721	on upgrading to SAPWeb AS 6.10 ORACLE
400241	Problems with ops$ or sapr3 connect to Oracle
357194	ORA-00900 when importing SQL scripts
303461	Additions to Upgrade to Basis 4.6D Oracle
201874	Additions for upgrade to 4.6C/4.6C SR1/4.6C SR2 Oracle
186119	Restricting DB access to specific hosts
134592	Importing the SAPDBA role (sapdba_role.sql)
95719	SAPDBA/BRBACKUP: ORA-1031 after migration to Oracle8
93292	Additional Info: Upgrading to 4.0A ORACLE
89655	ORA-1004:"default username feature not supported"
8523	DB backups using CCMS do not work