Knowledge Management

Question:
One of the test system down. Some errors occured as " R/3 Basis System:Initialization DB-Connect Failed,Return Code 000256".
Sapdba can NOT run as "Envir./Reg. ORACLE_SID not set."
Can any give me any advice?
Thanks in advance.
Answer:
You check env for user ora<sid>.
for UNIX:
command:
su - ora<sid>
#env
output:
ORACLE_SID = <SID>
OARCLE_HOME = /oracle/<SID>/817..
etc.
If you doesnt set thi enviroment:
You check file .dbenv<hostname>.sh or dbenv<hostname>.cs in home directory for user ora<sid>.
for WinNT:
logon as user <sid>adm
command prompt:
#set
output:
ORACLE_SID = <SID>
OARCLE_HOME = /oracle/<SID>/817..
etc.
hrusovr
Answer:
Thanks for hrusovr.
Now i have solve sapdba problem through add the environment variable to the windows 2000 via [Control panel],[System],[Advanced],[Environment variable].
But I still can NOT connect to the Oracle database.
Any advice?
Best regards,
Answer:
Check your ORACLE_SID once again and see whether services are running or not.
ARE YOU ABLE TO START DB MANUALLY ??
Answer:
Hi donaldhe
I also got the same problem.Whenever I have installed the oracle from the sap cds I got a problem at the step DBRESET.At that time the sap installation is not giving
any error but it is just strukunig.What I think is SAP installation
is connecting to the database first time during installation at this step.
But oracle is not available at that time.So it is strukuing.When I check
in services both oracle tnslistener and oracleC11 are running.
I tried to connect with sqlplus to connect to database but unable to do.
After then I have installed oracle8i(Not with CD i got with sap).At this time
DBRESET step has been processed successfully.But after loading the data, at ANALYZINGDATABASE
step installation is using SAPDBA.At this time installation is failing.
I tried to run the sapdba from console.Then Errorrs likd DLL files are not found have arised.
Then I got those DLLS from SAP ORACLE CD and copied to c:\winnt\system32.
Then when I run SAPDBA problem like ORACLE_SID is not prsent came.
So I set that.Then error like sapbackup is not set. I have done setting for it.
I got many errors like(varibles are not setted) this.After rsetting all varibales
sapdba is not giving any error , but no response.
I have given the following command
sapdba -analyze DB....
I have some couple of questions.
1)Is it possible to load sap oracle from the cds other than sap.
2)SAP is creating one database instance C11.What are the username and password for it.
3)During installation r/3 setup processes the steps from centaldb.r3s.There are many variables defind in the
centaldb.r3s.How can I find the values of variable during the setiup.
If any one have idea on these one please help me.I am installing on win2000 server.
service pack 3.sep 4.6c. p4 processor and 512 mb ram.
Thanks
vidya
Answer:
you're not by any chance connected to the server via windows terminal server are you?
It causes all sorts of nasties if you are.
Either do the install locally or use pc-anywhere, if you have been using wts.
If you're locally logged on, just ignore me.
dingbat.
Answer:
Dingbat,
Most of the termimal server, PCAnywhere, etc. installation problems can be overcome by setting the LOCAL=<sid> environmental variable for the user doing the install.
Answer:
Check your ORACLE_SID once again and see whether services are running or not.
ARE YOU ABLE TO START DB MANUALLY ??
I can startup or shutdown DB form sapdba.
But when i start the application server from the "SAP System Management Console", can NOT connect to the database.Some errors occured as " R/3 Basis System:Initialization DB-Connect Failed,Return Code 000256" or Return Code 008192.I also find when startup the application server,the "SAP System Management console" do NOT startup the database. In normal, if the database is shutdown, the "SAP system management console" would startup the DB firstly.
The status of the application server is "The MSG_server is running and disp+work.exe is stopped."
Any advice?
Best regards,
Answer:
Dear all,
Now I have solved the problem and SAP works well.
Symptom
1) the sap is shutdown
2) can NOT run sapdba from the windows 2000 command prompt, can not find the sapdba;
3) Restart the SAP from the "SAP system management console",Some errors occured as " R/3 Basis System:Initialization DB-Connect Failed,Return Code 000256".
Cause
The Environment variables are losted.
Solution
1. From a normal SAP system,run the set > c:\test.txt command from the command line,then we get the all environment variables in the file test.txt.
2.From the shutdown SAP system, get the remaining environment variables.
3.Get the diffrence by compare the normal SAP system and shutdown SAP system.
4.On the shutdown SAP system, from [Control panel],[System],[Advanced],[Envrionment variables],[<SYSID>adm variables],Press [New],add the new variables.
5.Please Note: the variable: NLS_LANG=AMERICAN_AMERICA.WE8DEC must be put in the user variables , can NOT be put in the system environment variables.Otherwise,you can NOT startup the Oracle database.
6.when startup SAP from the "SAP system management console",the log is put in the <driver>\usr\sap\<SYSID>\DVEBMGS00\work,you may find more information from dev_w0 etc.
Thanks for sap fans help.
Environment:Windows2000 Server,SAP R/3 46C,Oracle 8.1.7