New instance not starting [message #501540] |
Tue, 29 March 2011 15:05 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
davholla
Messages: 116 Registered: August 2009 Location: London
|
Senior Member |
|
|
Dear All,
I have successfully installed Oracle R12 on my machine but after rebooting I can not start.
This is what I did
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addlnctl.sh start listener
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
You are running addbctl.sh version 120.1
Starting the database VIS ...
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 29 21:02:42 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
addbctl.sh: exiting with status 9
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
You are running addbctl.sh version 120.1
Starting the database VIS ...
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 29 21:02:42 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
addbctl.sh: exiting with status 9
BTW I have not set $ORACLE_HOME, $ORACLE_BASE, $ORACLE_SID yet.
Mainly because I am not 100% sure what they should be.
[Updated on: Tue, 29 March 2011 15:10] Report message to a moderator
|
|
|
|
Re: New instance not starting [message #501623 is a reply to message #501594] |
Wed, 30 March 2011 03:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
davholla
Messages: 116 Registered: August 2009 Location: London
|
Senior Member |
|
|
I thought that they were standard Oracle scripts.
Anyway when I tried sqlplus
./d01/oracle/VIS/db/tech_st/11.1.0/bin/sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
|
|
|
|
Re: New instance not starting [message #501627 is a reply to message #501626] |
Wed, 30 March 2011 03:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
davholla
Messages: 116 Registered: August 2009 Location: London
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 30 March 2011 09:44Quote:You may need to set ORACLE_HOME to your Oracle software directory
So do so it is the first step I mentioned: "set environment variables".
Regards
Michel
Thank you.
What should I set ORACLE_HOME to be ?
Oracle base is
echo $ORACLE_BASE
/d01/oracle/VIS/apps
Should it be something like
/d01/oracle/VIS/apps/tech_st/10.1.3 ?
|
|
|
|
Re: New instance not starting [message #501633 is a reply to message #501628] |
Wed, 30 March 2011 05:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
davholla
Messages: 116 Registered: August 2009 Location: London
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 30 March 2011 10:44Something like that, only you can know where you installed Oracle.
It is the directory that contains "dbs", "rdbms", "network" and so on.
Take care if you have several Oracle homes (installations) to take the good one.
Regards
Michel
Thanks for that.
I have only one installation I searched for dbs
find / -name dbs -print
/d01/oracle/VIS/apps/tech_st/10.1.2/inventory/filemap/dbs
/d01/oracle/VIS/apps/tech_st/10.1.2/dbs
/d01/oracle/VIS/db/tech_st/11.1.0/dbs
Now both
/d01/oracle/VIS/db/tech_st/11.1.0/
and
/d01/oracle/VIS/apps/tech_st/10.1.2/
Have RDBMS and Network in them -which should be Oracle Home?
I am going to try /d01/oracle/VIS/db/tech_st/11.1.0/
|
|
|
|
Re: New instance not starting [message #501677 is a reply to message #501540] |
Wed, 30 March 2011 11:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
davholla
Messages: 116 Registered: August 2009 Location: London
|
Senior Member |
|
|
After setting Oracle home and Oracle Sid
echo $ORACLE_HOME
/d01/oracle/VIS/db/tech_st/11.1.0/
echo $ORACLE_HOME
/d01/oracle/VIS/db/tech_st/11.1.0/
./addbctl.sh start
You are running addbctl.sh version 120.1
Starting the database VIS ...
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Mar 30 12:56:54 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1318172 bytes
Variable Size 427819748 bytes
Database Buffers 629145600 bytes
Redo Buffers 13049856 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
addbctl.sh: exiting with status 0
But I can not log into Oracle
./sqlplus
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Mar 30 13:00:21 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: apps
Enter password:
ERROR:
ORA-12547: TNS:lost contact
|
|
|
|
|
Re: New instance not starting [message #501680 is a reply to message #501540] |
Wed, 30 March 2011 11:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
davholla
Messages: 116 Registered: August 2009 Location: London
|
Senior Member |
|
|
./lsnrctl status
LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 30-MAR-2011 13:24:24
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias VIS
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 30-MAR-2011 13:15:39
Uptime 0 days 0 hr. 8 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /d01/oracle/VIS/db/tech_st/11.1.0/network/admin/VIS_localhost/listener.ora
Listener Log File /d01/oracle/VIS/apps/diag/tnslsnr/localhost/vis/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "VIS" has 2 instance(s).
Instance "VIS", status UNKNOWN, has 1 handler(s) for this service...
Instance "VIS", status READY, has 1 handler(s) for this service...
Service "VIS_XPT" has 1 instance(s).
Instance "VIS", status READY, has 1 handler(s) for this service...
The command completed successfully
Not quite sure why we have so many instances - it looks like some of the attempts that I thought had failed didn't!
cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
uname -a
Linux localhost.localdomain 2.6.18-238.el5PAE #1 SMP Tue Jan 4 15:50:36 EST 2011 i686 i686 i386 GNU/Linux
|
|
|
Re: New instance not starting [message #501681 is a reply to message #501680] |
Wed, 30 March 2011 11:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
davholla
Messages: 116 Registered: August 2009 Location: London
|
Senior Member |
|
|
To be honest I am not sure of anything after trying to install R12
env | sort
_=/bin/env
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=localhost.localdomain
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
OLDPWD=/
ORACLE_BASE=/d01/oracle/VIS/apps/
ORACLE_HOME=/d01/oracle/VIS/db/tech_st/11.1.0/
ORACLE_SID=VIS
PATH=/usr/local/jdk1.6.0_24/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
PWD=/d01/oracle/VIS/db/tech_st/11.1.0/bin
SCRIPTS2=/d01/oracle/VIS/inst/apps/VIS_localhost/admin/scripts/
SCRIPTS=/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=xterm
USER=oracle
XAUTHORITY=/home/oracle/.xauthz57ujK
|
|
|
|
|
Re: New instance not starting [message #501685 is a reply to message #501683] |
Wed, 30 March 2011 12:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
The install will have generated a set of scripts that set your environment. Do not attempt to hack it by setting the variables interactively! There are far too many of them.
Look for a script called something like VIS_localhost.env and source it. Then you shoud be able to run the startup scripts for the database tier. Then search for APPS.env, and source that. Then run the adstrtal.sh script.
|
|
|
Re: New instance not starting [message #501698 is a reply to message #501685] |
Wed, 30 March 2011 14:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
davholla
Messages: 116 Registered: August 2009 Location: London
|
Senior Member |
|
|
Thank you all for your help.
I went to VIS_localhost.env and coppied all the variables and added them to .bash_profile.
I could then start the database and the application tiers.
/d01/oracle/VIS/inst/apps/VIS_localhost/admin/scripts
Using
./adstrtal.sh
Thank you all again - I do have another couple of questions but I will start new threads for them.
|
|
|
|
|