02-15-2008
Database can't start automatically on solaris
Hi,
I have installed oracle 9i on solaris 10 sucessfully. I have configured listener & tnsname.ora file sucessfuly. Even i can start database manully by starting listener first and from sqlplus promt data base sucessfully. Now i want to start the database automatically after system reboots.
I alrady have set environment in profile, also created the dbora file in /etc/init.d and linked it with rc0.d and rc2.d. Also i have set the oracle sid & home in /etc/var/opt/oracle/oratab file.
After restarting the server i have get log in log file
as
below
SQL> Connected to an idle instance.
SQL> ORA-27100: shared memory realm already exists
SVR4 Error: 17: File exists
SQL> Disconnected
So please guide me how would overcome this problem.
thanks
Sv.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Postfix has an initscript just like sendmail did so while logged in as root, simply type: ntsysv and select postfix.
The message above is from the Redhat postifx FAQ. I tried running ntsysv and postfix is not listed as a selection. I can start postfix manually without any problems, but I need... (2 Replies)
Discussion started by: kmgrady01
2 Replies
2. Solaris
How to start Oracle database automatically when after SunSolaris is being re-booted?
TIA,
Greg (3 Replies)
Discussion started by: greg0320
3 Replies
3. Shell Programming and Scripting
hi all
How can I make a program start up automatically after the computer restart/startup in fedora?
something like:
... Establish a shell then run some of command code.
Thanks for Help!! (1 Reply)
Discussion started by: munna_dude
1 Replies
4. Ubuntu
Hi masters,
I am still learning trades in kernel. I am trying to learn the basic of daemon programming. Can any one tell me how can I start a daemon automatically during boot up. I will be greatfull if anyone post some example code to the above task.
Also what are... (3 Replies)
Discussion started by: iamjayanth
3 Replies
5. Shell Programming and Scripting
I have created a script file named 'start-jboss'
-------------------------------------------------
#!/bin/sh
# For starting Jboss
JAVA_HOME=/home/argole/jdk/jdk1.6.0_10
export JAVA_HOME
cd /home/argole/server/jboss-4.2.0.GA/bin
echo "Starting JBOSS server"
nohup ./run.sh -c... (25 Replies)
Discussion started by: shiraz
25 Replies
6. UNIX and Linux Applications
Can any body give me the script to start postgre SQL 8.3.1 when boot linux? (2 Replies)
Discussion started by: shiraz
2 Replies
7. UNIX for Advanced & Expert Users
Hello All
i have a question related to some services,i want to start some services with server linux centos.
i make "chkconfig httpd on" and "chkconfig asterisk on",but when i verify with chkconfig --list i found
httpd 0: off 1: off 2: on 3: on 4: on 5: on 6:... (6 Replies)
Discussion started by: bernard12
6 Replies
8. Ubuntu
Hi all http://ubuntuforums.org/images/smilies/smiley-faces-80.gif,
I am customizing the LIVE CD of Xubuntu 12.04.. I removed the ubiquity package and changed the live username and hostname using uck-gui.. I am almost done with the customization. Now after the splash screen , the text in motd... (1 Reply)
Discussion started by: selvarajvss
1 Replies
9. Linux
Can anyone tell me how to start pc automatically when power comes,
here I just want to start server automatically, on boot, my server starts automatically because I have written some startup commands in rc.local file but if power fails, then how can I boot automatically (2 Replies)
Discussion started by: Akshay Hegde
2 Replies
10. Red Hat
Hello,
I am in the process of learning Linux OS.
How do I run the below lines of code automatically as root on server startup.
cd /opt/program_folder/ServiceManager/bin
nohup ./servce_manager DEV &
Currently, as soon as the server is up and running I log in as root (as this... (6 Replies)
Discussion started by: rparavastu
6 Replies
LEARN ABOUT DEBIAN
sql::translator::parser::dbi
SQL::Translator::Parser::DBI(3pm) User Contributed Perl Documentation SQL::Translator::Parser::DBI(3pm)
NAME
SQL::Translator::Parser::DBI - "parser" for DBI handles
SYNOPSIS
use DBI;
use SQL::Translator;
my $dbh = DBI->connect('dsn', 'user', 'pass',
{
RaiseError => 1,
FetchHashKeyName => 'NAME_lc',
}
);
my $translator = SQL::Translator->new(
parser => 'DBI',
dbh => $dbh,
);
Or:
use SQL::Translator;
my $translator = SQL::Translator->new(
parser => 'DBI',
parser_args => {
dsn => 'dbi:mysql:FOO',
db_user => 'guest',
db_password => 'password',
}
);
DESCRIPTION
This parser accepts an open database handle (or the arguments to create one) and queries the database directly for the information.
The following are acceptable arguments:
o dbh
An open DBI database handle. NB: Be sure to create the database with the "FetchHashKeyName => 'NAME_lc'" option as all the DBI
parsers expect lowercased column names.
o dsn
The DSN to use for connecting to a database.
o db_user
The user name to use for connecting to a database.
o db_password
The password to use for connecting to a database.
There is no need to specify which type of database you are querying as this is determined automatically by inspecting
$dbh->{'Driver'}{'Name'}. If a parser exists for your database, it will be used automatically; if not, the code will fail automatically
(and you can write the parser and contribute it to the project!).
Currently parsers exist for the following databases:
o MySQL
o SQLite
o Sybase
o PostgreSQL (still experimental)
Most of these parsers are able to query the database directly for the structure rather than parsing a text file. For large schemas, this
is probably orders of magnitude faster than traditional parsing (which uses Parse::RecDescent, an amazing module but really quite slow).
Though no Oracle parser currently exists, it would be fairly easy to query an Oracle database directly by using DDL::Oracle to generate a
DDL for the schema and then using the normal Oracle parser on this. Perhaps future versions of SQL::Translator will include the ability to
query Oracle directly and skip the parsing of a text file, too.
AUTHOR
Ken Y. Clark <kclark@cpan.org>.
SEE ALSO
DBI, SQL::Translator.
perl v5.14.2 2012-05-01 SQL::Translator::Parser::DBI(3pm)