 How to start/access additional database created from command line [message #390655] |
Mon, 09 March 2009 03:36  |
rajthampi
Messages: 28
Registered: December 2006
Location: Kuwait
|
Junior Member |
|
|
Hi guys
I just had completed creating additional database for testing purposes. Seems everything during the creation of the database were pretty successful.
However I am confused with following:
How I can establish a successful connection to the new database I created. The new database name is 'ORA10'. I had a full enterprise installation the database created defaul is 'local'.
Should I need to create an additional listner for the new database?
Appreciate incase if somebody would provide me the guidelines.
Thanks and regards,
|
|
|
|
| Re: How to start/access additional database created from command line [message #390660 is a reply to message #390655] |
Mon, 09 March 2009 03:58  |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
 
|
|
What's your database version ( 4 digit)
What's your Operating System??
>>How to start/access additional database created from command line
Try
In Windows
set ORACLE_SID=ORA10
sqlplus "/as sysdba"
startup
In Unix/Linux
export ORACLE_SID=ORA10
sqlplus "/as sysdba"
startup
>>How I can establish a successful connection to the new database I created
sqlplus username/password@Connection String [Updated on: Mon, 09 March 2009 04:03] Report message to a moderator |
|
|
|
|
|
| Re: How to start/access additional database created from command line [message #390665 is a reply to message #390660] |
Mon, 09 March 2009 04:04 |
rajthampi
Messages: 28
Registered: December 2006
Location: Kuwait
|
Junior Member |
|
|
OS: Windows XP SP3
Database: ORACLE 10G 10.1.0.2
When I tried your tip, I was getting the following error:
D:\oracle\product\10.1.0>set ORACLE_SID=ORA10
D:\oracle\product\10.1.0>sqlplus "/as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on Mon Mar 9 12:02:13 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: sys
Enter password:mypassword
ERROR:
ORA-12560: TNS:protocol adapter error
Thank you very much for the reply.
|
|
|
|
|
|
|
|
|
|
| Re: How to start/access additional database created from command line [message #390672 is a reply to message #390669] |
Mon, 09 March 2009 04:19 |
rajthampi
Messages: 28
Registered: December 2006
Location: Kuwait
|
Junior Member |
|
|
Hello Babu
I managed to start the database following your tips. Ran a select * from tab command and exit from the SQL prompt.
Tried to connect as you have mentioned with your last post
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
D:\oracle\product\10.1.0>sqlplus sys/mypassword@ora10 as sysdba;
SQL*Plus: Release 10.1.0.2.0 - Production on Mon Mar 9 12:14:34 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12541: TNS:no listener
I am sure I haven't made certain configurations why which I am getting this error. Could you please help me with this also?
Thanks and regards,
|
|
|
|
|
|
| Re: How to start/access additional database created from command line [message #390680 is a reply to message #390678] |
Mon, 09 March 2009 04:37 |
rajthampi
Messages: 28
Registered: December 2006
Location: Kuwait
|
Junior Member |
|
|
You are right. Finally I managed to connect once after starting the listener which was down using lsnrctl start. However, I did try to start the listner service from the services.msc control panel many times, still was having the same error that TNS error.
Babu, when I installed oracle in my computer, I had created a database during the installation and the ORA10 database is an additional database mostly for learning and testing purpose.
Is it possible for me to run both the database instances at the same time? (My machine has enough resources) or I have to stop on database instance and start the other one manually following your tips?
Thanks for all the assistance you had provided.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to start/access additional database created from command line [message #391099 is a reply to message #391037] |
Wed, 11 March 2009 00:53 |
rajthampi
Messages: 28
Registered: December 2006
Location: Kuwait
|
Junior Member |
|
|
Dear Michel
My primary role at work is to develope oracle applications. Hence my exposure to database related activities were minimal until recent when started R12 implementation and I was asked to set up a test database.
I had come across a number of documents, took the bits from them and managed to get everything online. I had a chance to download the document you pointed yesterday only and yet to go through it.
I thank you and Babu (GentleBabu) for all the assistances provided.
Regards
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
