Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
     
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Nov 22nd, 2017, 9:41am
News: If you would like to register contact the forum admin
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle General
   General Oracle questions
(Moderator: Pete Finnigan)
   problem with new Database
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: problem with new Database  (Read 4391 times)
mjr
PeteFinnigan.com Newbie
*



I love YaBB 1G - SP1!

   
View Profile |

Posts: 3
problem with new Database
« on: Sep 16th, 2007, 2:41pm »
Quote | Modify

Hi Guys:
I’m doing my first steps in Oracle 10g and first steps to the next certification also.
 
I’ve a little problem at moment to create a new database.
I’m working with Windows 2003 and Oracle 10g 10.2.0
 
The specific problem happened when I did create the second database, then I’ve 2 questions:
 
1- why it don’t create in the windows program menu another menu “Database control – my new database”
 
2 – The listener is not working…now…and it seems like no database is registered.
 
- After that I’ve uninstalled and installed the database again and now with just one database my listener is still crazy.
- The Listener is hire:
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
 
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
 
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = optimus)(PORT = 1521))
)
)
 
It give two errors:
 
Database Error
 
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=optimus)(PORT=15 21)))(CONNECT_DATA=(SERVICE_NAME=base1)))  
 
And in the enterprise manager says:
 
Agent Connection to Instance
Status  
Failed
 
Details  
ORA-12505: TNS:el listener no conoce actualmente el SID proporcionado en el descriptor de conexión (DBD ERROR: OCIServerAttach)
 
I guess it is too easy to some of you.
Thanks a lot for the help
 
Javier
« Last Edit: Sep 16th, 2007, 2:43pm by mjr » IP Logged
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | Next topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright © 2000-2004 Yet another Bulletin Board