This content has been marked as final. Show 5 replies
I should say that I assume that the .bash_profile is being exectuted.
This happens on both database servers and WebLogic servers.
The prompt for a SID (or WebLogic home) is done in the oracle users .bash_profile and not as part of the system startup.
When the server hits certain run levels (reboot, shutdown, startup) a script is run to startup or stop (as appropriate) the grid agent. The agent runs as the user oracle, which has a .bash_profile that prompts for the SID.
When a reboot, shutdown or power on is given, it goes through the process, but then executes the command . oraenv (somehow), which prompts for a SID. In these situations, the prompt is only displayed on the console. If these commands are given from a SSH session, you do not see the prompt.
The process will hang until the . oraenv response is given.
This began when the grid agent was installed on these servers.
I don't know why it would be executing the .bash_profile for oracle, since this is not interactive (kinda like cron).
You need to provide more details about your shutdown procedure for anyone to pin point the problem.
Having .oraenv in the login script to prompt the user is silly. Instead export the variables or at least use:
. oraenv -s
I asked for the database version because it is not irrelevant. In fact the shutdown and startup and use of the dbshut and dbstart scripts 10g and 11g are different.
You probably have an rc.init script to handle automatic shutdown and startup. I suggest to verify you properly defined the environment in the script and do not use a dash (-) with the su command, since this will reset the environment defined in the script and perform a login. You may have picked up a Init script example from the Internet that is incorrect.
Database version is 18.104.22.168. WLS: 10.3.4/10.3.5 FMW 22.214.171.124
We have the .oraenv in the oracle user profile, because we have multiple databases and/or WebLogic homes on each server.
I shut the database and listener down (shutdown immediate). Not using dbshut/dbstart. Also, all starting and stopping database and WebLogic processes are manual and not automatic. Basically same with the WebLogic server stopping all WebLogic processes. All using an SSH session.
At that point from the shell prompt, issue “reboot”, “shutdown now”. The problem also occurs when the system is starting up.
Again, all database, listener, WebLogic processes are started/stopped manually.
In the rc#.d are scripts that the Oracle Agent installed to either start or stop the agent, as appropriate. This is what I believe is executing the .bash_profile.