I am new with CentOs. I've followed this instructions:
http://www.jameskoopmann.com/docs/Install_Oracle11gCentOS5.htm
and correctly installed Oracle 11g on a Centos 5.4 server.
But I can not run oracle database. I made /etc/init.d/oracle and configured it, but this just only starts the LISTENER (checked by "ps -fea | grep oracle")
Then i've tried to connect with "oracle" user by "sqlplus", and when it runs error "ORA-12514" comes up.
I would appreciate your help.
Oracle 11.2.0 instalation complete but can't run
-
- Retired Moderator
- Posts: 18276
- Joined: 2006/12/13 20:15:34
- Location: Tidewater, Virginia, North America
- Contact:
Oracle 11.2.0 instalation complete but can't run
Welcome to the CentOS fora. I'm not an Oracle user, so will just recommended the reading for new users:
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14274&forum=47]Readme First[/url]
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14408&forum=47]Installing Software[/url]
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14273&forum=47]Where to Find Answers[/url]
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=25128&forum=47]How to provide information about your system[/url]
Hopefully someone who has a clue about Oracle can answer your questions.
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14274&forum=47]Readme First[/url]
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14408&forum=47]Installing Software[/url]
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=14273&forum=47]Where to Find Answers[/url]
[url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=25128&forum=47]How to provide information about your system[/url]
Hopefully someone who has a clue about Oracle can answer your questions.
Re: Oracle 11.2.0 instalation complete but can't run
[quote]
meryniki wrote:
I am new with CentOs. I've followed this instructions:
http://www.jameskoopmann.com/docs/Install_Oracle11gCentOS5.htm
and correctly installed Oracle 11g on a Centos 5.4 server.
But I can not run oracle database. I made /etc/init.d/oracle and configured it, but this just only starts the LISTENER (checked by "ps -fea | grep oracle")
Then i've tried to connect with "oracle" user by "sqlplus", and when it runs error "ORA-12514" comes up.
I would appreciate your help.[/quote]
1) Did you run the Database Configuration Assistant after and create a database? The linked page specifically instructs to NOT create one during the Oracle install and to do so afterward. If you did not, log in as the oracle user and run
[code]dbca &[/code]
This starts the Database Configuration Assistant GUI and walks you through creating a database.
2) The ORA-12514 error usually indicates a problem with a file called "tnsnames.ora" which Oracle uses as an "address book" of database instances. The dbca utility may or may not automatically create/update this file with new database information; if not, a Google search for "configure tnsnames.ora" will give you what you need to create a correctly-formatted entry for your database.
meryniki wrote:
I am new with CentOs. I've followed this instructions:
http://www.jameskoopmann.com/docs/Install_Oracle11gCentOS5.htm
and correctly installed Oracle 11g on a Centos 5.4 server.
But I can not run oracle database. I made /etc/init.d/oracle and configured it, but this just only starts the LISTENER (checked by "ps -fea | grep oracle")
Then i've tried to connect with "oracle" user by "sqlplus", and when it runs error "ORA-12514" comes up.
I would appreciate your help.[/quote]
1) Did you run the Database Configuration Assistant after and create a database? The linked page specifically instructs to NOT create one during the Oracle install and to do so afterward. If you did not, log in as the oracle user and run
[code]dbca &[/code]
This starts the Database Configuration Assistant GUI and walks you through creating a database.
2) The ORA-12514 error usually indicates a problem with a file called "tnsnames.ora" which Oracle uses as an "address book" of database instances. The dbca utility may or may not automatically create/update this file with new database information; if not, a Google search for "configure tnsnames.ora" will give you what you need to create a correctly-formatted entry for your database.