OraFAQ Forum: Server Administration » New instance not starting

Home » RDBMS Server » Server Administration » New instance not starting (R12 2.6.18-238.el5PAE)

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

New instance not starting [message #501540]

Tue, 29 March 2011 15:05

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 #501594 is a reply to message #501540]

Wed, 30 March 2011 01:20

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You call scripts we don't know what is inside so we can't help.
Try to start it in the good old way: set environment variables, connect as sysdba adn execute "startup".

Regards
Michel

Report message to a moderator

Re: New instance not starting [message #501623 is a reply to message #501594]

Wed, 30 March 2011 03:32

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

Report message to a moderator

Re: New instance not starting [message #501626 is a reply to message #501623]

Wed, 30 March 2011 03:44

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

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

Report message to a moderator

Re: New instance not starting [message #501627 is a reply to message #501626]

Wed, 30 March 2011 03:56

davholla
Messages: 116
Registered: August 2009
Location: London

Senior Member

Michel Cadot wrote on Wed, 30 March 2011 09:44

Quote:
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 ?

Report message to a moderator

Re: New instance not starting [message #501628 is a reply to message #501627]

Wed, 30 March 2011 04:44

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Something 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

Report message to a moderator

Re: New instance not starting [message #501633 is a reply to message #501628]

Wed, 30 March 2011 05:09

davholla
Messages: 116
Registered: August 2009
Location: London

Senior Member

Michel Cadot wrote on Wed, 30 March 2011 10:44

Something 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/

Report message to a moderator

Re: New instance not starting [message #501634 is a reply to message #501633]

Wed, 30 March 2011 05:14

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

which should be Oracle Home?

Only you can know this.

Regards
Michel

Report message to a moderator

Re: New instance not starting [message #501677 is a reply to message #501540]

Wed, 30 March 2011 11:01

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

Report message to a moderator

Re: New instance not starting [message #501678 is a reply to message #501677]

Wed, 30 March 2011 11:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-12547: TNS:lost contact
SQL*Net error when no @TNS_ALIAS is part of connection string indicates OS/networking mis-configuration.

COPY & PASTE commands below & results back here

cat /etc/hosts
uname -a
lsnrctl status

Report message to a moderator

Re: New instance not starting [message #501679 is a reply to message #501677]

Wed, 30 March 2011 11:21

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are you sure you are trying to connect the database you started?
Post result of "env | sort".

Regards
Michel

Report message to a moderator

Re: New instance not starting [message #501680 is a reply to message #501540]

Wed, 30 March 2011 11:28

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

Report message to a moderator

Re: New instance not starting [message #501681 is a reply to message #501680]

Wed, 30 March 2011 11:37

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

Report message to a moderator

Re: New instance not starting [message #501682 is a reply to message #501681]

Wed, 30 March 2011 11:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

PATH should include /d01/oracle/VIS/db/tech_st/11.1.0/bin; but this does not cause the error thrown.

Report message to a moderator

Re: New instance not starting [message #501683 is a reply to message #501682]

Wed, 30 March 2011 11:45

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

...and LIBPATH or LD_LIBRARY_PATH should contain $ORACLE_HOME/lib

Regards
Michel

Report message to a moderator

Re: New instance not starting [message #501685 is a reply to message #501683]

Wed, 30 March 2011 12:25

John Watson
Messages: 8931
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.

Report message to a moderator

Re: New instance not starting [message #501698 is a reply to message #501685]

Wed, 30 March 2011 14:43

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.

Report message to a moderator